Top Quality 1Z0-060 Dumps 2021

NEW QUESTION 1
Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

• A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
• B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• C. The C # # A_ADMIN user can perform wallet operations.
• D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
• E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

Answer: BDE

NEW QUESTION 2
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

• A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• B. It fails because no SQL *Loader data file location is specifie
• C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• D. It fails because no SQL *Loader control file location is specifie

Answer: AC

NEW QUESTION 3
You are administering a database and you receive a requirement to apply the following restrictions:
1.A connection must be terminated after four unsuccessful login attempts by user.
2.A user should not be able to create more than four simultaneous sessions.
3.User session must be terminated after 15 minutes of inactivity.
4.Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

• A. by granting a secure application role to the users
• B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
• C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
• D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
• E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Answer: C

NEW QUESTION 4
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 5
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 6
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 use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database Instance by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D

NEW QUESTION 7
Which three statements are true about SQL plan directives?

• A. They are tied to a specific statement or SQL I
• B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
• C. They are used to gather only missing statistics.
• D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
• E. They instruct the optimizer to create only column group statistics.
• F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Answer: BDF

NEW QUESTION 8
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. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
• B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
• C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
• D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

Answer: D

NEW QUESTION 9
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 10
Which two statements are true about Oracle Managed Files (OMF)?

• A. OMF cannot be used in a database that already has data files created with user- specified directions.
• B. The file system directions that are specified by OMF parameters are created automatically.
• C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
• D. OMF automatically creates unique file names for table spaces and control files.
• E. OMF may affect the location of the redo log files and archived log files.

Answer: DE

NEW QUESTION 11
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?

• A. It will create a multitenant container database (CDB) with only the root opene
• B. It will create a CDB with root opened and seed read only.
• C. It will create a CDB with root and seed opened and one PDB mounte
• D. It will create a CDB that must be plugged into an existing CD
• E. It will create a CDB with root opened and seed mounte

Answer: B

NEW QUESTION 12
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

• A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
• B. The rows in the table are truncated without being archive
• C. The rows in the table are archived, and then truncate
• D. The rows in both the table and the archive are truncate

Answer: C

NEW QUESTION 13
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

• A. The partitions can be moved online to new tablespaces.
• B. Global indexes must be rebuilt manually after moving the partitions.
• C. The partitions can be compressed in the same tablespaces.
• D. The partitions can be compressed in the new tablespaces.
• E. Local indexes must be rebuilt manually after moving the partitions.

Answer: ACD

NEW QUESTION 14
Identify two correct statements about multitenant architectures.

• A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C. Multiple CDBs share certain PDB resources.
• D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E. Patches are always applied at the CDB level.
• F. A PDB can have a private undo tablespace.

Answer: BE

NEW QUESTION 15
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

• A. Parallel compilation of only the stored PL/SQL code
• B. Sequential recompilation of only the stored PL/SQL code
• C. Parallel recompilation of any stored PL/SQL code
• D. Sequential recompilation of any stored PL/SQL code
• E. Parallel recompilation of Java code
• F. Sequential recompilation of Java code

Answer: CE

NEW QUESTION 16
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 17
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

• A. The ORACLE_BASE base parameter is not set.
• B. The installation is being performed by the root user.
• C. The operating system group that is specified should have the root user as its member.
• D. The operating system group that is specified must have permission to write to the inventory directory.

Answer: D

NEW QUESTION 18
Which three statements are true about Flashback Database?

• A. Flashback logs are written sequentially, and are archive
• B. Flashback Database uses a restored control file to recover a database.
• C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Are
• D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Answer: CDF

NEW QUESTION 19
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