Create Next App

Exam contains 381 questions

Page 6 of 64

Question 31 🔥

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to OracleDatabase 12c?

Which database solution meets these requirements?

A. shutting down the database instance that is being upgraded

Highly voted

B. executing the catctl.pl script to run the upgrade processes in parallel

Highly voted

C. running the Pre-Upgrade Information Tool

Highly voted

D. copying the listener.ora file to the new ORACLE_HOME

Highly voted

Discussion of the question

Question 32 🔥

A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to 400 and make it persistent for your database instance.You plan to use the ALTER SYSTEM command.Which two methods can be used? (Choose two.)

Which database solution meets these requirements?

A. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.

Highly voted

B. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.

Highly voted

C. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.

Highly voted

D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

Highly voted

E. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.

Highly voted

F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

Highly voted

Discussion of the question

Question 33 🔥

Your database is open and the listener LISTENER is up. You issue the command:LSNRCTL> RELOAD -What is the effect of reload on sessions that were originally established by listener?

Which database solution meets these requirements?

A. Only sessions based on static listener registrations are disconnected.

Highly voted

B. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.

Highly voted

C. The sessions are not affected and continue to function normally.

Highly voted

D. All the sessions are terminated and active transactions are rolled back.

Highly voted

Discussion of the question

Question 34 🔥

What should you do for a Scheduler to start a job when a file arrives on a remote system?

Which database solution meets these requirements?

A. Start an Oracle database instance on the remote system and register the Scheduler agent with this database.

Highly voted

B. Install the Scheduler agent on the remote system and register the agent with the database on the local system.

Highly voted

C. Ensure dedicated server is enabled on both the local and remote databases.

Highly voted

D. Shutdown the file watcher on the local system.

Highly voted

Discussion of the question

Question 35 🔥

Which statement is true regarding the startup of a database instance?

Which database solution meets these requirements?

A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option.

Highly voted

B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.

Highly voted

C. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the immediate option or the abort option.

Highly voted

D. Media recovery is required when the database is shut down by using either the immediate option or the abort option.

Highly voted

E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIAT

Highly voted

Discussion of the question

Question 36 🔥

Examine this command executed on a client that is remote from the database server.SQL> CONNECT hr/hr@orcl -Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)

Which database solution meets these requirements?

A. An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files

Highly voted

B. An orcl TNS entry must be defined in the client-side tnsnames.ora file

Highly voted

C. A service name must be defined to the listener that matches the service name in the orcl TNS entry

Highly voted

D. An orcl TNS entry must be defined in the server-side tnsnames.ora file

Highly voted

E. The service name orcl must be defined to the listener

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_062

Exam contains 381 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us