Your database is open in ARCHIVELOG mode.
LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes
place.
What is the outcome?
A. The archivelog entries are made in the diagnostic destination and when space is available, new archivelogs are generated
B. Obsolete backups are automatically deleted and new archivelogs are generated
C. All active sessions hang until the database administrator (DBA) makes space available in the FRA
D. No archivelogs are generated
E. All active sessions are disconnected and their transactions rolled back
Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)
A. UNDO segments grow or shrink automatically
B. UNDO tablespaces are created and dropped automatically
C. UNDO segments are created and dropped automatically
D. UNDO tablespaces are brought ONLINE or OFFLINE as required
E. All transactions belonging to a single session use the same UNDO segment
Which two are true about roles? (Choose two.)
A. A role can be created only by a user with the SYSDBA privilege.
B. A role can be granted only multiple system privileges not multiple object privileges.
C. A role can be granted to another role.
D. A role can be password-protected.
E. Only one default role can be granted to a user.
Which four are true about the tools used to administer Oracle databases? (Choose four.)
A. SQL *Plus can be used to create databases
B. DBCA can be used to upgrade databases
C. RMAN can be used to start up Oracle instances
D. SQL *Plus can be used to start up Oracle instances
E. SRVCTL can be used to shut down Oracle instances
F. Data Pump can be used to load data from text files
Which three are true about UNDO data? (Choose three.)
A. It is used during online backups to guarantee their consistency
B. It is used to roll back failed transactions
C. It is used to recover dropped tables by using FLASHBACK TABLE ... TO BEFORE DROP
D. It is used to rewind a database by using FLASHBACK DATABASE
E. It is used to provide read consistency
F. It is used to enable ROLLBACK statements to roll back uncommitted updates
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-052 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.