Our pass rate is high to 98.9% and the similarity percentage between our 1Z0-063 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle 1Z0-063 exam in just one try? I am currently studying for the Oracle 1Z0-063 exam. Latest Oracle 1Z0-063 Test exam practice questions and answers, Try Oracle 1Z0-063 Brain Dumps First.
2017 NEW RECOMMEND
Free VCE & PDF File for Oracle 1Z0-063 Real Exam
Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions
Q21. 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?
A. The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
B. A backup of pdbi and pd35 must exist before executing the command.
C. The duplicate command first creates a backup, and then duplicates the PDBs by using the
E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
Q22. 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?
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.
Q23. Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
A. Reduced logical I/O
B. Reduced virtual memory utilization
C. Improved Serial Execution performance
D. Reduced physical I/O
E. Reduced CPU utilization
Q24. 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 commandsucceeds 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.
Q25. Which three statements are true about a job chain?
A. It can contain a nested chain of jobs.
B. It can be used to implement dependency-based scheduling.
C. It cannot invoke the same program or nested chain in multiple steps in the chain.
D. It cannot have more than one dependency.
E. It can be executed using event-based or time-based schedules.
Q26. As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files duringthe upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
C. Start up the database instance by using theSTARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
Q27. Which three statements are true about Oracle Restart?
A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
B. While starting any components, it automatically attempts to start all dependencies first and in properorder.
C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
D. It can be used to only start Oracle components.
E. It runs periodic check operations to monitor the health of Oracle components.
Q28. Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1.Restore the control filesby using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
Start the database instance in nomount state.
Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
Identify the required steps in the correct order.
A. 7,6, 1, 2, 3, 5, 4
B. 7, 2, 1, 3, 5, 8
C. 7, 6, 1, 2, 9, 10, 8
D. 7, 6, 1, 2, 9, 10, 4
140. You want RMAN to make duplicate copies of data files when using the backup command.
What must you set using the RMAN configure command to achieve this?
A. MAXSETSIZE TO 2;
B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Q29. You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
A. The database must be running in archivelog mode.
B. Flashback Database must be enabled.
C. Fast Recovery Area must be enabled.
D. The recyclebin must be enabled for the database.
E. Undo retention guarantee must be enabled.
F. A database backup must be taken.
Q30. 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. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(âSHâ, 'CUSTOMERS')from dual statement.
2.Execute the dbms_stats.seed_col_usage (null,âSHâ,500) procedure. 3.Execute the required queries on the customers table.
4.Issue the select dbms_stats.reportwcol_usage(âSHâ, 'customers') from dual statement.
Identify the correct sequence of steps.
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1
Explanation: Step 1 (2). Seed column usage Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload. Step 2: (3)You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries. Step 3. (1) Create the column groups Atthis point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
DBMS_STATS.REPORT_COL_USAGE reports column usage informationand records all
the SQL operations the database has processed for a given object.
The Oracle SQL optimizer has always been ignorant of the implied relationships between
data columns within the same table. While the optimizer has traditionally analyzedthe
distribution of values within a column, he does not collect value-based relationships
Creating extended statistics
Here are the steps to create extended statistics for related table columns
1 -The first step is to create column histograms for the related columns.
2 â Next, we run dbms_stats.create_extended_stats to relate the columns together. Unlike a traditional procedure that is invoked via an execute (âexecâ) statement, Oracle extended statistics are created via a select statement.