Free Oracle 1Z0-042 Exam Dumps Questions & Answers

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.PMON rolls back the transaction and releases the locks.
• B.The transaction is rolled back by the next session that refers to any of the blocks updated by the failed transaction.
• C.Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
• D.SMON rolls back the transaction and releases the locks.
• E.The alert log file gives detailed information about the failure.
• F.Event Viewer gives more details on the failure.

When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed:
TZ set to America/New_york
OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.
Which two environment variables do you need to set appropriately to avoid such errors, and start the Database Control successfully? (Choose two.)

• A.NLS_LANG
• B.LD_LIBRARY_PATH
• C.ORACLE_HOME
• D.ORACLE_BASE
• E.ORACLE_SID

Your test database is running in NOARCHIVELOG mode. What are the implications of this?

• A.You cannot perform schema-level logical backups.
• B.You can perform open database backups.
• C.You can perform the backup of only the SYSTEM tablespace when the database is open.
• D.You can perform closed database backups.

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:
SQL> SELECT job FROM emp
2 WHERE job='CLERK' FOR UPDATE OF empno;
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT's second session? (Choose three.)

• A.SELECT job FROM emp WHERE job='CLERK' FOR UPDATE OF empno;
• B.LOCK TABLE emp IN SHARE MODE;
• C.LOCK TABLE emp IN EXCLUSIVE MODE;
• D.INSERT INTO emp(empno,ename) VALUES (1289,'Dick');
• E.DELETE FROM emp WHERE job='MANAGER';

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 flashback_time option in the command
• B.add network_link = devdb.us.oracle.com option in the command
• C.remove the schemas option and add the network_link = devdb.us.oracle.com option in the command
• D.add the user, SYSTEM, to the schemas option in the command
• E.remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command
• F.remove the dumpfile option in the command