Free Oracle 1Z0-042 Exam Dumps Questions & Answers

Your database is not configured for session failover. Your tnsnames.ora file contains the following details:
test.us.oracle.com= (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=off) (FAILOVER=ON) (ADDRESS=(PROTOCOL=tcp)(HOST=test1-server)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=test.us.oracle.com)))
Which feature is enabled in this case?

• A.  Database failover
• B.  Connect-time failover
• C.  Transparent Application Failover (TAF)
• D.  Load balancing
• E.  Instance failover

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.  Use an external table so you can have the metadata available in your database, but leave the data in the operating system files.
• 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.  Upgrade the hardware/memory to accommodate the data.

You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?

• A.  Recovery Manager (RMAN) script
• B.  Operating System (OS) script
• C.  Enterprise Manager (EM) script
• D.  SQL script
• E.  PL/SQL script

Which statement is true when you run the SQL Tuning Advisor with limited scope?

• A.  Access path analysis is not performed for the SQL statements.
• B.  SQL Profile recommendations are not generated for the SQL statements.
• C.  The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
• D.  SQL structure analysis is not performed for the SQL statements.

Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;
What would be the outcome of this command?

• A.  The parameter value would be changed and it would come into effect immediately.
• B.  You need to restart the database so that parameter changes can come into effect.
• C.  The command would return an error because LOG_BUFFER is a static parameter.
• D.  The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.