1Z0-062 - Oracle Database 12c: Installation and Administration
Go back to Oracle
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?
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
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.
Both successful and failed executions
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?
Take the USERDATA tablespace offline 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?
Is used by Oracle to authenticate users for remote database administration.
It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
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?
It must be made up of a database name and a domain name.
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?
Block change tracking will always reduce I/O performed during cumulative incremental backups.
More than one database block may be read by an incremental backup for a change made to a single block.
The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
Which three statements are true about using flashback database in a multitenant container database (CDB)?
To enable flashback database, the CDB must be mounted.
The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
Which two are true concerning a multitenant container database with three pluggable database?
The pluggable databases are patched together.
Pluggable databases are only used for database consolidation.
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?
Effectively implements role separation
Automatically registers the database with Oracle Restart.
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?
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?
Bind Variable Peeking
Adaptive Cursor Sharing
Literals in a SQL statement
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?
2 and 4
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?
AWR Compare Period report
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?
Recover the table using Automated Tablespace Point In Time Recovery.
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?
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
It will detect and advise about chained rows.
It may advise the use of segment shrink for free list managed tables.
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?
3 and 1
Which two statements are true concerning dropping a pluggable database (PDB)?
The PDB must be in mount state.
The PDB must be unplugged.
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?
The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.
Change in the Oracle Database version
Change in the hardware configuration of the database server
Database and operating system upgrade
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?
All users except SCOTT
Which two statements are true about variable extent size support for large ASM files?
The metadata used to track extents in SGA is reduced.
An ASM Instance automatically allocates an appropriate extent size.
Which three activities are supported by the Data Recovery Advisor?
Advising on block checksum failures
Advising on inaccessible control files
Advising on invalid block header field values
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?
The create user command fails if any role with the name Sidney exists in the database.
The user sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.
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?
CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ' S
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?
Place the root container in ARHCHIVELOG mode.
Identify two situations in which the alert log file is updated.
Running a query on a table returns ORA-600: Internal Error.
Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
Which statement is true about Oracle Net Listener?
Service registration with the listener is performed by the process monitor (LREG) process of each database instance.
Which two statements are true about the logical storage structure of an Oracle database?
An extent can span multiple segments,
It is possible to have tablespaces of different block sizes.
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?
They are not affected and continue to function normally.
Which two statements are true about Oracle Managed Files (OMF)?
OMF automatically creates unique file names for table spaces and control files.
OMF may affect the location of the redo log files and archived log files.
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?
Increase the value of the ASM_POWER_LIMIT parameter.
Increase the number of ASMB processes.
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
By default, EM express is available for a database after database creation.
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?
Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
Which three statements are true about adaptive SQL plan management?
It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
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?
Decreasing the value of the IDLE_TIME resource limit in the default profile
Which two statements are true about standard database auditing? (Choose two.)
DDL statements can be audited.
Statements that refer to standalone procedure can be audited.
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?
The operating system group that is specified must have permission to write to the inventory directory.
Which three statements are true about a job chain?
It can contain a nested chain of jobs.
It can be used to implement dependency-based scheduling.
It can be executed using event-based or time-based schedules.
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?
6, 5, 4, 7
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?
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
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?
Use Oracle Managed Files (OMF).
Specify the SEED FILE_NAME_CONVERT clause.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.
Which statement is true regarding the startup of a database instance?
Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.
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?
The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
A primary key constraint can be added on the invisible column.
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?
The size of the PGA cannot grow automatically beyond 500 MB.
Which two statements correctly describe the relationship between data files and logical database structures?
A data file can belong to only one tablespace.
An extent cannot span data files.
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?
by assigning a profile to the user
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
Oracle Recovery Manager (RMAN)
Which statement is true about the Log Writer process?
It writes when a user commits a transaction.
Which three statements are true about Oracle Data Pump export and import operations?
You can detach from a data pump export job and reattach later.
Data pump uses parallel execution server processes to implement parallel import.
The master table is the last object to be exported by the data pump.