Oracle Database 12c: Installation and Administration (1z1-062) Free Practice Test

Question 1

Which two statements correctly describe the relationship between data files and logical database structures?
(Choose two.)

A. A segment cannot span data files.

B. The size of an Oracle data block in a data file should be the same as the size of an OS block.

C. A data file can belong to only one tablespace.

D. An extent cannot span data files.

Correct Answer: C,D

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

Question 2

Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)

A. Oracle Enterprise Manager Cloud Control

B. Oracle Net Manager

C. Oracle Net Configuration Assistant

D. Listener Control Utility (LSNRCTL)

E. Oracle Enterprise Manager Database Express

Correct Answer: A,B

Question 3

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?

A. Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.

B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.

C. Run catuppst.sql to perform revalidation actions

D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

Correct Answer: D

Question 4

You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?

A. It automatically coalesces free space of a data block when it reaches 20% of available space.

B. It allows only 80% of space to be occupied in all data blocks of this table.

C. It minimizes row chaining during row insertion.

D. It minimizes row migration during existing row data updation.

Correct Answer: B

Question 5

Which statement is true regarding the DEFAULT profile?

A. It can be dropped and recreated.

B. it must be explicitly assigned to the user.

C. The values assigned to the resource limits and password parameters in the default profile can be altered.

D. A different DEFAULT profile can be created before each user in a database.

Correct Answer: C

Question 6

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

A. Putting the MASTERTBS tablespace in read-only mode

B. Dropping the relationship between the tables

C. Adding the MASTERTBS tablespace to the recovery set

D. Taking the MASTERTBS tablespace offline

Correct Answer: B,C

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

Question 7

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. Edition-Based Table Redefinition.

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

C. Online Table Redefinition.

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

E. Oracle Data Pump.

Correct Answer: C

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

Question 8

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.
Which two tools or utilities would you use to achieve this? (Choose two.)

A. Oracle Enterprise Manager Cloud Control

B. Oracle Enterprise Manager Database Express (EM Express)

C. Database Configuration Assistant (DBCA)

D. Recovery Manager (RMAN) script invoked by using scheduler

Correct Answer: A,D

Question 9

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?

A. a default database configuration

B. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

C. a General Purpose database template with default memory allocation

D. a Data Warehouse database template, with the dedicated server mode option and AMM enabled

Correct Answer: B

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

Welcome to TestSimulate

Oracle Database 12c: Installation and Administration (1z1-062) Free Practice Test