PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)
BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg
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 password
DEFAULT TABLESPACE users
QUOTA I00M ON users
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?
A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
B. The command succeeds only if all the PDBs have the users and temp tablespaces.
C. The command gives an error because the container=all clause is missing.
D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.
Answer: A
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/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command:
SQL> FLASHBACK TABLE “BINSgk31sj/3akk5hg3j21kl5j3d==$0” TO BEFORE DROP;
Which two statements are true?
A. It flashes back the employee table and all the constraints associated with the table.
B. It automatically flashes back all the indexes on the employes table.
C. It automatically flashes back any triggers defined on the table.
D. It flashes back only the structure of the table and not the data.
E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
Answer: BD
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:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout theprocess.
iv. Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
A. DEALLOCATE UNUSED
B. SHRINK SPACE CASCADE
C. SHRINK SPACE COMPACT
D. ROW STORE COMPRESS BASIC
Answer: A
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 used?
A. RMAN recovery catalog
B. RMAN Media Management Library
C. Enterprise Manager Cloud Control
D. Enterprise Manager Database Express
E. Oracle Secure Backup
Answer: AC
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?
A. Use Data Pump
B. Use ALTERTABLE … MOVE
C. Use CREATE TABLE AS SELECT
D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
E. Use alter tablespace to encrypt the tablespace
Answer: ABC
QUESTION 6
Examine the command:
SQL>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?
A. The current online redo log file is missing.
B. A data file belonging to a noncritical tablespace is missing.
C. All the control files are missing.
D. The database backup is older than the control file backup.
E. All the data files are missing.
Answer: CD
QUESTION 7
Which three statements are true about the SQL*Loader utility?
A. It can be used to load data from multiple external files into multiple tables.
B. It can be used to extract and reorganize data from external files, and then load it into a table.
C. It can be used to load data from external files using direct path only.
D. It can be used to create tables using data that is stored in external files.
E. It can be used to generate unique sequential values in specified columns while loading data.
Answer: ADE
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.
A. Create both jobs by using Scheduler raised events.
B. Create both jobs using application raised events.
C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
Answer: A
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.
A. by using the connect statement as a local user having only the set container privilege
B. by using easy connect
C. by using external authentication
D. as a common user with the set container privilege
E. by executing the alter session set container command as a local user
Answer: AD
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?
A. Enable minimal supplemental logging.
B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
C. Enable the recycle bin.
D. Enable undo retention guarantee.
E. Enable Fast Recovery Area.
Answer: AC
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 blocks since last Sunday’s backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day’s backup is performed.
Which backup strategy satisfies the requirements?
A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
Answer: B
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 for the tools tablespace was taken on March 1, 2013.
The tools tablespace is read-only since March 2, 2013. On March 15, 2013, you issue the RMAN command to back up the database to disk. Which statement is true about the backup of the tools tablespace?
A. The RMAN backup fails because the tools tablespace is read-only.
B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.
Answer: D
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?
A. Execute catproc.sqi to recompile invalid PL/SQL modules.
B. Open the database with the resetlogs option.
C. Set a new database identifier (DBID) for the newly restored database.
D. Use the RMAN set new name and switch commands to switch to new files.
Answer: A
QUESTION 14
Which three statements are true about the database instance startup after an instance failure?
A. The RECO process recovers the uncommitted transactions at the next instance startup.
B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
C. Uncommitted changes are rolled back to ensure transactional consistency.
D. The SMON process automatically performs the database recovery.
E. Media recovery is required to complete the database recovery.
F. Changes committed before the failure, which were not written to the data files, are reapplied.
Answer: ACD
PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)
BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg