Oracle Database 12c: Advanced Administration - 1z1-063 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two statements are true regarding SecureFile lobs? (Choose two.)

A. Fragmentation is minimized by using variable-sized chunks. B. They can be used only for nonpartitioned tables. C. They support random reads and writes of encrypted LOB data. D. The amount of undo retained is user controlled.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

You take regular backups of one of your production databases by using RMAN with a recovery catalog.
You have added two new tablespaces to this database which must be included in future backups.
Which process occurs which allows the new backups to contain the new datafiles?

A. The recovery catalog is synchronized from the target database control file with a full resync at the next backup. B. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup. C. The target database control file is synchronized from the recovery catalog with a full resync at the next backup. D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Discussion 0

Correct Answer: C Vote an answer

Question 3

Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

A. The undo data that existed for versions of rows before the change to the table structure is invalidated. B. Supplemental logging is not enabled for the database. C. Undo retention guarantee is not enabled. D. Flashback Data Archive is full after the first update statement. E. The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.

Discussion 0

Correct Answer: A Vote an answer

Question 4

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

A. an index cluster B. a hash cluster C. a sorted hash cluster D. a heap table with a rowid column E. a partitioned table

Discussion 0

Correct Answer: C Vote an answer

Question 5

Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the RESETLOGS option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.

A. 2, 3, 4, 5 B. 6, 3, 4, 5 C. 6, 4, 3, 5 D. 1, 3, 4, 5

Discussion 0

Correct Answer: A Vote an answer

Question 6

You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?

A. The command results in an error because the PDB can be shut down only by a local user. B. The PDB is closed and left in the unmount state. C. The PDB is closed and left in the mount state. D. The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.

Discussion 0

Correct Answer: B Vote an answer

Question 7

Examine these actions:
1. Log in to CDB$ROOT as a user with the SYSDBA privilege.
2. Log in to the PDB as a user with the SYSKM privilege.
3. Ensure that the CD keystore is open.
4. Ensure that the CDB keystore is closed.
5. Export the PDB key information.
6. Export the CDB key information.
7. Shut down the CDB.
8. Shut down the PDB.
9. Unplug the PDB.
Which of these are required to unplug an encrypted PDB?

A. 2, 3, 6, 8 B. 1, 3, 5, 9 C. 2, 4, 5, 7 D. 1, 3, 5, 8, 9 E. l, 3, 5, 7, 9 F. 1, 4, 5, 7, 9

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 8

Which three statements are true about a job chain? (Choose three.)

A. It cannot have more than one dependency. B. It can be used to implement dependency-based scheduling. C. It cannot invoke the same program or nested chain in multiple steps in the chain. D. It can be executed using event-based or time-based schedules. E. It can contain a nested chain of jobs.

Discussion 0

Correct Answer: B,D,E Vote an answer