Oracle Database 12c Administration 試験
Question No : 1
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?
Question No : 2
In which two scenarios do you use SQL* Loader to load data? (Choose two.)
Question No : 3
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
Question No : 4
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
Question No : 5
Which three statements are true about Flashback Database? (Choose three.)
Question No : 6
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? (Choose two.)
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.
Question No : 7
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output? (Choose three.)
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup
E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
Question No : 8
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.
D: For export jobs, the master table records the location of database objects within a dump file set. / Export builds and maintains the master table for the duration of the job. At the end of an export job, the content of the master table is written to a file in the dump file set. / For import jobs, the master table is loaded from the dump file set and is used to control the sequence of operations for locating objects that need to be imported into the target database.
Question No : 9
Identify two situations in which the alert log file is updated.
The alert log is a chronological log of messages and errors, and includes the following items:
*All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
* Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
* Messages and errors relating to the functions of shared server and dispatcher processes
* Errors occurring during the automatic refresh of a materialized view
* The values of all initialization parameters that had nondefault values at the time the database and instance start Note:
* The alert log file \(also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.
Question No : 10
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? (Choose two.)
Question No : 11
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?
Question No : 12
Examine these two statements:
Which three are true about the MRKT tablespace? (Choose three.)
Question No : 13
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? (Choose two.)
Question No : 14
Which three statements are true about SQL plan directives? (Choose three.)
Question No : 15
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB.
You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;
What is the result?
Interesting behavior in 22.214.171.124 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.
When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.