1Z0-063 Exam Questions

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command: S>sqlldrhr/hr@pdb table=employees Which two statem...

Which two statements are true about scheduling operations in a pluggable database (PDB)?

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure: CR...

The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL...

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. You rename the undotbs undo tablespace: ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is true?

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and a...

You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/...

Users report this error message when inserting rows into the orders table: ERROR atline1: ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES You determine...

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

View the SPFILE parameter settings in the Exhibit. You issue this command and get errors: SQL> startup ORA-00824:cannot setSGAJTARGET or MEMORY_TARGET due to existing internal sett...

Which two statements are true about unified auditing?

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno...

Which two statements are true about tablespaces in multitenant container databases (CDBs)?

You issue the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> BACK...

Which two statements are true about a multitenant architecture?

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

Which two statements are true about dropping a pluggable database (PDB)?

Which three statements are true about unplugging a pluggable database (PDB)?

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: $ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oracle base for ORACLE_HOME=/u...

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running. Which two statements are true?

You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and youneed to avoid any out...

Examine the output: SQL > ARCHIVE LOGLIST Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence376 Next...

Identify three benefits of unified auditing.

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You...

Examine the command used to perform an incrementallevel-0 backup: RMAN> BACKUPINCREMENTALLEVEL0DATABASE; To enable block change tracking, after the incremental level 0 backup, you...

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). The following are the possible steps to accomplish this task:...

Which four actions are possible during an Online Datafile Move operation?

Which two are prerequisites for setting up Flashback Data Archive?

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows: SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBE...

Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; Which two statements a...

Examine the commands: SQL> ALTER SESSION SET RECYCLBIN = ON; Session altered. SQL> DROP TABLE emp; --(First EMP table) Total dropped. SQL> CREATE TABLE emp (id NUMBER CONSTRAINT em...

In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incom...

The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction. Which type of lock would this scenario lead to?

Which three factors influences the optimizer's choice of an execution plan?

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. W...

Which three RMAN persistent settings can be set for a database?

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it h...

You must unload data from the orders, order_items, and products database tables to four files using the External Tables. CREATE TABLE orders_ext (order_id, order_date, product_id,...

You issue the command: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which statement is true about the command?

Which two are prerequisites for creating a backup-based duplicate database?

You are administering a multitenant container database (CDB) cdb1. Examine the command and itsoutput: SQL>show parameterfile NAMETYPEVALUE db_create_file_deststring db_file_name_co...

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the comma...

Examine the command: $expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statem...

Which three statements are true about a job chain?

You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Increm...