1Z0-514 試験問題を無料オンラインアクセス

Your database instance in running.db01 is a net service name. You issue a connection request using the following command:
SQL> CONNECT scott/tiger@db01
Which component receives the request and establishes the appropriate connection?

• A.server process
• B.user process
• C.listener
• D.service name

There are two listeners, LISTENER1 and LISTENER2, and one service name ORCL available for your database.The database is running and currently only LISTENERI has been started. You issue the following command:
$lsnrctl start listener2
What would be the outcome?

• A.It would give an error because multiple listeners cannot run simultaneously.
• B.It would start the second listener and terminate all the current sessions.
• C.It would start the second listener without affecting the current sessions.
• D.It would give an error because multiple listeners can run simultaneously only if there are multiple net service names.

Which statement is true regarding the OracleUniversal Installer (OUI)?

• A.OUI supports the installation of several active Oracle homes on the same host.
• B.OUIenables configuring of listener as part of the installation process but not the creation of Net
• C.Operating system environment variables need to be set before running the OUI.
• D.OUI can be usedto uninstall only the complete Oracle software and not specific products.

Choose three areas for which Oracle Database 11g Release 2 and Enterprise Manager offer tools that can recommended solutions on optimal implementation.

• A.CPU usage
• B.Indexes
• C.Data block size
• D.Data recovery
• E.Compression
• F.Availability

Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)

• A.SQLTuning Advisor considers the impact of new indexes on both queries and DML operations.
• B.SQLTuning Advisor considers the impact of the indexes on only data manipulation language(DML) operations.
• C.SQLTuning Advisor considers the impact of the newindexeson both queries and DML operations.
• D.SQLTuning Advisor considers the impact of the indexes only queries.