QUESTION 91
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. 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 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 SQL*Loader utility
D.    use the direct path data load of Oracle export and import utility

Answer: C

QUESTION 92
You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?

A.    Upgrade the hardware/memory to accommodate the data.
B.    Load the data into your database by using the PARALLEL clause.
C.    Give analysts DBA privilege, so that they can query DBA_EXTERNAL_TABLES.
D.    Use an external table so you can have the metadata available in your database, but leave the data in the operating system files.

Answer: D

QUESTION 93
Which two statements are true about the primary key constraint in a table? (Choose two.)

A.    It is not possible to disable the primary key constraint.
B.    It is possible to have more than one primary key constraint in a single table.
C.    The primary key constraint can be referred by only one foreign key constraint.
D.    The primary key constraint can be imposed by combining more than one column.
E.    The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

Answer: DE

QUESTION 94
You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?

A.    The database performance would be enhanced.
B.    The redo log files would be get filled more frequently.
C.    The overall database performance would be degraded.
D.    The mean time to recover (MTTR) would be increased.

Answer: C

QUESTION 95
View the Exhibit.
Your Oracle 10g database has 6 tablespaces in which:
-TEMP is the default temporary tablespace
– UNDOTBS1 is the default undo tablespace
– USERS is the default permanent tablespace
In this database, which three tablespaces can be made offline? (Choose three.)

A.    TEMP
B.    PROD
C.    USERS
D.    SYSAUX
E.    SYSTEM
F.    UNDOTBS1

Answer: BCD

QUESTION 96
Data files of which three tablespaces can be recovered by performing an open recovery? (Choose three.)

A.    TEMP
B.    UNDO
C.    INDEX
D.    SYSAUX
E.    SYSTEM

Answer: ACD

QUESTION 97
The HR user creates a view with this command:
SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp;
Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario?

A.    HR can grant the privilege to JIM but without GRANT OPTION.
B.    HR can grant the privilege to JIM because HR is the owner of the view.
C.    SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D.    HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

Answer: D

QUESTION 98
You executed the following command to back up your control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which initialization parameter is used to specify the location of the trace file?

A.    USER_DUMP_DEST
B.    CORE_DUMP_DEST
C.    TRACE_DUMP_DEST
D.    BACKUP_DUMP_DEST
E.    BACKGROUND_DUMP_DEST

Answer: A

QUESTION 99
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?

A.    Use the CREATE DATABASE .. command to create the database with Oracle-managed files.
B.    Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
C.    Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
D.    Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
E.    Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

Answer: D

QUESTION 100
The junior DBA in your organization has accidentally deleted the alert log file. What will you do to create new alert log file?

A.    Create the new text file file as ALERT.LOG.
B.    You have to recover the alert log file from the valid backup.
C.    Change the value for the BACKGROUND_DUMP_DEST parameter.
D.    No action required.The file would be created automatically by the instance.

Answer: D

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader