Q1. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?

A. Use the external table population.

B. Use the Oracle Data Pump export and import utility.

C. Use the conventional path data load of the SQL*Loader utility.

D. Use the INSERT INTO...SELECT command to load the data.

View Answer

Q2. Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

A. Data Files

B. Control Files

C. Parameter Files

D. Online Redo Log Files

E. Server Parameter File

View Answer

Q3. You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.

Which constraints will remain enabled by default during this operation? (Choose all that apply.)

A. CHECK

B. UNIQUE

C. NOT NULL

D. PRIMARY KEY

E. FOREIGN KEY

View Answer

Q4. Identify the two situations in which the alert log file is updated with details. (Choose two.)

A. Running a query on a table returns "ORA-600: Internal Error"

B. Inserting a value in a table returns "ORA-01722: Invalid Number"

C. Creating a table returns "ORA-00955: name is already used by an existing object'

D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

E. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block @ 50)."

F. Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file #14, block #50)."

View Answer

Q5. To make audit information more productive, the DBA executes the following command before starting an audit operations:

SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;

Which statement is true regarding the audit record generated when auditing starts after restarting the database?

A. It contains only the plan for the SQL statement executed by the user

B. It contains the SQL text executed by the user and the bind variables used with it

C. It contains the plan and statistics associated with the SQL statement executed by the user D.

It contains the plan for the SQL statement executed by the user and the bind variables used with it

View Answer

Q6. Examine the command:

SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');

Which statement describes the effect of the above command?

A. Automatic statistics collection is stopped for the CUSTOMERS table

B. Statistics for the CUSTOMERS table are locked and cannot be overwritten

C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

View Answer

Q7. Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0

LOG_CHECKPOINT_INTERVAL=0

Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

View Answer

Q8. Note the following points describing various utilities in Oracle Database 11g:

1. It enables the high-speed transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the entire database

3. It enables the loading of data from an external file into table of an Oracle Database

4. It provides a tape backup management for the Oracle ecosystem

Which point describes Oracle Secure Backup?

A. 1

B. 2

C. 3

D. 4

E. 1,2 and 4

F. 1,2,3, and 4

View Answer

Q9. View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.

Which type of index would you select in this scenario?

Exhibit:

A. Bitmap index

B. Reverse key index 

C. Normal BTree index 

D. Functionbased index

View Answer

Q10. The tnsnames.ora file has an entry for the service alias ORCL as follows:

ORCL =

( DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl.oracle.com)

)

)

The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:

SQL> CONNECT scott/tiger@orcl

What could be the reason for this?

A. The listener is not running on the database node.

B. The TNS_ADMIN environmental variable is set to a wrong value.

C. The orcl.oracle.com database service is not registered with the listener.

D. The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.

View Answer