1Z0-063 Exam Questions
236 real 1Z0-063 exam questions with expert-verified answers and explanations. Page 1 of 5.
- Question #1
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 #2
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 binsgk31sj...
- Question #3
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:
- Question #4
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization. Which two backup solutions can be u...
- Question #5
user_data is a nonencrypted tablespace containing tables with data. You must encrypt ail data in this tablespace. Which three methods can do this?
- Question #6
Examine the command: SQL>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; In which two scenarios is this command required?
- Question #7
Which three statements are true about the SQL*Loader utility?
- Question #8
You wish to create jobs to satisfy these requirements: (1) Automatically bulk load data from a flat file. (2) Rebuild indexes on the SALES table after completion of the bulk load.
- Question #9
You are administering a multitenant container database (CDB). Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
- Question #10
Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?
- Question #11
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 #12
Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to seven days in RMAN. - The most recent backup to disk fo...
- Question #13
You restore and recover your database to anew host by using an existing RMAN open database backup. Which step must you perform next?
- Question #14
Which three statements are true about the database instance startup after an instance failure?
- Question #15
Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?
- Question #16
Examine the RMAN commands executed in your database: RMAN> CONFIGUREDEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFI...
- Question #17
Which two statements describe the relationship between a window, a resource plan, and a job class?
- Question #18
In which situation can you use Flashback Database?
- Question #19
Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FO...
- Question #20
Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?
- Question #21
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES table by executing the com...
- Question #22
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 #23
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_...
- Question #24
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 Infor...
- Question #25
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 #26
Which two statements are true about Flashback Version Query?
- Question #27
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
- Question #28
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use?
- Question #29
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
- Question #30
Which two statements are true when row-archival management is enabled?
- Question #31
You have a production Oracle 12c database running on a host. You want toinstall and create databases across multiple new machines that do not have any Oracle database software inst...
- Question #32
Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output: SQL>UPDATEcustomersSETamt_due=amt_...
- Question #33
Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/' You execute the following command to create theCDB1. container databa...
- Question #34
When is the UNDO_RETENTION parameter value ignored by a transaction?
- Question #35
Which two statements are true about service creation for pluggable databases (PDBs)?
- Question #36
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the following steps: 1) Iss...
- Question #37
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB): 1) Start the RMAN client by using the RMAN target / command. 2) Start t...
- Question #38
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. You want to check the diagnostic files created as pa...
- Question #39
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 1) Create media families for data files and archived redo log files. 2) Configure database backup stora...
- Question #40
You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two...
- Question #41
For which two requirements would you use the Database Resource Manager?
- Question #42
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 #43
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
- Question #44
Which three statements are true about Consolidated Database Replay?
- Question #45
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 #46
Which three statements are true about the keystore storage framework for transparent data encryption?
- Question #47
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 #48
Which three types of failures are detected by the Data Recovery Advisor (DRA)?
- Question #49
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands: SQL> CREATE U...
- Question #50
Which two statements are true about a common user?