[Q47-Q68] Full 1z0-063 Practice Test and 278 Unique Questions, Get it Now!

Q47. Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Q48. Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

Q49. You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

Q50. 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?

Q51. Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Q52. For which three pieces of information can you use the RMAN LIST command? (Choose three.)

Q53. A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2.Issue ALTER SYSTEM SET CONTROL_FILES=’/u01/app/oracle/oradata/cdb1/disk1/ control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02, ctl,
/ u01/app/oracle/oradata/cdb1/disk3/control03.ctl’
SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES
‘ /u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/ cdb1/disk2/control02.ctl, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl’;.
4. Copy the control file from the existing location to ‘/u01/app/oracle/oradata/cdb1/disk3/ control03.ctl’.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.

Q54. In which two locations does the USER_DATA TABLESPACE clause create a tablespace?

Q55. Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?

Q56. Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator?

Q57. Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

Q58. Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

Q59. Which two parameters must be set to configure the fast recovery area?

Q60. 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))
PARTITION BY RANGE(po_date)
(PARTITIONQ1 VALUES LESS THAN (TO_DATE(’01-apr-2007′,’dd-mm-yyyy’)),
PARTITIONQ2VALUESLESSTHAN(TO_DATE(’01-jul-2007′,’dd-mm-yyyy’)),
PARTITIONQ3VALUESLESSTHAN (TO~DATE(’01-oct-2007′,’dd-mm-yyyy’)),
PARTITIONQ4VALUESLESSTHAN (TO_DATE(‘Ol-jan-2008′,’dd-mm-yyyy’)));
CREATE TABLE purchase_order_items
(po_idNUM3ER(4)NOT NULL,
product_idNUMBER(6)NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_f k
FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
Which two statements are true? (Choose two.)

Q61. 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? (Choose two.)

Q62. You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ‘ /dev/f lash_device_1′,’ /dev/f lash_device_2′
How should the D3_flash_cache_size be configured to use both devices?

Q63. Which three statements are true about Oracle Restart? (Choose three.)

Q64. You accidentally drop the CUSTOMERStable, and then recover it by using the FLASHBACK TABLE
command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)

Q65. Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.

Q66. Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

Q67. You want to create a duplicate database DUP_DB from your production database PRODon the same host.
The PRODdatabase uses Automatic Storage Management (ASM) for storage. Regular backups are taken
using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

Q68. One of your container databases (CDBs) has five pluggable databases (PDBs).
COMMON_USER_PREFIX is C##.
These commands executed successfully while connected as SYS to CDB$ROOT:
SQL> CREATE c##dba_admin IDENTIFIED BY orcl23;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;
SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;
SQL> GRANT c##role1 to system CONTAINER=ALL;
Which three are true? (Choose three.)