oracle database 11g dba 2 1z0-053 : May 2016 Edition

Approved of 1Z0-053 test question materials and preparation for Oracle certification for IT specialist, Real Success Guaranteed with Updated 1Z0-053 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration II exam Today!

2016 May 1Z0-053 Study Guide Questions:

Q161. Which of the following datatypes store time-zone information in the database? 

A. TIMESTAMP

B. DATE

C. TIMESTAMP WITH TIME ZONE

D. TIMESTAMP WITH LOCAL TIME ZONE

E. DATETIME

Answer: C


Q162. View the following SQL statements:

Transaction T1

INSERT INTO hr.regions VALUES (5,'Pole');

COMMIT;

Transaction T2

UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5;

COMMIT;

Transaction T3

UPDATE hr.regions SET region_name='North and South Poles' WHERE

region_id = 5;

You want to back out transaction T2. Which option would you use? 

A. It is possible, but transaction T3 also backs out.

B. It is possible with the NOCASCADE_FORCE option.

C. It is possible with the NONCONFLICT_ONLY option.

D. It is not possible because it has conflicts with transaction T3.

Answer: B


Q163. When a job exceeds the date specified in its END_DATE attribute, which of the following will happen? (Choose all that apply.)

A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.

B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.

C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE.

D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE.

E. The STATE column of the job table will be set to COMPLETED for the job.

Answer: ABE


1Z0-053  test question

Leading 1z0-053 latest dumps:

Q164. View the Exhibit to observe the error.


You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?

A. setting the PRE_PAGE_SGA parameter to TRUE

B. locking the SGA in memory

C. increasing the value of SGA_MAX_SIZE

D. automatic memory management

Answer: D


Q165. As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?

A. Shut down the database

B. Clear the online redo log

C. Back up the database

D. Checkpoint the database

E. Call Oracle support

Answer: D


Q166. Examine the following commands and their output:

SQL> SELECT ename, sal FROM emp WHERE ename='JAMES' ENAME SAL JAMES 1050

SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES'

1 row updated.

SQL> SELECT ename, sal FROM emp WHERE ename='JAMES' ENAME SAL JAMES 2310

View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.

What could be the possible cause for the query not displaying any row?

Exhibit:


A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

Answer: B


1Z0-053  test question

Precise oracle dump 1z0-053:

Q167. Examine the following command used to perform incremental level 0 backup:

RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

To enable the block change tracking, after the incremental level 0 backup you issued the following command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ 

rman_change_track.f'

To perform incremental level 1 cumulative backup, you issued the following command:

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

Which two statements are true in the above situation? (Choose two.)

A. The block change tracking data will be used only from the next incremental 0 backup.

B. The incremental backup will use change tracking data for accomplishing the backup.

C. The incremental backup will not use change tracking data for accomplishing the backup.

D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

Answer: AC


Q168. When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?

A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.

B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET.

C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the

V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management.

D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management.

Answer: A


Q169. Evaluate the following command and its output:

SQL>SELECT * FROM dba_temp_free_space;

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE

---------------------------- -------------------------- ---------------------------- ------------------

LMTEMP 250609664 101048576 149561088

Which two statements correctly interpret the output? (Choose two.)

A. FREE_SPACE indicates only the space that is currently unallocated.

B. ALLOCATED_SPACE indicates only the space currently allocated and in use.

C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.

D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.

E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

Answer: DE


Q170. View the Exhibit.

You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?

Exhibit:


A. Disk mirroring and striping would be done automatically

B. The database files would be managed by the operating system's file system

C. DBCA would not save the database files by using Optimal File Architecture (OFA)

D. The data files are automatically spread across all available storage devices to optimize performance and resource utilization

Answer: B



see more 1Z0-053 dumps