Q1. Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)

A. An SPFILE is a binary file

B. An SPFILE cannot reside on a client

C. An SPFILE cannot contain static parameters

D. An SPFILE can store changes persistently across instance restarts

E. An SPFILE can be read by the database server, but it is not written to by the server

F. An SPFILE must be created manually, before creating a database, even if you use the

Database Configuration Assistant (DBCA) to create the database

View Answer

Q2. Which statement is true about loading data using the conventional path of SQL*Loader?

A. Redo is not generated while performing conventional path loads

B. Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked

C. No exclusive locks are acquired when the conventional path loads are performed

D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files

E. INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

View Answer

Q3. Which three statements are correct about temporary tables? (Choose three.)

A. Indexes and views can be created on temporary tables.

B. Both the data and the structure of temporary tables can be exported.

C. Temporary tables are always created in a user's temporary tablespace.

D. The data inserted into a temporary table in a session is available to other sessions.

E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

View Answer

Q4. Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

A. You can add SQL test cases to the incident package.

B. You can add or remove the trace files to the package.

C. You cannot create an incremental incident package when the physical files are purged from the ADR.

D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

View Answer

Q5. database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:

$ impdp system/manager directory = DB_DATA

dumpfile = schemas.dat

schemas = hr

flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"

The command fails displaying the following error:

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable to obtain file status

What would you do to overcome the error?

A. Add the user, SYSTEM, to the schemas option.

B. Add the network_link = devdb.us.oracle.com option.

C. Change the dumpfile option to schema.dat@devdb.us.oracle.com.

D. Replace the schemas option with the network_link = devdb.us.oracle.com

E. Replace the dumpfile option with the network_link = devdb.us.oracle.com

View Answer

Q6. View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:

SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US

FROM v$memory_dynamic_components

WHERE current_size!=0;

What do you infer from this?

Exhibit:

A. The database instance is running with manual PGA management.

B. The database instance is running with manual shared memory management.

C. The database instance has the MEMORY_TARGET value set to a nonzero value.

D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

View Answer

Q7. You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.

Which statement is true in this case?

A. The ORACLE_BASE parameter is not set.

B. The installation is being performed by the root user.

C. The operating system group that will be specified should have root user as its member.

D. The installation is being performed without the "Create Starter Database" option selected.

E. The operating system group that will be specified must have permission to write to the inventory directory.

View Answer

Q8. See the Exhibit:

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

A. A bitmap is used to record free extents

B. Free extents information is managed within the tablespace

C. Free extents information is managed in the SYSAUX tablespace

D. The data dictionary tables are updated when extents are allocated or deallocated

View Answer

Q9. You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.

Which two statements are true in this scenario? (Choose two.)

A. You must shut down the database instance to perform the backups.

B. You must configure the Flash Recovery Area (FRA) for the database.

C. You can perform complete database backups without closing the database.

D. All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.

View Answer

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