Oracle 1Z0-060 Braindumps 2021

NEW QUESTION 1
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

• A. SYSTEM
• B. SYSAUX
• C. EXAMPLE
• D. UNDO
• E. TEMP
• F. USERS

Answer: ABE

NEW QUESTION 2
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

• A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• B. Increase the database buffer cache size.
• C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
• D. Configure Automata Shared Memory Management.
• E. Configure Automatic Memory Management-

Answer: A

NEW QUESTION 3
Which Oracle Database component is audited by default if the unified Auditing option is enabled?

• A. Oracle Data Pump
• B. Oracle Recovery Manager (RMAN)
• C. Oracle Label Security
• D. Oracle Database Vault
• E. Oracle Real Application Security

Answer: B

NEW QUESTION 4
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA. EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA. EXAM_RESULTS table to the OCP schema?

• A. Execute FLASHBACK TABLE OC
• B. EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.
• C. Recover the table using traditional Tablespace Point In Time Recovery.
• D. Recover the table using Automated Tablespace Point In Time Recovery.
• E. Recovery the table using Database Point In Time Recovery.
• F. Execute FLASHBACK TABLE OC
• G. EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

Answer: C

NEW QUESTION 5
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

• A. A DBA can check specific tables with the DMU
• B. The database to be migrated must be opened read-only.
• C. The release of the database to be converted can be any release since 9.2.0.8.
• D. The DMU can report columns that are too long in the converted characterset.
• E. The DMU can report columns that are not represented in the converted characterset.

Answer: ADE

NEW QUESTION 6
Which three statements are true about Oracle Data Pump export and import operations?

• A. You can detach from a data pump export job and reattach later.
• B. Data pump uses parallel execution server processes to implement parallel import.
• C. Data pump import requires the import file to be in a directory owned by the oracle owner.
• D. The master table is the last object to be exported by the data pump.
• E. You can detach from a data pump import job and reattach later.

Answer: ADE

NEW QUESTION 7
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. Recover and open the CDB in NORMAL mode.
• C. Mount the CDB and then recover and open the database, with the RESETLOGS option.
• D. Open all the pluggable databases.
• E. Recover each pluggable database.
• F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

Answer: CDF

NEW QUESTION 8
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 9
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
\1.Mount the CDB.
\2.Close all the PDBs.
\3.Open the database.
\4.Apply the archive redo logs.
\5.Restore the data file.
\6.Take the SYSAUX tablespace offline.
\7.Place the SYSAUX tablespace online.
\8.Open all the PDBs with RESETLOGS.
\9.Open the database with RESETLOGS.
\10.Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

• A. 6, 5, 4, 7
• B. 10, 1, 2, 5, 8
• C. 10, 1, 2, 5, 4, 9, 8
• D. 10, 1, 5, 8, 10

Answer: A

NEW QUESTION 10
Which two statements are true when row archival management is enabled?

• A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
• B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
• C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
• D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
• E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

Answer: CD

NEW QUESTION 11
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

• A. You can conned as a common user by using the connect statement.
• B. You can connect as a local user by using the connect statement.
• C. You can connect by using easy connect.
• D. You can connect by using OS authentication.
• E. You can connect by using a Net Service name.
• F. You can connect as a local user by using the SET CONTAINER statement.

Answer: ACE

NEW QUESTION 12
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1.Create a policy to capture the privilege used by a user for privilege analysis.
2.Generate a report with the data captured for a specified privilege capture.
3.Start analyzing the data captured by the policy.
4.Revoke the unused privileges.
5.Compare the used and unused privileges’ lists.
6.Stop analyzing the data.
Identify the correct sequence of steps.

• A. 1, 3, 5, 6, 2, 4
• B. 1, 3, 6, 2, 5, 4
• C. 1, 3, 2, 5, 6, 4
• D. 1, 3, 2, 5, 6, 4
• E. 1, 3, 5, 2, 6, 4

Answer: B

NEW QUESTION 13
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

• A. SYS, SYSTEM
• B. SCOTT
• C. Only for successful executions
• D. Only for failed executions
• E. Both successful and failed executions

Answer: AE

NEW QUESTION 14
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

• A. It results in an error because these parameter settings are invali
• B. One 64G flash cache file will be use
• C. Two 64G flash cache files will be use
• D. Two 32G flash cache files will be use

Answer: A

NEW QUESTION 15
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 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 dat
• B. 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.
• C. 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 dat
• D. 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 dat
• E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• F. 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 dat

Answer: CDF

NEW QUESTION 16
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 a dynamic plan for the query.
• B. The optimizer chose different plans because automatic dynamic sampling was enable
• C. The optimizer used re-optimization cardinality feedback for the query.
• D. The optimizer chose different plan because extended statistics were created for the columns use

Answer: B

NEW QUESTION 17
You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?

• A. Corrupted blocks, if any, are repaire
• B. Checks are performed for physical corruptions.
• C. Checks are performed for logical corruptions.
• D. Checks are performed to confirm whether all database files exist in correct locations
• E. Backup sets containing both data files and archive logs are create

Answer: BD