Download the Latest 1Z0-060 Dumps - 2021 1Z0-060 Exam Questions
Latest Oracle 1Z0-060 Certification Practice Test Questions
Exam topics:
- Database security: You should be updated with the latest security features in Oracle database, be able to manage and configure auditing if you are going to answer the exam questions from this section.
- Database operation monitoring: The candidates are tested on whether they are able to use OUI and DBCA and whether they can implement real-time DB operation monitoring.
- Multitenant Container Database (CDB): You are required to be able to explain multitenant and root architecture and identify the benefits of multitenant container database.
- Managing CDBs and PDBs: The following are the items tested here: establishing a connection to PDB/CDB, starting up and shutting down PDB/CDB.
There are several online platforms where you can enroll to train for the exam. These platforms provide the candidates with study materials, which are designed to cover what will be asked in the exam. Make sure that you are using the right resources, or you may risk wasting considerable amount of your time only to be disappointed during the test. Imagine what you would feel starting the exam only to realize that whatever you were revising was false. In addition to wasting your time, it will cost you financially.
NEW QUESTION 44
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. Transportable database
- B. RMAN
- C. Data Pump full export / import
- D. Transportable tablespace
- E. The DBMS_PDB package
Answer: D
NEW QUESTION 45
You find this query being used in your Oracle 12c database:
Which method is used by the optimizer to limit the rows being returned?
- A. 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.
- B. A filter is added to the query dynamically using ROWNUM to limit 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. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
Answer: D
NEW QUESTION 46
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. Parallel recompilation of Java code
- E. Sequential recompilation of Java code
- F. Sequential recompilation of any stored PL/SQL code
Answer: C,D
Explanation:
utlrp.sql and utlprp.sql
The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database. They are typically run after major database changes such as upgrades or patches. They
are located in the $ORACLE_HOME/rdbms/admin directory and provide a wrapper on the
UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line
parameter of "0". The utlprp.sql accepts a single integer parameter that indicates the level of
parallelism as follows.
0 - The level of parallelism is derived based on the CPU_COUNT parameter.
1 - The recompilation is run serially, one object at a time.
N - The recompilation is run in parallel with "N" number of threads.
Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly.
Reference: Recompiling Invalid Schema Objects
NEW QUESTION 47
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)
- A. CPU
- B. Parallel server limit
- C. Local file system I/O
- D. Maximum Idle time
- E. Exadata I/O
- F. Maximum Undo per consumer group
Answer: A,B,E
Explanation:
Explanation
http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11852
NEW QUESTION 48
Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c?
(Choose two.)
- A. You cannot start up or shut down a database instance by using EM express.
- B. By default, EM express is available for a database after database creation.
- C. Multiple databases on the same node (or host) may each be individually managed by using EM Express.
- D. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- E. You can create and configure pluggable databases by using EM express.
Answer: A,C
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 49
You execute the following commands toaudit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSIONWHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?
- A. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
- B. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
- C. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
- D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
- E. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
Answer: C
Explanation:
Note:
*BY SESSION
In earlier releases, BY SESSION caused the database to write a single record for all SQL
statements or operations of the same type executed on the same schema objects in the
same session. Beginning with this release(11g)of Oracle Database, both BY SESSION and
BY ACCESS cause Oracle Database to write one audit record for each audited statement
and operation.
*BY ACCESS
Specify BY ACCESS if you want Oracle Database to write one record for each audited
statement and operation.
Note:
If you specify either a SQL statement shortcut or a system privilege that audits a data
definition language (DDL) statement, then the database always audits by access. In all
other cases, the database honors the BY SESSION or BY ACCESS specification.
*For each audited operation, Oracle Database produces an audit record containing this
information:
/The user performing the operation
/The type of operation
/The object involved in the operation
/The date and time of the operation
Reference:Oracle Database SQL Language Reference 12c
NEW QUESTION 50
Which two are prerequisites for performing a flashback transaction?
- A. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
- B. Block change tracking must be enabled tor the database.
- C. Undo retention guarantee for the database must be configured.
- D. Supplemental logging must be enabled.
- E. Recycle bin must be enabled for the database.
- F. Flashback Database must be enabled.
Answer: A,C
Explanation:
B: Specify the RETENTION GUARANTEE clause for the undo tablespace to ensure that unexpired undo data is not discarded.
C: You must have the EXECUTE privilege on the DBMS_FLASHBACK package. Note:
* Use Flashback Transaction to roll back a transaction and its dependent transactions while the database remains online. This recovery operation uses undo data to create and run the corresponding compensating transactions that return the affected data to its original state. (Flashback Transaction is part of DBMS_FLASHBACK package.)
Reference: Oracle Database Advanced Application Developer's Guide 11g, Using Oracle Flashback Technology
NEW QUESTION 51
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? (Choose three.)
- A. ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array
- B. Database files stored in any file system and accessed using the Oracle Direct NFS feature
- C. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
- D. ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files
- E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
- F. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
- G. Database files stored in ZFS and accessed using conventional NFS mounts.
Answer: C,E,F
Explanation:
HCC requires the use of Oracle Storage - Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.
NEW QUESTION 52
Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;
Which is guaranteed to be true concerning the redaction policy?
- A. RANDOM redaction is active on the HIREDATE column
- B. FULL redaction is active on the SAL column
- C. PARTIAL redaction is active of the HIREDATE column.
- D. PARTIAL redaction is active on the MGR column.
- E. RANDOM redaction is active on the MGR column
Answer: B
NEW QUESTION 53
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. Two 64G flash cache files will be used.
- B. Two 32G flash cache files will be used.
- C. It results in an error because these parameter settings are invalid.
- D. One 64G flash cache file will be used.
Answer: D
NEW QUESTION 54
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?
- A. ALTER TABLE SPLIT PARTITION
- B. ALTER TABLE DROP PARTITION
- C. ALTER TABLE TRUNCATE PARTITION
- D. ALTER TABLE MOVE PARTITION
- E. ALTER TABLE MERGE PARTITION
- F. ALTER TABLE ADD PARTITION
Answer: B,C
Explanation:
Explanation/Reference:
Explanation:
Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION
This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.
NEW QUESTION 55
The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.
- A. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
- B. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
- C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
- D. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
- E. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
- F. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
- G. BACKUP SPFILE SECTION SIZE 1M;
Answer: B,C,E,F
Explanation:
Incorrect:
Not B: An image copy is an exact copy of a single datafile, archived redo log file, or control file.
Image copies are not stored in an RMAN-specific format. They are identical to the results of
copying a file with operating system commands. RMAN can use image copies during RMAN
restore and recover operations, and you can also use image copies with non-RMAN restore and
recovery techniques.
Not G: You cannot use section size for a full database backup.
Note:
*If you specify the SECTION SIZE parameter on the BACKUP command, then RMAN produces a multisection backup. This is a backup of a single large file, produced by multiple channels in parallel, each of which produces one backup piece. Each backup piece contains one file section of the file being backed up.
*Some points to remember about multisection backups include:
NEW QUESTION 56
A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICALand the CONTROL_MANAGEMENT_PACK_ACCESSparameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?
- A. Enable SQL trace for the query.
- B. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPSprocedure to monitor query execution and view the information from the V$SESSION_LONGOPSview.
- C. Execute the query and view Active Session History (ASH) for information about the query.
- D. Create a database operation, execute the query, and use the
DBMS_SQL_MONITOR.REPORT_SQL_MONITORfunction to view the report.
Answer: D
Explanation:
The REPORT_SQL_MONITOR function is used to return a SQL monitoring report for a specific SQL statement.
Incorrect Answers:
A: Not interested in session statistics, only in statistics for the particular SQL query.
B: We are interested in statistics, not tracing.
D: SET_SESSION_LONGOPS Procedure
This procedure sets a row in the V$SESSION_LONGOPS view. This is a view that is used to indicate the on- going progress of a long running operation. Some Oracle functions, such as parallel execution and Server Managed Recovery, use rows in this view to indicate the status of, for example, a database backup.
Applications may use the SET_SESSION_LONGOPS procedure to advertise information on the progress of application specific long running tasks so that the progress can be monitored by way of the V$SESSION_LONGOPS view.
NEW QUESTION 57
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 DATABASE while connected to the PDB1 container
- B. BACKUP PLUGGABLE database PDB1 while connected to PDB2
- C. BACKUP DATABASE while connected to the boot container
- D. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
- E. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
Answer: A,D
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 58
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. The partitions can be compressed in the new tablespaces.
- C. Global indexes must be rebuilt manually after moving the partitions.
- D. Local indexes must be rebuilt manually after moving the partitions.
- E. The partitions can be compressed in the same tablespaces.
Answer: A,B,E
Explanation:
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.
Incorrect:
Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when
you move the table.
NEW QUESTION 59
You must track all transactions that modify certain tables in the SALES schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)
- A. Create a Flashback Data Archive in the tablespace where the tables are stored.
- B. Specify undo retention guarantee for the database.
- C. Enable Flashback Data Archiving for the tables that require tracking.
- D. Enable supplemental logging for the database.
- E. Create a Flashback Data Archive in any suitable tablespace.
Answer: C,E
Explanation:
Explanation/Reference:
Explanation:
E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.
D: Creating a Flashback Data Archive
/Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following:
Name of the Flashback Data Archive
Name of the first tablespace of the Flashback Data Archive
(Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace
/Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years:
CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR;
NEW QUESTION 60
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);
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which statement is correct?
- A. Both the indexes are created; however, only the ORD_CUSTOMER_IX2 index is visible.
- B. Both the indexes are created and both of them are visible.
- C. Both the indexes are created; however, only the ORD_CUSTOMER_IX1 index is visible.
- D. Only the ORD_CUSTOMER_IX1 index is created and it is visible.
Answer: A
NEW QUESTION 61
......
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 |
|
Verified 1Z0-060 Dumps Q&As - 1 Year Free & Quickly Updates: https://www.practicedump.com/1Z0-060_actualtests.html