Steps Necessary To Pass The 1Z0-060 Exam from Training Expert ActualVCE
Valid Way To Pass Oracle Database's 1Z0-060 Exam
More Info
For more info visit: Oracle 12c Official 1Z0-060 Exam Reference
NEW QUESTION 102
Examine the parameter for your database instance:
You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:
Identify the reason why the optimizer chose different execution plans.
- A. The optimizer chose different plans because automatic dynamic sampling was enabled.
- B. The optimizer used re-optimization cardinality feedback for the query.
- C. The optimizer chose different plan because extended statistics were created for the columns used.
- D. The optimizer used a dynamic plan for the query.
Answer: A
Explanation:
Explanation
* optimizer_dynamic_sampling
OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the size of the sample that the optimizer uses to gather the statistics.
Range of values0 to 11
NEW QUESTION 103
In which two scenarios do you use SQL* Loader to load data?
- A. Use transparent parallel processing without having to split the external data first.
- B. Transform the data while it is being loaded into the database.
- C. Generate unique sequential key values in specified columns.
- D. Load data into multiple tables during the same load statement.
Answer: B,C
Explanation:
You can use SQL*Loader to do the following:
/ (A) Manipulate the data before loading it, using SQL functions.
/ (D) Generate unique sequential key values in specified columns.
etc:
/ Load data into multiple tables during the same load session.
/ Load data across a network. This means that you can run the SQL*Loader client on a different
system from the one that is running the SQL*Loader server.
/ Load data from multiple datafiles during the same load session.
/Specify the character set of the data.
/ Selectively load data (you can load records based on the records' values).
/Use the operating system's file system to access the datafiles.
/ Load data from disk, tape, or named pipe.
/ Generate sophisticated error reports, which greatly aid troubleshooting.
/ Load arbitrarily complex object-relational data.
/ Use secondary datafiles for loading LOBs and collections.
/ Use either conventional or direct path loading. While conventional path loading is very flexible,
direct path loading provides superior loading performance.
Note:
* SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.
NEW QUESTION 104
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
- A. Only DDL commands that resulted in the creation of new segments are logged.
- B. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
- C. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
- D. All DDL commands are logged in the alert log file.
- E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Answer: B
Explanation:
Explanation/Reference:
Explanation:
The log files are created only in $ADR_HOME/log
in alert log only alter system is catched.Sun Mar 30 23:30:04 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:32:41 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:39:35 2014ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=BOTH;[oracle@ovs trace]$
only in diag/rdbms/.../../log/ two files are capturing this. The xml file is capturing full details and text file having only the commands.
[oracle@ovs log]$ pwd/oraclebase/diag/rdbms/ora12c1/ora12c1/log[oracle@ovs log]$ cat ddl/* create table testing2(a number)
create table testing3( aa number)
[oracle@ovs log]$ cat ddl_ora12c1.logSun Mar 30 23:33:26 2014diag_adl:create table testing2(a number) diag_adl:create table testing3( aa number)
Refernces: http://docs.oracle.com/database/121/REFRN/refrn10302.htm#REFRN10302
NEW QUESTION 105
You run a script that completes successfully using SQL*Plus that performs these actions:
1.Creates a multitenant container database (CDB)
2.Plugs in three pluggable databases (PDBs)
3.Shuts down the CDB instance
4.Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?
- A. The other PDBs will be in mount state.
- B. The seed will be opened read/write.
- C. The seed will be opened read-only.
- D. The other PDBs will be opened read-only.
- E. The PDBs will be opened read/write.
- F. The seed will be in mount state.
Answer: A,C
Explanation:
B: The seed is always read-only.
D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.
NEW QUESTION 106
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?
- A. Run the Automatic Workload Repository Monitor (ADDM).
- B. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
- C. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
- D. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
Answer: C
Explanation:
* SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views. SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements.
*The query optimizer can also help you tune SQL statements. By using SQL Tuning Advisor and SQL Access Advisor, you can invoke the query optimizer in advisory mode to examine a SQL statement or set of statements and determine how to improve their efficiency. SQL Tuning Advisor and SQL Access Advisor can make various recommendations, such as creating SQL profiles, restructuring SQL statements, creating additional indexes or materialized views, and refreshing optimizer statistics.
Note:
*Decision support system (DSS) workload
*The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles.
Reference: Tuning SQL Statements
NEW QUESTION 107
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result?
- A. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
- B. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
- C. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
- D. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
- E. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
- F. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
Answer: B,D,F
NEW QUESTION 108
Examine these commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table? (Choose two.)
- A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
- B. The primary key constraint on the EMPLOYEEStable is disabled during redefinition.
- C. You must copy the VPD policies manually from the original table to the new table during online redefinition.
- D. VPD policies are copied from the original table to the new table during online redefinition.
Answer: A,D
Explanation:
The triggers cloned to the interim table are disabled until the redefinition is completed. Once the redefinition is complete, all cloned objects are renamed to the original names used by they objects they were cloned from.
References: http://www.oracle-base.com/articles/10g/online-table-redefinition-enhancements-10gr1.php
NEW QUESTION 109
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');
Which three statements are true about the effect of this command?
- A. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
- B. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
- C. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
- D. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
- E. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Answer: A,B,C
Explanation:
* SET_TABLE_PREFS Procedure
This procedure is used to set the statistics preferences of the specified table in the specified schema.
* Example: Using Pending Statistics
Assume many modifications have been made to the employees table since the last time statistics were gathered. To ensure that the cost-based optimizer is still picking the best plan, statistics should be gathered once again; however, the user is concerned that new statistics will cause the optimizer to choose bad plans when the current ones are acceptable. The user can do the following:
EXEC DBMS_STATS.SET_TABLE_PREFS('hr', 'employees', 'PUBLISH', 'false'); By setting the employees tables publish preference to FALSE, any statistics gather from now on will not be automatically published. The newly gathered statistics will be marked as pending.
NEW QUESTION 110
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be used to back up only the PDB1 pluggable database? (Choose two.)
- A. BACKUP DATABASEwhile connected to the ROOTcontainer
- B. BACKUP PLUGGABLE DATABASE PDB1while connected to PDB2
- C. BACKUP PLUGGABLE DATABASE PDB1while connected to the ROOTcontainer
- D. BACKUP DATABASEwhile connected to the PDB1container
- E. BACKUP PLUGGABLE DATABASE PDB1while connected to the PDB1container
Answer: C,D
Explanation:
Explanation/Reference:
Explanation:
To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
* (A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.
* (C)If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.
NEW QUESTION 111
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
- A. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either
committed or rolled back. - B. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled
hack. - C. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled
back. - D. The statement results in an error because there are open PDBs.
Answer: C
Explanation:
* SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]
Shuts down a currently running Oracle Database instance, optionally closing and dismounting a
database. If the current database is a pluggable database, only the pluggable database is closed.
The consolidated instance continues to run.
Shutdown commands that wait for current calls to complete or users to disconnect such as
SHUTDOWN NORMAL and SHUTDOWN TRANSACTIONAL have a time limit that the
SHUTDOWN command will wait. If all events blocking the shutdown have not occurred within the
time limit, the shutdown command cancels with the following message: ORA-01013: user requested cancel of current operation
* If logged into a CDB, shutdown closes the CDB instance.
To shutdown a CDB or non CDB, you must be connected to the CDB or non CDB instance that
you want to close, and then enter
SHUTDOWN
Database closed.
Database dismounted.
Oracle instance shut down.
To shutdown a PDB, you must log into the PDB to issue the SHUTDOWN command.
SHUTDOWN
Pluggable Database closed.
Note:
* Prerequisites for PDB Shutdown
When the current container is a pluggable database (PDB), the SHUTDOWN command can only
be used if:
The current user has SYSDBA, SYSOPER, SYSBACKUP, or SYSDG system privilege.
The privilege is either commonly granted or locally granted in the PDB.
The current user exercises the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or
AS SYSDG at connect time.
To close a PDB, the PDB must be open.
NEW QUESTION 112
On your Oracle 12c database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id,
sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)
- A. The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.
- B. Only the ORD_CUSTOMER_IX2 index is created.
- C. Only the ORD_CUSTOMER_IX1 index is created.
- D. Both the indexes are updated when a new row is inserted, updated, or deleted in the ORDERS table.
- E. Both the indexes are created: however, only ORD_CUSTOMER_IX2 index is visible.
Answer: D,E
NEW QUESTION 113
You are administering a database stored in Automatic Storage Management (ASM). You
use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?
- A. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
- B. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
- C. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
- D. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
- E. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
- F. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
Answer: B,D,E
Explanation:
Note:
*The md_restore command allows you to restore a disk group from the metadata created
by the md_backup command.
/md_restore Command
Purpose
This command restores a disk group backup using various options that are described in
this section.
/In the restore mode md_restore, it re-create the disk group based on the backup file with
all user-defined templates with the exact configuration as the backuped disk group. There
are several options when restore the disk group
full - re-create the disk group with the exact configuration
nodg - Restores metadata in an existing disk group provided as an input parameter
newdg - Change the configuration like failure group, disk group name, etc..
*The MD_BACKUP command creates a backup file containing metadata for one or more
disk groups. By default all the mounted disk groups are included in the backup file which is
saved in the current working directory. If the name of the backup file is not specified, ASM names the file AMBR_BACKUP_INTERMEDIATE_FILE.
NEW QUESTION 114
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedurecolumn? (Choose two.)
- A. The procedures may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
- B. All the components may be moved into SYSAUXtablespace.
- C. All the components may be moved from the SYSAUXtablespace.
- D. The procedures may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
Answer: A,D
Explanation:
Explanation/Reference:
References: http://www.dba-oracle.com/t_v_sysaux_contents_tips.htm
NEW QUESTION 115
Which three statements are true about adaptive SQL plan management? (Choose three.)
- A. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
- B. It adds new, better plans automatically as fixed plans to the baseline.
- C. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
- D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
- E. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
Answer: C,D,E
Explanation:
Explanation
With adaptive SQL plan management, DBAs no longer have to manually run the verification or evolve process for non-accepted plans. When automatic SQL tuning is in COMPREHENSIVE mode, it runs a verification or evolve process for all SQL statements that have non-accepted plans during the nightly maintenance window. If the non-accepted plan performs better than the existing accepted plan (or plans) in the SQL plan baseline, then the plan is automatically accepted and becomes usable by the optimizer. After the verification is complete, a persistent report is generated detailing how the non-accepted plan performs compared to the accepted plan performance. Because the evolve process is now an AUTOTASK, DBAs can also schedule their own evolve job at end time.
Note:
* The optimizer is able to adapt plans on the fly by predetermining multiple subplans for portions of the plan.
* Adaptive plans, introduced in Oracle Database 12c, enable the optimizer to defer the final plan decision for a statement until execution time. The optimizer instruments its chosen plan (the default plan) with statistics collectors so that it can detect at runtime, if its cardinality estimates differ greatly from the actual number of rows seen by the operations in the plan. If there is a significant difference, then the plan or a portion of it will be automatically adapted to avoid suboptimal performance on the first execution of a SQL statement.
NEW QUESTION 116
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
- A. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
- B. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
- C. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
- D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
- E. In a PDB plan, subplans may be used with up to eight consumer groups.
Answer: B,C,D
Explanation:
A: Setting a PDB resource plan is optional. If not specified, all sessions within the
PDB are treated equally.
*In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans.
The functionality is similar except for the following differences:
/ Non-CDB Database
Multi-level resource plans Up to 32 consumer groups Subplans / PDB Database Single-level resource plans only Up to 8 consumer groups (not B) No subplans
IncorrectNot C
NEW QUESTION 117
Which three SQL statements would display the value 1890.55 as $1, 890.55?
- A. Option E
- B. Option D
- C. Option B
- D. Option A
- E. Option C
Answer: A,B,D
NEW QUESTION 118
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file.There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?
- A. Recover each pluggable database.
- B. Mount the CDB and then recover and open the database, with the RESETLOGS option.
- C. Open all the pluggable databases.
- D. Recover and open the CDB in NORMAL mode.
- E. Start the database instance in the nomount stage and restore the control file from control file auto backup.
- F. Mount the container database (CDB) and restore the control file from the control file auto backup.
Answer: B,C,E
Explanation:
Step 1: F Step 2: D Step 3:C: If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVERcommand, even if no data files have been restored, and open the database with the RESETLOGS option.
Note: *RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for backup and recovery in a multitenant environment. You can back up and recover a whole multitenant container database (CDB), root only, or one or more pluggable databases (PDBs).
NEW QUESTION 119
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1.Place all the user-defined tablespace in read-only mode on the source database.
2.Upgrade the source database to a 12c version.
3.Create a new PDB in the target container database.
4.Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5.Copy the associated data files and export the dump file to the desired location in the target database.
6.Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7.Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
- A. 1, 3, 4, 5, 6, 7
- B. 1, 5, 6, 4, 3, 2
- C. 1, 4, 3, 5, 6, 7
- D. 2, 1, 3, 4, 5, 6, 7
- E. 2, 1, 3, 4, 5, 6
Answer: C
Explanation:
1.Set user tablespaces in the source database to READ ONLY.
2.From the Oracle Database 11g Release 2 {11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VER$ION=12 parameter is required only when exporting from an Oracle Database llg Release 2 database:
3.Copy the tablespace data files from the source system to the destination system. Note that the log file from the export operation will list the data files required to be moved.
4.Create a COB on the destination system, including a PDB into which you will import the source database.
5.In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act of importing the dump file will plug the tablespace data files into the destination PDB Oracle White Paper - Upgrading to Oracle Database 12c -August 2013
NEW QUESTION 120
Identify two correct statements about multitenant architectures.
- A. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
- B. Multiple CDBs share certain PDB resources.
- C. A PDB can have a private undo tablespace.
- D. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
- E. Patches are always applied at the CDB level.
- F. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
Answer: D,E
Explanation:
B: Using 12c Resource manager you will be able control CPU, Exadata I/O,
sessions and parallel servers. A new 12c CDB Resource Manager Plan will use so-called "Shares"
(resource allocations) to specify how CPU is distributed between PDBs. A CDB Resource
Manager Plan also can use "utilization limits" to limit the CPU usage for a PDB. With a default
directive, you do not need to modify the resource plan for each PDB plug and unplug.
E: New paradigms for rapid patching and upgrades.
The investment of time and effort to patch one multitenant container database results in patching
all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug
to a multitenant container database at a different Oracle Database software version.
Incorrect: Not A:
*The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment.
*Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application. Not D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications. A PDB can be plugged into only one CDB at a time.
not F:
*UNDO tablespace can NOT be local and stays on the CDB level.
*Redo and undo go hand in hand, and so the CDB as a whole has a single undo tablespace per
RAC instance.
NEW QUESTION 121
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
- A. By default, EM express is available for a database after database creation.
- B. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- C. You cannot start up or shut down a database instance by using EM express.
- D. You can use EM express to manage multiple databases running on the same server.
- E. You can create and configure pluggable databases by using EM express.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
O12c is integrated in database don't have his own agent like in O11G then you cannot start up or shut down a database.
NEW QUESTION 122
You find this query being used in your Oracle 12c database:
Which method a used by the optimizer to limit the rows being returned?
- A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.
- B. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
- C. A TOP-N query is created during execution and a filter is added to the query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.
- D. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
Answer: B
NEW QUESTION 123
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDBis USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?
- A. Place the root container in ARHCHIVELOGmode.
- B. Place the root container in the nomount stage.
- C. Ensure that HR_PDBis open.
- D. Take the USERDATAtablespace offline.
Answer: A
Explanation:
Explanation/Reference:
Explanation:
RMAN> select name,open_mode from v$pdbs;
using target database control file instead of recovery catalogNAME OPEN_MODE
---------- ----PDB$SEED READ ONLYORA12P1 READ WRITEORA12P2 MOUNTED
RMAN> backup tablespace ora12p2:users;
Starting backup at 31-MAR-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=137 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile (s) in backup setinput datafile file number=00013 name=/appl/oradata/cdbroot/ORA12C1/ F5D05369C4B23E83E0430100007F6D99/datafile/o1_mf_users_9mhr0o5l_.dbfchannel ORA_DISK_1:
starting piece 1 at 31-MAR-14channel ORA_DISK_1: finished piece 1 at 31-MAR-14piece handle=/appl/ oradata/flash_recovery/ORA12C1/F5D05369C4B23E83E0430100007F6D99/backupset/2014_03_31/ o1_mf_nnndf_TAG20140331T001832_9mhzdb6w_.bkp tag=TAG20140331T001832
comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at
31-MAR-14
Starting Control File and SPFILE Autobackup at 31-MAR-14piece handle=/appl/oradata/flash_recovery/ ORA12C1/autobackup/2014_03_31/o1_mf_s_843610715_9mhzdcv8_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 31-MAR-14
RMAN>
The above example illustrates that if root container is open and in archivelog it can do the backup of tablespace whether the pdb is mounted or open.
NEW QUESTION 124
......
The Oracle 1Z0-060 exam validates your expertise when it comes to Oracle Database.
As you are getting ready for the Oracle 1Z0-060 certification exam, it is vital that you understand all that is entailed in this test. It is important to mention this is an exam that requires you to have more practical knowledge than theoretical concepts. The majority of those who have failed it focused their attention on cramming rather than gaining the actual skills. You should take a different perspective – be more practical.
Your journey towards earning the Oracle Certified Professional (OCP) certification begins with receiving the Oracle Certified Associate (OCA) credential. With the OCA certificate, you tell the world that you are equipped with vital skills needed to provide support for Oracle products. OCP is the benchmark of your professional career and shows that you have what it takes to implement enterprise-wide databases. Earning it begins with the single step of passing your Oracle 1Z0-060 exam. The test includes 80 questions. There will be 120 minutes to complete all of them. You have to pay 245$ for the 1Z0-060 exam.
Oracle 1Z0-060 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
All 1Z0-060 Dumps and Upgrade to Oracle Database 12c Training Courses: https://www.actualvce.com/Oracle/1Z0-060-valid-vce-dumps.html