1Z0-067 Exam Questions
236 real 1Z0-067 exam questions with expert-verified answers and explanations. Page 2 of 5.
- Question #51
Which three statements are true about the SQL*Loader utility?
- Question #52
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the...
- Question #53
You are administering a multitenant container database (CDB) cdb1. Examine the command and its output: SQL>show parameterfile NAMETYPEVALUE ----------------------------------------...
- Question #54
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). The following are the possible steps to accomplish this task:...
- Question #55
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs). You have already created a test system to support the cons...
- Question #56
Identify three benefits of unified auditing.
- Question #57
Examine the backup requirement for your company: 1) Every Sunday, a backup of all used data file blocks is performed. 2) Every Wednesday and Friday, a backup of all the changed blo...
- Question #58
What two are the prerequisites for enabling Flashback Database?
- Question #59
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
- Question #60
Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?
- Question #61
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the...
- Question #62
Which three statements are true about Oracle Secure Backup (OSB)?
- Question #63
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 dat...
- Question #64
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the...
- Question #65
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privil...
- Question #66
Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup In which three situations can you use the backup?
- Question #67
You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Increm...
- Question #68
Examine the commands: SQL> ALTER SESSION SET RECYCLBIN = ON; Session altered. SQL> DROP TABLE emp; --(First EMP table) Total dropped. SQL> CREATE TABLE emp (id NUMBER CONSTRAINT em...
- Question #69
Which three statements are true about the keystore storage framework for transparent data encryption?
- Question #70
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: i.Long-running...
- Question #71
You have a production Oracle 12c database running on a host. You want to install and create databases across multiple new machines that do not have any Oracle database software ins...
- Question #72
For which two requirements would you use the Database Resource Manager?
- Question #73
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user: SQL> CREATE USER c##a_admin IDENTIFIED BY p...
- Question #74
Which two statements are true about the Automatic Diagnostic Repository (ADR)?
- Question #75
user_data is a nonencryptedtablespace containing tables with data. You must encrypt ail data in this tablespace. Which three methods can do this?
- Question #76
Which two statements are true about a common user?
- Question #77
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incr...
- Question #78
Which three statements are true about Oracle Restart?
- Question #79
Examine the parameters for your database instance: NAMETYPEVALUE ----------------------------------------------------------------------- optimizer_adaptive_reporting_onlybooleanFAL...
- Question #80
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO du...
- Question #81
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...
- Question #82
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. Th...
- Question #83
Which two statements are true about service creation for pluggable databases (PDBs)?
- Question #84
You want to move your existing recovery catalog to another database. Examine the steps: 1) Export the catalog data by using the Data Pump Export utility in the source database. 2)...
- Question #85
Examine the command and its output: SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE ----------...
- Question #86
Which parameter must be set to which value to implement automatic PGA memory management?
- Question #87
Examine the following set of RMAN commands: RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RKAN> RUN { ALLOCATE CHANNEL chl DEVICE TYPE DISK; EXECUTE SCRIP...
- Question #88
You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically?
- Question #89
Which three statements are true about Consolidated Database Replay?
- Question #90
Which two statements are true about Flashback Version Query?
- Question #91
Which three statements are true about unplugging a pluggable database (PDB)?
- Question #92
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the comma...
- Question #93
Examine the RMAN command: RMAN> BACKUP VALIDATE DATABASE; Which statement is true about the execution of the command?
- Question #94
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
- Question #95
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incom...
- Question #96
Examine the RMAN commands executed in your database: RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk; RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE...
- Question #97
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
- Question #98
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: $ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01...
- Question #99
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
- Question #100
Which two statements are true about tablespaces in multitenant container databases (CDBs)?