QUESTION 111
While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script accomplish?
A. It creates the pointer file.
B. It creates the base directory.
C. It creates the Inventory pointer file.
D. It creates the Oracle user for installation.
E. It modifies the Unix kernel parameters to match Oracle’s requirement.
Answer: C
QUESTION 112
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
A. FULL
B. SCHEMAS
C. REMAP_SCHEMA
D. REMAP_DATAFILES
E. REMAP_TABLESPACE
Answer: C
QUESTION 113
Which two are valid locking levels that are used by transactions in an Oracle database? (Choose two.)
A. row level
B. block level
C. object level
D. schema level
E. database level
Answer: AC
QUESTION 114
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?
A. RECOVER LOGFILE BLOCK GROUP 2;
B. ALTER DATABASE DROP LOGFILE GROUP 2;
C. ALTER DATABASE CLEAR LOGFILE GROUP 2;
D. ALTER DATABASE RECOVER LOGFILE GROUP 2;
E. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
Answer: E
QUESTION 115
View the Exhibit.
The DBA creates a new user as follows:
SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp;
User manfus creates a table as follows:
SQL> CREATE TABLE material(id NUMBER(3));
In which tablespace will the material table be created? 
A. TEMP
B. PROD
C. USERS
D. SYSAUX
E. SYSTEM
Answer: C
QUESTION 116
In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? (Choose two.)
A. Event Viewer gives more details on the failure.
B. The alert log file gives detailed information about the failure.
C. PMON rolls back the transaction and releases the locks.
D. SMON rolls back the transaction and releases the locks.
E. The transaction is rolled back by the next session that refers to any of the blocks updated by the failed transaction.
F. Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
Answer: CF
QUESTION 117
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?
A. B-tree
B. bitmap
C. reverse key
D. function based
Answer: B
QUESTION 118
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true?
A. It is a SQL script.
B. It is a PL/SQL file.
C. It is an operating system (OS) file.
D. It is a Recovery Manager (RMAN) script.
Answer: D
QUESTION 119
View the Exhibit to see the source and target databases. You have created a database link, devdb.us.oracle.com, between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from the development database, DEVDB, to the production database, PRODDB. You execute the following command on the target database server:
$impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = 2004-02-03 09:00
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. remove the dumpfile option in the command
B. remove the flashback_time option in the command
C. add the user, SYSTEM, to the schemas option in the command
D. add network_link = devdb.us.oracle.com option in the command
E. remove the schemas option and add the network_link = devdb.us.oracle.com option in the command
F. remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command
Answer: F
QUESTION 120
Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp;
Table dropped.
What happens in this scenario?
A. The table is moved to the SYSAUX tablespace.
B. The table is moved to the SYSTEM tablespace.
C. The table is removed from the database permanently.
D. The table is renamed and remains in the TBSFD tablespace.
Answer: D
Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader
