1Z0-067 - Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Go back to Oracle

Example Questions

You have a production Oracle 12c database running on a host. You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database. The steps in random order: 1.Create directory structures similar to the production database on all new machines. 2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database. 3.Create a database clone template for the database. 4.Run the Database Configuration Assistant (DBCA) to create the database. 5.Run OUI in graphical mode on each machine. 6.Run OUI in silent mode using the OUI response file. Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention. Which Oracle Database component is audited by default if the Unified Auditing option is enabled? You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX- based Oracle 12c database: CONNECT/AS SYSDBA ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE You then restart the instance and get an error: STARTUP ORA-01031:insufficientprivileges Why does the startup command return the error shown? A user issues a query on the sales table and receives the following error: ERROR at line 1: ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace? Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output: SQL>UPDATEcustomersSETamt_due=amt_due+amt_due*l. 1WHEREcust_name='JAMES'; 1row updated. SQL> ALTER TABLE customers DROP COLUMN old_status; Table Altered SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_r.ame='JAMES'; 1 row updated. SQL> COMMIT; SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN, versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION', amt_due FROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE custname='JAMES';. XIDSTART_SCNEND_SCNOPERATIONAMT_DUE -------------------------- ----------------------- ------------------- ------------------- ------------------------ 07002f00cl03000017063371706337 U3300 Why is it that only one update is listed by the Flashback Version Query? You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table. Which two alter statements will achieve this? Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup In which three situations can you use the backup? Examine the backup requirement for your company: 1) Every Sunday, a backup of all used data file blocks is performed. 2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed. 3) On all the other days, a backup of only the changed blocks since the last day's backup is performed. Which backup strategy satisfies the requirements? Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file? Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true? 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/[email protected] table=employees Which two statements are true about the command? Examine the following set of RMAN commands: RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RKAN> RUN { ALLOCATE CHANNEL chl DEVICE TYPE DISK; EXECUTE SCRIPT arc_backup; } Which statement is true about the RMAN run block execution? Which three statements are true about a job chain? Which two statements are true about Flashback Version Query? Which three requirements must be met before a tablespace can be transported across different platforms? In which three scenarios is media recovery required? You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true? 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: CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2, v_SALARYNUMBER,v_dept_idNUMBER) BEGIN INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king; How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges? You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2. While opening pdb_1, you get an error: SQL> alter pluggable database pdb_1 open; ORA-011S7:cannotidentify/lockdatafile11-seeDBWRtracefile ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf' To repair the failure, you open an RMAN session for the target database CDBSROOT. You execute the following as the first command: RMAN>REPAIRFAILURE; Which statement describes the consequence of the command? You are administering a multitenant container database (CDB). Identify two ways to access a pluggable database (PDB) that is open in read-only mode. You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: 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 do not want to restart the database instance. How can you detect the cause of the degraded performance? Which three statements are true about the SQL*Loader utility? 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 emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) ); Table created. You then execute multiple INSERT statements to insert rows into EMP table and drop the table again: SQL> DROP TABLE emp; -- (Second EMP table) Table dropped. SQL> FLASHBACK TABLE emp TO BEFORE DROP; Which statement is true about the FLASHBACK command? Examine the command used to perform an incremental level-0 backup: RMAN>BACKUPINCREMENTALLEVEL0DATABASE; To enable block change tracking, after the incremental level 0 backup, you issue the command: SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSING FILE'/mydir/rman_change_track.f'; To perform an incremental level-1 cumulative backup, you issue the command: RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE; Which two statements are true in the preceding situation? You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization. Which two backup solutions can be used? Which two statements describe the relationship between a window, a resource plan, and a job class? 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 Incremental backups on all the other days of the week. One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file. Examine the steps involved in the recovery process: 1.Shut down the database instance. 2.Start up the database instance in nomount state. 3.Mount the database. 4.Take the data file offline. 5.Put the data file online. 6.Restore the control file. 7.Restore the database. 8.Restore the data file. 9.Open the database with the resetlog option. 10.Recover the database with the noredo option. 11.Recover the data file with the noredo option. Identify the required steps in the correct order. 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? In which situation can you use Flashback Database? A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command: RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE; Which statement is true about the execution of the command? 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? You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN? Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): SQL> CREATE ROLE c ##role1 CONTAINER-ALL; SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL; SQL>CREATE USER c##adnin IDENTIFIED BY orcl123; SQL>GRANT c##role1 TO c##admin CONTAINER=ALL; SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL; Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role? Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB): 1.Start the RMAN client by using the RMAN target / command. 2.Start the RMAN client by using the OSB user. 3.RMAN creates the backup pieces. 4.Run the RMAN backup command with the sbt channels. 5.OSB creates a backup job and assigns a unique identifier. 6.OSB creates a backup job request through the OSB sbt library. 7.OSB stores metadata about RMAN backup pieces in the OSB catalog. 8.OSB starts the backup operation. 9. OSB updates the RMAN catalog. Identify the required steps/operations performed in correct order. Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB. Examine the list of possible steps required to perform the task: 1.Create a PDB named emp_pdb1. 2.Export the hr_pdb1 PDB by using the full clause. 3.Open the emp_pdb1 PDB. 4.Mount the emp_pdb1 PDB. 5.Synchronize the emp_pdb1 PDB in restricted mode. 6.Copy the dump file to the Data Pump directory. 7.Create a Data Pump directory in the emp_pdb1 PDB. 8.Import data into emp_pdb1 with the full and remap clauses. 9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects. Identify the required steps in the correct order. Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1. RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which statement is true about the execution of this command to back up the database? Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command? You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this? 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> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which three tasks are performed by the BACKUP DATABASE command? Which two statements are true about a common user? You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost. Examine the steps required to recover the database: 1.Restore an autobackup of the server parameter file. 2.Restore the control file. 3. Start up the database instance in nomount state. 4.Mount the database. 5.Restore the data files. 6.Open the database with the resetlogs option. 7.Recover the data files. 8.Set D3ID for the database. Identify the required steps in the correct order. Which three types of failures are detected by the Data Recovery Advisor (DRA)? Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command: SQL>STARTUP Which two statements are true about the successful execution of the command? The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user. A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open. In the CATD3i2c database, you execute the commands: : r-ar. RKAN> CONNECT CATALOG rci2c/[email protected] RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import? Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)? For which two requirements would you use the Database Resource Manager? 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: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.

Study Guides