Get real exam questions for 1Z0-062 Oracle Database 12c: Installation and Administration. 100% Free.
Q1. In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exce
Q1. You want to flash back a test database by five hours. You issue this command: SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24); Which two statements are true about this flashback scenario? A. The database must have multiplexed redo logs for the flashback to succeed. B. The database must be MOUNTED for the flashback to succeed. C. The database must use block change tracking for
Q1. Which two are prerequisites for performing a flashback transaction? A. Flashback Database must be enabled. B. Undo retention guarantee for the database must be configured. C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction. D. Supplemental logging must be enabled. E. Recycle bin must be enabled for the database. F. Block change track
Q1. Examine the parameters for your database instance: NAMETYPE VALUE undo_management string AUTO undo_retentioninteger 12 00 undo_tablespace string UNDOTBS1 You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario? A. Undo data is written to flashback logs after 1200 seconds. B. Inactive undo data is retained fo
Q1. Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? A. System privileges apply only to the PDB in which they are used. B. Local users cannot use local system privileges on the schema of a common user. C. The granter of system privileges must possess the set container privilege. D. Common users
Q1. The hr user receiver, the following error while inserting data into the sales table: ERROR at line 1: ORA-01653; unable to extend table HR.SALES by 128 in tablespace USERS On investigation, you find that the users tablespace uses Automnrif Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it. Which two methods would you use to resolve
Q1. Which three statements are true about Oracle Data Pump export and import operations? A. You can detach from a data pump export job and reattach later. B. Data pump uses parallel execution server processes to implement parallel import. C. Data pump import requires the import file to be in a directory owned by the oracle owner. D. The master table is the last object to be exported by the da
Q1. Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file? A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data. B. The SQL* Loader data file myfile1.dat has the column names for the EMP table. C. The SQL* Loader operation fails because
Q1. You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit Character set: AL32UTF8 National character set: AL16UTF16 O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: Version: Oracle Database 12c Release 1 64-bit C
Q1. Which three statements are true about Oracle Data Pump export and import operations? A. You can detach from a data pump export job and reattach later. B. Data pump uses parallel execution server processes to implement parallel import. C. Data pump import requires the import file to be in a directory owned by the oracle owner. D. The master table is the last object to be exported by the da
Q1. In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true? A. The C # # ROLE1 role is created in the root database and all the PDBs. B. The C # # ROLE1 role is created only in the root database because the container clause is not used. C. Privileges are granted to the C##
Q1. Which two statements are true about the RMAN validate database command? A. It checks the database for intrablock corruptions. B. It can detect corrupt pfiles. C. It can detect corrupt spfiles. D. It checks the database for interblock corruptions. E. It can detect corrupt block change tracking files. View AnswerAnswer: A,C Explanation: Block corruptions can be divided Into Interblock
Q1. Which statement is true regarding the startup of a database instance? A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option. B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option. C. There is no difference in the underlying mechanics of the startup w
Q1. Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB. 2. Close all the PDBs. 3. Open the database. 4. Apply the archive redo logs. 5. Restore the data file. 6. Take the SYSAUX tablespace offli
Q1. You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this. A. Missing or sta
Q1. You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions? A. Enable supplemental logging for the database. B. Specify undo retention guarantee for the database. C. Create a Flashback Data Archive in the tablespa
Q1. You use a recovery catalog for maintaining your database backups. You execute the following command: $rman TARGET / CATALOG rman / cat@catdb RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL; Which two statements are true? A. Corrupted blocks, if any, are repaired. B. Checks are performed for physical corruptions. C. Checks are performed for logical corruptions. D. Checks are performed