1z0-052 | Pinpoint Oracle 1z0-052 pdf


P.S. Practical 1z0-052 bundle are available on Google Drive, GET MORE: https://drive.google.com/open?id=1coPK4zSIGsnFOkZgL04vi1Wfgv60RAd7


New Oracle 1z0-052 Exam Dumps Collection (Question 3 - Question 10)

Question No: 3

Note the following structures in your database server:

1. Extents

2. OS Blocks

3. Tablespace

4. Segments

5. Oracle Data Block

Which option has the correct arrangement of these structures from the smallest to the largest?

A. 2, 5, 1, 4, 3

B. 1, 2, 3, 4, 5

C. 5, 2, 1, 3, 4

D. 2, 1, 5, 4, 3

Answer: A

Question No: 4

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

A. No flashback is possible to bring back the ITEM table.

B. The ORDERS table is dropped along with the ITEM table.

C. The dependent referential integrity constraints in the ORDERS table are disabled.

D. The dependent referential integrity constraints in the ORDERS table are removed.

E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.

Answer: A,D

Question No: 5

Which two operations can be performed on an external table? (Choose two.)

A. Create a view on the table

B. Create an index on the table

C. Create a synonym on the table

D. Add a virtual column to the table

E. Update the table using the UPDATE statement

F. Delete rows in the table using the DELETE command

Answer: A,C

Question No: 6

Which two statements are true regarding undo tablespaces? (Choose two.)

A. The database can have more than one undo tablespace

B. The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management

C. Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions

D. An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up

Answer: A,C

Question No: 7

You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.

Which three statements are true about these backups? (Choose three.)

A. The backups would be consistent.

B. The backups would be inconsistent.

C. The backups would be possible only if the database is running in ARCHIVELOG mode.

D. The backups would be possible only if the database is running in NOARCHIVELOG mode.

E. The backups need to be restored and the database has to be recovered in case of a media failure.

Answer: B,C,E

Explanation:

u2022Recovery Manager (RMAX): Oracle Tool that provides a complete solution for the backup, restoration, and recovery needs of the entire database or of specific database files

Question No: 8

Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');

Which statement describes the effect of the above command?

A. Automatic statistics collection is stopped for the CUSTOMERS table

B. Statistics for the CUSTOMERS table are locked and cannot be overwritten

C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

Answer: D

Question No: 9

You executed the following command to perform a backup of the USERS tablespace:

SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP

*

ERROR at line 1:

ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error?

A. The MTTR Advisor is disabled.

B. The database is in NOARCHIVELOG mode.

C. The tablespace is already in backup mode.

D. The Flash Recovery Area is not configured.

Answer: B

Question No: 10

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

A. It is the time period after which the undo data becomes obsolete.

B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.

C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.

D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.

Answer: C

Recommend!! Get the Practical 1z0-052 dumps in VCE and PDF From Examcollection, Welcome to download: http://www.examcollectionuk.com/1z0-052-vce-download.html (New Q&As Version)