1Z0-062 - Oracle Database 12c: Installation and Administration

Go back to Oracle

Example Questions

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length, Consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group; NAMEACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_WAITS CPU_WAIT_TIME ----------------------------------- -------------------- -------------------- --------------------- ---------------- OLTP__ORDER__ENTRY1029690 467 OTHES__GROUPS 0 059823664089 60425 SYS_GROUP 1 02420704 914 19540 DS.S_QUERIES4245946603004 55700 Which two statements are true? You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? Select two. Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB? You Execute the Following command to create a password file in the database server: $ orapwd file = `+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name. What must this name be made up of? You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ` /mydir/rman_change_track.f'; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true? Which three statements are true about using flashback database in a multitenant container database (CDB)? Which two are true concerning a multitenant container database with three pluggable database? What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts? Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1'); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility? You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use? You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege. What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema? You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor? Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME "TO_DATE (`08/20/12' , `MM/DD/YY')"; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema? Which two statements are true concerning dropping a pluggable database (PDB)? A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation? Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements. You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT. You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active? Which two statements are true about variable extent size support for large ASM files? Which three activities are supported by the Data Recovery Advisor? You execute the commands: SQL>CREATE USER sidney IDENTIFIED BY out_standing1 DEFAULT TABLESPACE users QUOTA 10M ON users TEMPORARY TABLESPACE temp ACCOUNT UNLOCK; SQL> GRANT CREATE SESSION TO Sidney; Which two statements are true? As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database. Which command would you execute to create the database link? Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command? Identify two situations in which the alert log file is updated. Which statement is true about Oracle Net Listener? Which two statements are true about the logical storage structure of an Oracle database? Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command: 1snrctl > STOP What happens to the sessions that are presently connected to the database Instance? Which two statements are true about Oracle Managed Files (OMF)? You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c? Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (`SH', `CUSTOMERS', `PUBLISH', `false'); Which three statements are true about the effect of this command? Which three statements are true about adaptive SQL plan management? In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this? Which two statements are true about standard database auditing? (Choose two.) You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true? Which three statements are true about a job chain? 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 offline. 7. Place the SYSAUX tablespace online. 8. Open all the PDBs with RESETLOGS. 9. Open the database with RESETLOGS. 10. Execute the command SHUTDOWN ABORT. Which option identifies the correct sequence to recover the SYSAUX tablespace? You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE; Which is true about the result of this command? You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this? Which statement is true regarding the startup of a database instance? Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table? Examine the memory-related parameters set in the SPFILE of an Oracle database: memory_max_target--6G memory_target=5G pga_aggregate_target=500M sga_max_size=0 sga_target=0 Which statement is true? Which two statements correctly describe the relationship between data files and logical database structures? A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following: 1. The user account must be locked after five unsuccessful login attempts. 2. Data read per session must be limited for the user. 3- The user cannot have more than three simultaneous sessions. 4. The user must have a maximum of 10 minutes session idle time before being logged off automatically. How would you accomplish this? Which Oracle Database component is audited by default if the unified Auditing option is enabled? Which statement is true about the Log Writer process? Which three statements are true about Oracle Data Pump export and import operations?

Study Guides