Excellent 1Z0-060 Updated 2021 Dumps With 100% Exam Passing Guarantee
Best way to practice test for Oracle 1Z0-060
NEW QUESTION 20
You use a recovery catalog for maintaining your database backups.
You execute the following command:
Which two statements are true? (Choose two.)
- A. Checks are performed to confirm whether all database files exist in correct locations
- B. Checks are performed for physical corruptions.
- C. Corrupted blocks, if any, are repaired.
- D. Backup sets containing both data files and archive logs are created.
- E. Checks are performed for logical corruptions.
Answer: A,B
Explanation:
B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as follows:
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
This form of the command would check for physical corruption. To check for logical corruption, RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL; D: You can use the VALIDATE keyword of the BACKUP command to do the following:
Check datafiles for physical and logical corruption
Confirm that all database files exist and are in the correct locations.
Note:
You can use theVALIDATEoption of theBACKUPcommand to verify that database files exist and are in the correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them. When performing aBACKUP...VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E).
NEW QUESTION 21
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. Mount the container database (CDB) and restore the control file from the control file auto backup.
- B. Open all the pluggable databases.
- C. Recover each pluggable database.
- D. Mount the CDB and then recover and open the database, with the RESETLOGS option.
- E. Start the database instance in the nomount stage and restore the control file from control file auto backup.
- F. Recover and open the CDB in NORMAL mode.
Answer: B,D,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 22
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)
- A. Each Oracle process runs an SCMN thread.
- B. Thread creation must be routed through a dispatcher process
- C. The local listener may pass the request to an existing process which in turn will create a thread.
- D. The local listener may spawn a now process and have that new process create a thread
- E. Each multithreaded Oracle process has an SCMN thread.
Answer: B,C,D
NEW QUESTION 23
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp' ORA-27037: unable to obtain file status Identify two ways to rectify the error. (Choose two.)
- A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
- B. Shut down the database instance and then restart the CDB and PDBs.
- C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
- D. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
- E. Shut down the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
Answer: A,B
Explanation:
Explanation
* Because temp files cannot be backed up and because no redo is ever generated for them, RMAN never restores or recovers temp files. RMAN does track the names of temp files, but only so that it can automatically re-create them when needed.
* If you use RMAN in a Data Guard environment, then RMAN transparently converts primary control files to standby control files and vice versa. RMAN automatically updates file names for data files, online redo logs, standby redo logs, and temp files when you issue RESTORE and RECOVER.
NEW QUESTION 24
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
Examine following commands:
1.ALTER PLUGGABLE DATABASE ALL OPEN;
2.ALTER DATABASE OPEN;
3.ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
- A. Only 3
- B. 1 and 2
- C. Only 1
- D. Only 2
- E. 3 and 1
Answer: A
Explanation:
Example (see step23):
Step 1:
Run the RMAN FLASHBACK DATABASE command.
You can specify the target time by using a form of the command shown in the following examples:
FLASHBACK DATABASE TO SCN 46963;
FLASHBACK DATABASE
TO RESTORE POINT BEFORE_CHANGES;
FLASHBACK DATABASE TO TIME
"TO_DATE('09/20/05','MM/DD/YY')";
When the FLASHBACK DATABASE command completes, the database is left mounted and
recovered to the specified target time.
Step 2:
Make the database available for updates by opening the database with the RESETLOGS option. If
the database is currently open read-only, then execute the following commands in SQL*Plus:
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE OPEN RESETLOGS;
NEW QUESTION 25
Which two statements are true about the installation modes in Oracle Database 12c?
- A. In silent mode installation, you can validate the parameter values on Installation screens for which you have provided information in the response file.
- B. Response file mode is useful when you require multiple Oracle Homes with variation in some of the installation parameters for each home.
- C. In response file mode, you can Include responses for some or all prompts.
- D. In Interactive mode, parameter values are read from a response file and can be changed during installation.
Answer: A,C
NEW QUESTION 26
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 statement results in an error because there are open PDBs.
- C. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack. - D. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
Answer: D
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 27
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?
- A. AWR Compare Period report
- B. Taking a new snapshot and comparing it with a preserved snapshot
- C. Compare Period ADDM report
- D. Active Session History (ASH) report
Answer: A
Explanation:
The awrddrpt.sql report is the Automated Workload Repository Compare
Period Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin
directory.
Incorrect:
Not A:Compare Period ADDM
Use this report to perform a high-level comparison of one workload replay to its capture or
to another replay of the same capture. Only workload replays that contain at least 5
minutes of database time can be compared using this report.
NEW QUESTION 28
Identify three valid methods of opening, pluggable databases (PDBs).
- A. ALTER PLUGGABLE DATABASE OPENissued from that PDB
- B. ALTER DATABASE OPENissued from that PDB
- C. ALTER DATABASE PDB OPENissued from the root
- D. ALTER PLUGGABLE DATABASE OPEN ALL ISSUEDfrom the root
- E. ALTER PLUGGABLE DATABASE OPEN ALL ISSUEDfrom a PDB
- F. ALTER PLUGGABLE DATABASE PDB OPENissued from another PDB
- G. ALTER PLUGGABLE DATABASE PDB OPENissued from the seed
Answer: A,B,D
Explanation:
Explanation/Reference:
Explanation:
E: You can perform all ALTER PLUGGABLE DATABASE tasks by connecting to a PDB and running the corresponding ALTER DATABASE statement. This functionality is provided to maintain backward compatibility for applications that have been migrated to a CDB environment.
A, G: When you issue an ALTER PLUGGABLE DATABASE OPEN statement, READ WRITE is the default unless a PDB being opened belongs to a CDB that is used as a physical standby database, in which case READ ONLY is the default.
You can specify which PDBs to modify in the following ways:
List one or more PDBs.
Specify ALL to modify all of the PDBs.
Specify ALL EXCEPT to modify all of the PDBs, except for the PDBs listed.
NEW QUESTION 29
What are three purposes of the RMAN "FROM" clause?
- A. To support PULL-based active database duplication
- B. To support file recovery over the network in a Data Guard environment
- C. to support PUSH-based active database duplication
- D. to support synchronization of a standby database with the primary database in a Data environment
- E. To support file restores over the network in a Data Guard environment
Answer: A,B,D
Explanation:
E:
*With a control file autobackup, RMAN can recover the database even if the current
control file, recovery catalog, and server parameter file are inaccessible.
*RMAN uses a recovery catalog to track filenames for all database files in a Data Guard
environment. A recovery catalog is a database schema used by RMAN to store metadata
about one or more Oracle databases. The catalog also records where the online redo logs,
standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are
created.
NEW QUESTION 30
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?
- A. Implementing Database Resource Manager
- B. Enabling resumable timeout for user sessions
- C. Setting a metric threshold
- D. Decreasing the value of the IDLE_TIME resource limit in the default profile
Answer: A
Explanation:
IDEL_TIME is about generic idle time limit, not specifically blocking sessions. But question is about idle sessions blocking other sessions
http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11844
Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.
NEW QUESTION 31
What are three purposes of the RMAN "FROM" clause?
- A. To support PULL-based active database duplication
- B. To support file recovery over the network in a Data Guard environment
- C. to support PUSH-based active database duplication
- D. to support synchronization of a standby database with the primary database in a Data environment
- E. To support file restores over the network in a Data Guard environment
Answer: A,B,D
Explanation:
E:
*With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible.
*RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.
NEW QUESTION 32
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database
12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?
- A. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
- B. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITORfunction to view the required information.
- C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
- D. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
Answer: B
Explanation:
Explanation/Reference:
Explanation:
* Monitoring database operations
Real-Time Database Operations Monitoring enables you to monitor long running database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation, and Loading (ETL) jobs as a composite business operation. This feature tracks the progress of SQL and PL/SQL queries associated with the business operation being monitored. As a DBA or developer, you can define business operations for monitoring by explicitly specifying the start and end of the operation or implicitly with tags that identify the operation.
NEW QUESTION 33
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
Examine following commands:
1.ALTER PLUGGABLE DATABASE ALL OPEN;
2.ALTER DATABASE OPEN;
3.ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
- A. 3 and 1
- B. Only 3
- C. 1 and 2
- D. Only 1
- E. Only 2
Answer: A
Explanation:
http://www.oracle-base.com/articles/12c/multitentant-flashback-of-containerdatabase-12cr1.php
NEW QUESTION 34
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
Which three are prerequisites for successful execution of the command? (Choose three.)
- A. The path of data files on the target database must be the same as that on the source database.
- B. The export dump file must be created before starting the import on the target database.
- C. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASErole, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASErole.
- D. The impdpoperation must be performed by the same user that performed the expdpoperation.
- E. All the user-defined tablespaces must be in read-only mode on the source database.
- F. The source and target database must be running on the same platform with the same endianness.
Answer: C,E,F
Explanation:
Explanation/Reference:
Explanation:
In this case we have run the impdp without performing any conversion if endian format is different then we have to first perform conversion.
NEW QUESTION 35
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
- A. Data Pump full export / import
- B. RMAN
- C. The DBMS_PDB package
- D. Transportable tablespace
- E. Transportable database
Answer: D
NEW QUESTION 36
Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users c# #A admin and B_ADMIN have only connect privileges.
You create a common role c##_role1 with common privileges create table and select any table.
You then execute these commands to grant the role to users In the root container:
SQL> GRANT c##_role1 TO c##_a_admin CONTAINER=ALL;
Then,
SQL> CONN sys/oracle HR_PDB as sysdba
SQL> GRANT C# #_role1 TO b_admin CONTAINER=CURRENT;
Which two statements are true?
- A. B_admin can create and select any table in HR_PDB
- B. B_admin can create and select any table, and grant the c##_role1 role to users in HR_PDB.
- C. C# #_A_admin can create and select any table, and grant the c##_rolei role to users in the root container.
- D. C# #_A_admin can create and select any table In the root container as well as in all current PDBs.
- E. C# #_A_admin can create and select any table in the root container as well as in all current and future PDBs.
Answer: A,D
NEW QUESTION 37
Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?
- A. DB_KEEP_CACHE_SIZE
- B. JAVA_POOL_SIZE
- C. DB_16K_CACHE_SZIE
- D. SORT_AREA_SIZE
- E. LOG_BUFFER
- F. STREAMS_POOL_SIZE
Answer: A,C,E
Explanation:
Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization Parameter / The log buffer LOG_BUFFER / The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE / Nonstandard block size buffer caches DB_nK_CACHE_SIZE
Note:
*In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.
*Table, Automatically Sized SGA Components and Corresponding Parameters
NEW QUESTION 38
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 used re-optimization cardinality feedback for the query.
- B. The optimizer chose different plans because automatic dynamic sampling was enabled.
- 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: B
Explanation:
Explanation/Reference:
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 39
......
Upgrade to Oracle Database 12c Certification Sample Questions and Practice Exam: https://www.itexamsimulator.com/1Z0-060-brain-dumps.html
