1z1-062 by Oracle Valid Free Exam Practice Test

Question 1

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? (Choose three.)

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

Correct Answer: B,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

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?

A. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes. B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes. C. Oracle Data Pump. D. Online Table Redefinition. E. Edition-Based Table Redefinition.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Identify three situations in which messages are written to the alert log file. (Choose three.)

A. Inserting a value into a table returns "ORA-00001: unique constraint (SYS.PK_XXXX) violated" B. Inserting a value into a table returns "ORA-01722: invalid number" C. Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource" D. Creating a table returns "ORA-00955: name is already in used by an existing object" E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50)" F. Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"

Correct Answer: C,E,F

Question 4

Which two services may you see on the My Service Dashboard page? (Choose two.)

A. User Cloud Service B. Network Cloud Service C. Database Cloud Service D. Compute Cloud Service

Correct Answer: C,D

Question 5

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result? (Choose three.)

A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries. B. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries. C. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries. D. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column. E. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries. F. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.

Correct Answer: A,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

A. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command. B. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB. C. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command. D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.
Which statement is true about the loss of a duplexed control file?

A. The database instance aborts and a control file restore operation does not require media recovery. B. The database instance remains open and the control file can be restored without shutting down the database. C. The database instance aborts, and media recovery is required after restoration of the control file to open the database. D. The database remains open but transactions are not permitted.

Correct Answer: B

Question 8

A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to
400 and make it persistent for your database instance.
You plan to use the ALTER SYSTEM command.
Which two methods can be used? (Choose two.)

A. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command. B. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE. C. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command. D. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command. E. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command. F. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.

Correct Answer: A,F

Question 9

An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted.
Which two types of lock are held by the transaction? (Choose two.)

A. a null lock on the EMPLOYEES table B. a null lock on the row being updated C. an exclusive lock on the EMPLOYEES table D. a row level lock on the row being updated E. a row shared lock on the EMPLOYEES table

Correct Answer: D,E

Question 10

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

A. Default section size for backups B. Default backup device type C. Multiple backup device types for single backup D. Backup retention policy E. Default destinations for backups

Correct Answer: B,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 11

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

A. The CDB must be in the mount stage. B. The CDB must be in the nomount stage. C. The CDB must be open. D. Alt existing PDBs must be closed.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 12

You execute the following PL/SQL:

Which two statements are true? (Choose two.)

A. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. B. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. C. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Correct Answer: A,C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 13

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character Set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A. The DBMS_PDB package B. RMAN C. Transportable tablespace D. Data Pump full export/import E. Transportable database

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 14

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

A. Tracking the most recent write time for a table segment in a user tablespace B. Tracking the most recent write time for a table block C. Tracking insert time by row for table rows D. Tracking the most recent read time for a table segment in a user tablespace E. Tracking the most recent write time for a table segment in the SYSAUX tablespace F. Tracking the most recent read time for a table segment in the SYSAUX tablespace

Correct Answer: A,B,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 15

Which three statements are true about Enterprise Manager Database Express? (Choose three.)

A. It is available only when the database is open. B. It can use the HTTP protocol. C. The same port number is used for multiple Database Express configurations on the same host. D. It can be used to perform database backup operations. E. It can use the HTTPS protocol.

Correct Answer: A,B,E

Oracle Database 12c: Installation and Administration - 1z1-062 Exam Practice Test