Oracle 1Z0-060 Braindumps 2021

NEW QUESTION 1
What are three purposes of the RMAN “FROM” clause?

• A. to support PUSH-based active database duplication
• B. to support synchronization of a standby database with the primary database in a Data environment
• C. To support PULL-based active database duplication
• D. To support file restores over the network in a Data Guard environment
• E. To support file recovery over the network in a Data Guard environment

Answer: BDE

NEW QUESTION 2
Which three statements are true concerning the multitenant architecture?

• A. Each pluggable database (PDB) has its own set of background processes.
• B. A PDB can have a private temp tablespace.
• C. PDBs can share the sysaux tablespace.
• D. Log switches occur only at the multitenant container database (CDB) level.
• E. Different PDBs can have different default block sizes.
• F. PDBs share a common system tablespace.
• G. Instance recovery is always performed at the CDB level.

Answer: BDG

NEW QUESTION 3
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. 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.
• B. Run the Automatic Workload Repository Monitor (ADDM).
• C. 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.
• D. 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.

Answer: D

NEW QUESTION 4
Which two statement is true concerning dropping a pluggable database (PDB)?

• A. The PDB must be open in read-only mode.
• B. The PDB must be in mount state.
• C. The PDB must be unplugge
• D. The PDB data files are always removed from disk.
• E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Answer: CD

NEW QUESTION 5
Which two statements are true about the RMAN validate database command?

• A. It checks the database for intrablock corruptions.
• B. It can detect corrupt pfiles.
• C. It can detect corrupt spfiles.
• D. It checks the database for interblock corruptions.
• E. It can detect corrupt block change tracking files.

Answer: AC

NEW QUESTION 6
You execute the following PL/SQL:

Which two statements are true?

• A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accesse
• B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accesse
• C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
• D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Answer: AD

NEW QUESTION 7
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. Compare Period ADDM report
• B. AWR Compare Period report
• C. Active Session History (ASH) report
• D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: B

NEW QUESTION 8
The tnsnames.ora file has an entry for the service alias ORCL as follows:

The TNS ping command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?

• A. The listener is not running on the database node.
• B. The TNS_ADMIN environment variable is set to the wrong value.
• C. The orcl.oracle.com database service is not registered with the listener.
• D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
• E. The listener is running on a different port.

Answer: C

NEW QUESTION 9
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?

• A. The database must have multiplexed redo logs for the flashback to succee
• B. The database must be MOUNTED for the flashback to succee
• C. The database must use block change tracking for the flashback to succee
• D. The database must be opened in restricted mode for the flashback to succee
• E. The database must be opened with the RESETLOGS option after the flashback is complete.
• F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Answer: BE

NEW QUESTION 10
Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

• A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEE
• B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEE
• C. Use the DBMS_PDB package to clone an existing PD
• D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CD
• E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CD

Answer: AD

NEW QUESTION 11
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘
+data/prod/myfile.dbf’
What is the result?

• A. The file ‘+dat
• B. 231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
• C. The file ‘+dat
• D. 231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
• E. The file ‘+dat
• F. 231.54769’ remains in the same location and a synonym 'myfile.dbf' is create
• G. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+dat
• H. 231.54769’ in the data dictionary remove

Answer: C

NEW QUESTION 12
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

NEW QUESTION 13
Which three statements are true about Automatic Workload Repository (AWR)?

• A. All AWR tables belong to the SYSTEM schem
• B. The AWR data is stored in memory and in the database.
• C. The snapshots collected by AWR are used by the self-tuning components in the database
• D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E. AWR contains system wide tracing and logging information.

Answer: CDE

NEW QUESTION 14
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_FILE parameter:
DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

• A. Set DB_FLASH_CACHE_ZISE = 64G.
• B. Set DB_FLASH_CACHE_ZISE = 64G, 64G
• C. Set DB_FLASH_CACHE_ZISE = 128G.
• D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Answer: B

NEW QUESTION 15
You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?

• A. Increasing the priority of the job class to which the job belongs
• B. Increasing the job's relative priority within the Job class to which it belongs
• C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
• E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
• F. Increasing the priority of the scheduler window to which the job belongs

Answer: CF

NEW QUESTION 16
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is 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 ARHCHIVELOG mode.
• B. Take the user data tablespace offline.
• C. Place the root container in the nomount stage.
• D. Ensure that HR_PDB is open.

Answer: A

NEW QUESTION 17
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?

• A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
• B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
• C. BACKUP DATABASE while connected to the PDB1 container
• D. BACKUP DATABASE while connected to the boot container
• E. BACKUP PLUGGABLE database PDB1 while connected to PDB2

Answer: AC