Pass Oracle 1Z0-060 Exam With Practice Test Questions Dumps Bundle [Q121-Q136]

Rate this post

Pass Oracle 1Z0-060 Exam With Practice Test Questions Dumps Bundle

2022 Valid 1Z0-060 test answers & Oracle Exam PDF

More Info

For more info visit: Oracle 12c Official 1Z0-060 Exam Reference

The Oracle 1Z0-060 exam validates your expertise when it comes to Oracle Database.

As you are getting ready for the Oracle 1Z0-060 certification exam, it is vital that you understand all that is entailed in this test. It is important to mention this is an exam that requires you to have more practical knowledge than theoretical concepts. The majority of those who have failed it focused their attention on cramming rather than gaining the actual skills. You should take a different perspective – be more practical.

Your journey towards earning the Oracle Certified Professional (OCP) certification begins with receiving the Oracle Certified Associate (OCA) credential. With the OCA certificate, you tell the world that you are equipped with vital skills needed to provide support for Oracle products. OCP is the benchmark of your professional career and shows that you have what it takes to implement enterprise-wide databases. Earning it begins with the single step of passing your Oracle 1Z0-060 exam. The test includes 80 questions. There will be 120 minutes to complete all of them. You have to pay 245$ for the 1Z0-060 exam.

NO.121 You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

Oracle Data Pump

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes

Online Table Redefinition

Edition-Based Table Redefinition

NO.122 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 monitored.

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 monitored.

NO.123 You plan to use the Flashback Drop feature to recover the sales_emp table that was dropped in error. No other table with the same name exists in the sh schema, which owns the table. You query the recyclebin and find multiple entries for the salesemp table:

SQL FLASHBACK TABLE sale_emp To BEFORE DROP:
What would be the result?

It returns an error because the table name in the object_name column is not specified.

It retrieves the least recently dropped version of the table from the recycle bin for which undo is still available.

It retrieves the most recently dropped version of the table.

It retrieves the most recently dropped version of the table from the recycle bin for which undo Is still available.

It retrieves the least recently dropped version of the table.

NO.124 A database is stored in an Automatic Storage Management (ASM) disk group, DGROUP1, created with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error or for maintenance?

Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 failure group is brought back online.

The data in the CONTROLLER1 failure group is copied to the CONTROLLER2 failure group and rebalancing is initiated.

ASM does not mirror any data until the CONTROLLER1 failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group, without mirroring.

NO.125 Yourmultitenantcontainer database (CDB) is runningin ARCHIVELOG mode.You connect to the CDB RMAN.
Examine the following command and its output: You execute the following command:

RMAN >BACKUP DATABASEPLUS ARCHIVELOG;
Which data files will be backed up?

Data files that belong to only the root container

Data files that belong to the root container and all the pluggable databases (PDBs)

Data files that belong to only the root container and PDB$SEED

Data files that belong to the root container and all the PDBs excluding PDB$SEED

NO.126 Examine the details of the Top 5 Timed Eventsin the followingAutomaticWorkloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

The size of the shared pool is too small.

Cursors are not being shared.

A large number COMMITS are being performed.

There are frequent logons and logoffs.

The buffers are being read into the buffer cache, but some other session is changing the buffers.

NO.127 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?

The database must have multiplexed redo logs for the flashback to succeed.

The database must be MOUNTED for the flashback to succeed.

The database must use block change tracking for the flashback to succeed.

The database must be opened in restricted mode for the flashback to succeed.

The database must be opened with the RESETLOGS option after the flashback is complete.

The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

NO.128 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.

1, 3, 5, 6, 2, 4

1, 3, 6, 2, 5, 4

1, 3, 2, 5, 6, 4

1, 3, 5, 2, 6, 4

NO.129 You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.

It generates an error when creating the table because the wallet is closed.

It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.

It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

NO.130 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 OCEXAM_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 sing Database Point In Time Recovery.

Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

NO.131 In which two scenarios do you use SQL* Loader to load data?

Transform the data while it is being loaded into the database.

Use transparent parallel processing without having to split the external data first.

Load data into multiple tables during the same load statement.

Generate unique sequential key values in specified columns.

NO.132 You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advice given by the segment advisor? (Choose three.)

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

It may advise the use of segment shrink for tables in dictionary-managed tablespaces if there are 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 freelist managed tables.

NO.133 You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?

It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

It contains username and passwords of database users who are members of the OSOPER operating system group.

It contains usernames and passwords of database users who are members of the OSDBA operating system group.

It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

NO.134 Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDBand ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’ ORA-27037: unable to obtain file status Identify two ways to rectify the error. (Choose two.)

Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.

Shut down the database instance, restore the temp01.tmpfile from the backup, and then restart the database.

Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.

Shut down the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.

Shut down the database instance and then restart the CDB and PDBs.

NO.135 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 filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.

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.

A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

A TOP-N query is created to limit the rows to 20 percent of the total rows

NO.136 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 mounted.

Individual PDBs can be flashed back without flashing back the entire CDB.

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

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

Top Oracle 1Z0-060 Courses Online: https://www.test4cram.com/1Z0-060_real-exam-dumps.html

More Info

Leave a Reply Cancel reply