1z0-067 | Improved 1z0-067 Exam Study Guides With New Update Exam Questions
Q91. Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
A. By default, EM express is available for a database after database creation.
B. You can use EM express to manage multiple databases running on the same server.
C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
E. You can create and configure pluggable databases by using EM express.
Answer: A
Explanation: EM Express is built inside the database.
Note: Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
Q92. 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/passI2c@catdbi2c
RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i;
What is the outcome of the import?
A. It fails because the target database and recovery catalog database are of different versions.
B. It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
C. It succeeds but the database is not automatically registered in the rc:2c catalog.
D. It fails because RMAN is not connected to the target database with r3:T=:42324:.
Answer: B
Q93. You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?
A. Use job classes.
B. Use scheduler windows.
C. Use the mapping rule for the consumer groups.
D. Set the switch_time plan directive for both plans.
E. Use scheduler schedules.
Answer: B
Q94. In which situation can you use Flashback Database?
A. when undoing a shrink data file operation
B. when retrieving a dropped tablespace
C. when returning to a point in time before the restoration or re-creation of a control file
D. when returning to a point in time before the most recent open resetlogs operation
Answer: B,C
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm(pre requisites, third para)
Q95. 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 statement is true about the execution of the command?
A. It fails because the log file parameter is not specified.
B. It fails because no absolute path is specified for the log file and dump file.
C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.
Answer: B
Q96. Which two statements are true about the Automatic Diagnostic Repository (ADR)?
A. The ADR base is shared across multiple instances.
B. The ADR base keeps all diagnostic information in binary format.
C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
D. The ADR can be used for problem diagnosis even when the database instance is down.
E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.
Answer: C,D
Q97. LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID). SSL has been configure for the database and OLD and the password file has been
configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
A. authentication by password file
B. authentication by using certificates overSSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
Answer: A
Q98. Evaluate these statements:
CREATE TABLE purchase_orders
(po_idNUMBER(4),
po_dateTIMESTAMP,
supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITIONBYRANGE(po_date)
(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')),PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));
CREATETABLEpurchase_order_items
(po_idNUM3ER(4)NOTNULL,
product_idNUMBER(6)NOTNULL,
unit_prlceNUMBER(8,2),
quantity NUMBER(8),
CONSTRAINTpo_items_f k
FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) )
PARTITIONBYREFERENCE(po_items_fk);
Which two statements are true?
A. Partitions of purchase_order_items are assigned unique names based on a sequence.
B. The purchase_orders and purchase_order_items tables are created with four partitioneach.
C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
E. Partition maintenance operations on the purchase_order_items table require disabling theforeign key constraint.
Answer: C,E
Q99. Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2'
Which two statements are true?
A. The pluggable database pdb2 is created by cloning pdb1and is in mount state.
B. Details about the metadata describing pdb2 are stored in an XML file in the'/disk2/oracle/pdb2/' directory.
C. The tablespace specifications of pdb2 are the same as pdb1.
D. All database objects belonging to common users in PD3I are cloned in PD32.
E. pdb2 is created with its own private undo and temp tablespaces.
Answer: A
Reference:http://oracle-info.com/2013/07/27/12c-database-create-pdbs-plug-unplug/(see the table, 4throw)
Q100. 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?
A. USERS
B. SYSTEM
C. SYSAUX
D. EXAMPLE
Answer: A
Explanation:
This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.