13 June, 2020

How Many Questions Of 1z0-060 Test

Our pass rate is high to 98.9% and the similarity percentage between our 1z0-060 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle 1z0-060 exam in just one try? I am currently studying for the Oracle 1z0-060 exam. Latest Oracle 1z0-060 Test exam practice questions and answers, Try Oracle 1z0-060 Brain Dumps First.

Oracle 1z0-060 Free Dumps Questions Online, Read and Test Now.

Page: 1 / 17

Total 208 questions Full Exam Access

Question 1

Identify two correct statements about multitenant architectures.

Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.

Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.

Multiple CDBs share certain PDB resources.

Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.

Patches are always applied at the CDB level.

A PDB can have a private undo tablespace.

Question 2

Examine the parameter for your database instance:
1Z0-060 dumps exhibit

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:
1Z0-060 dumps exhibit

Identify the reason why the optimizer chose different execution plans.

The optimizer used a dynamic plan for the query.

The optimizer chose different plans because automatic dynamic sampling was enable

The optimizer used re-optimization cardinality feedback for the query.

The optimizer chose different plan because extended statistics were created for the columns use

Question 3

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?

You can conned as a common user by using the connect statement.

You can connect as a local user by using the connect statement.

You can connect by using easy connect.

You can connect by using OS authentication.

You can connect by using a Net Service name.

You can connect as a local user by using the SET CONTAINER statement.

Question 4

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?

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.

Run the Automatic Workload Repository Monitor (ADDM).

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.

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.

Question 5

You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;
Which is true about the result of this command?

The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opene

The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopene

The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarte

Nothing happens; because there is no SPFILE for each PDB, the statement is ignore

Question 6

Which three statements are true about adaptive SQL plan management?

It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

It adds new, bettor plans automatically as fixed plans to the baseline.

The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generate

Question 7

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?

Execute FLASHBACK TABLE OC

EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.

Recover the table using traditional Tablespace Point In Time Recovery.

Recover the table using Automated Tablespace Point In Time Recovery.

Recovery the table using Database Point In Time Recovery.

Execute FLASHBACK TABLE OC

EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

Question 8

Which two are prerequisites for performing a flashback transaction?

Flashback Database must be enable

Undo retention guarantee for the database must be configure

EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

Supplemental logging must be enable

Recycle bin must be enabled for the database.

Block change tracking must be enabled tor the database.

Question 9

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?

Only 1

Only 2

Only 3

3 and 1

1 and 2

Question 10

Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

It succeeds only if memory is available from the autotuned components if SG

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Question 11

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
TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

Execute the query and view Active Session History (ASH) for information about the query.

Enable SQL trace for the query.

Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.

Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Question 12

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

Change in the Oracle Database version

Change in your network infrastructure

Change in the hardware configuration of the database server

Migration of database storage from non-ASM to ASM storage

Database and operating system upgrade

Question 13

You use the segment advisor to help determine objects for which space may be reclaimeD. Which three statements are true about the advisor given by the segment advisor?

It may advise the use of online table redefinition for tables in dictionary managed tablespace.

It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

It may advise the use of online table redefinition for tables in locally managed tablespaces

It will detect and advise about chained rows.

It may advise the use of segment shrink for free list managed tables.

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?

Set DB_FLASH_CACHE_ZISE = 64G.

Set DB_FLASH_CACHE_ZISE = 64G, 64G

Set DB_FLASH_CACHE_ZISE = 128G.

DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Question 15

Which three statements are true about SQL plan directives?

They are tied to a specific statement or SQL I

They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

They are used to gather only missing statistics.

They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

They instruct the optimizer to create only column group statistics.

Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Question 16

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?

Setting a metric threshold

Implementing Database Resource Manager

Enabling resumable timeout for user sessions

Decreasing the value of the IDLE_TIME resource limit in the default profile

Question 17

Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);
Which two statements are true?

Database operations will be monitored only when they consume a significant amount of resource.

Database operations for all sessions will be monitore

Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

Only DML and DDL statements will be monitored for the session.

All subsequent statements in the session will be treated as one database operation and will be monitore

Question 18

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?

The keep pool is not configure

Automatic Workarea Management is not configure

Automatic Shared Memory Management is not enable

The data blocks in the SUBSCRIBE_LOG table are rarely accesse

All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Question 19

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename
VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

Create the CREATE_TEST procedure with definer’s rights.

Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.

Create the CREATE_TEST procedure with invoker’s rights.

Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Question 20

Examine these two statements:
1Z0-060 dumps exhibit

Which three are true about the MRKT tablespace?

The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

The MRKT tablespace may be dropped if it has no contents.

Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

No more data files can be added to the tablespace.

The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Question 21

To implement Automatic Management (AMM), you set the following parameters:
1Z0-060 dumps exhibit

When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

The PGA_AGGREGATE_TARGET parameter is set to zero.

The STATISTICS_LEVEL parameter is set to BASI

Both the SGA_TARGET and MEMORY_TARGET parameters are set.

The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Question 22

Which three are true about the large pool for an Oracle database instance that supports
shared server connections?

Allocates memory for RMAN backup and restore operations

Allocates memory for shared and private SQL areas

Contains a cursor area for storing runtime information about cursors

Contains stack space

Contains a hash area performing hash joins of tables

Question 23

Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table?

The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

Referential integrity constraint cannot be set on the invisible column.

The invisible column cannot be made visible and can only be marked as unuse

A primary key constraint can be added on the invisible column.

Question 24

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?

Increasing the priority of the job class to which the job belongs

Increasing the job\'s relative priority within the Job class to which it belongs

Increasing the resource allocation for the consumer group mapped to the scheduler job\'s job class within the plan mapped to the scheduler window

Moving the job to an existing higher priority scheduler window with the same schedule and duration

Increasing the value of the JOB_QUEUE_PROCESSES parameter

Increasing the priority of the scheduler window to which the job belongs

Question 25

Which three statements are true about using flashback database in a multitenant container database (CDB)?

The root container can be flashed back without flashing back the pluggable databases (PDBs).

To enable flashback database, the CDB must be mounte

Individual PDBs can be flashed back without flashing back the entire CD

The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CD

A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Page: 1 / 17

Total 208 questions Full Exam Access