Online 1z0-083 Practice TestMore Oracle Products >

Free Oracle 1z0-083 Exam Dumps Questions

Oracle 1z0-083: Oracle Database Administration II

- Get instant access to 1z0-083 practice exam questions

- Get ready to pass the Oracle Database Administration II exam right now using our Oracle 1z0-083 exam package, which includes Oracle 1z0-083 practice test plus an Oracle 1z0-083 Exam Simulator.

- The best online 1z0-083 exam study material and preparation tool is here.

4.5

(270 ratings)

Question 1

You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command:
1Z0-083 dumps exhibit
Which three are true? (Choose three.)

A. The restore point is a label for the system change number (SCN) that will be savedtwo years after the archival backup was taken.

B. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C. All archive logs created after this backup are kept for two years.

D. The SPFILE is included in the self-contaied archival backup.

E. The control file is included in the self-contained archival backup.

F. The restore point is a label for the system change number (SCN) before the archival backup was taken.

Correct Answer:CDE

Question 2

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

A. Media Management messages for SBT devices are always written to sbtio.log.

B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.

D. The RMAN LOG command line clause causes output issued during RMAN commandcompilation to bewritten to a log file and to standard output.

E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

F. Media Management messages for SBT devices are written to an Oracletrace file.

Correct Answer:EF

Question 3

Examine the command for creating pluggable database PDB2 in container database CDB2.
1Z0-083 dumps exhibit
Select three options, any one of which is required for it to execute successfully. (Choose three.)

A. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

B. Addonly the CREATE_FILE_DEST clause to the statement.

C. Set only the PDB_FILE_NAME_CONVERT parameter.

D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

E. Enable only OMF.

F. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)

Correct Answer:BDE

Question 4

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.

B. Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.

C. A new PDB is automatically created when importing a non-CDB into a CDB.

D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

E. Moving data from a PDB to anon-CDB is only possible by using transportable tablespace export and import.

F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Correct Answer:DE

Question 5

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

A. Using the Data Recovery Advisor LIST FAILURE command always requires that the databasefor which failures are to be listed is in MOUNT state.

B. A failure can be closed only when it has been repaired.

C. Data Recovery Advisor can be used if a database is closed.

D. The Data Recovery Advisor CHANGE FAILURE command can be used only to changefailure priorities.

E. Data Recovery Advisor can proactively check for failures.

Correct Answer:DE

Question 6

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A. It analyzes a period of time corresponding to the 12 hours of activity.

B. It runs automatically after each AWR snapshot.

C. A DBA can run it manually.

D. Results are written to the alert log.

E. It analyzes a period of time corresponding to the last day of activity.

Correct Answer:BC

START 1z0-083 EXAM