1Z0-062 Oracle Exam Questions and Free Practice Test

Question 25

Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.)

A. The root container can be flashed back without flashing back the pluggable databases (PDBs).

B. To enable flashback database, the CDB must be mounted.

C. Individual PDBs can be flashed back without flashing back the entire CDB.

D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

E. ACDB can be flashed back specifying the desired target point in time or an SCN, but not a restore poin

Correct Answer:ABD

Question 26

Which set of statements is true about data dictionary views?
1. They are stored in the SYSTEM tablespace.
2. They are based on virtual tables.
3. They are owned by the SYS user.
4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5. The V$FIXED_TABLE view can be queried to list the names of these views.
6. They are owned by the SYSTEM user.

A. 2, 5, and 6

B. 1, 2, and 3

C. 1 and 3

D. 2, 3, 4, and 5

Correct Answer:C
References: https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002

Question 27

You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters:
1Z0-062 dumps exhibit
Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)

A. The backup can be used as an incremental level 0 backup.

B. The database instance must be shut down to take the backup.

C. The database must be in MOUNT state to take the backup.

D. The backup consists of blocks that have been formatted.

E. The system Change Number (SCN) is the same for all the data files in the backu

Correct Answer:BE

Question 28

You find this query being used in your Oracle 12c database:
1Z0-062 dumps exhibit
Which method a used by the optimizer to limit the rows being returned?

A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

D. A TOP-N query is created to limit the rows to 20 percent of the total rows

Correct Answer:C

Question 29

Which three activities are supported by the Data Recovery Advisor? (Choose three.)

A. Advising on block checksum failures

B. Advising on inaccessible control files

C. Advising on inaccessible block change tracking files

D. Advising on empty password files

E. Advising on invalid block header field values

Correct Answer:ABE
* Data Recovery Advisor can diagnose failures such as the following:
/ (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on
/ (A, E) Physical corruptions such as block checksum failures and invalid block header field values
/ Inconsistencies such as a datafile that is older than other database files
/ I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files)
* The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

Question 30

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud

A. An Oracle database instance can support only one DBaaS instance.

B. ADBaaS instance can support only one Oracle database instance.

C. An Oracle database instance can support multiple DBaaS instances.

D. ADBaaS instance can support multiple Oracle database instances.

E. ADBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).

Correct Answer:D

START 1Z0-062 EXAM