A.when multiple databases are to be registered with the listener
B.when DBAs need to connect remotely to start up the database instance
C.when users need to connect the database instance using the host naming method
D.when the database instance that is to be registered with the listener is configured in shared server mode
您可能感兴趣的试卷
你可能感兴趣的试题
View the Exhibit and examine the output.
Which two statements are true regarding the LISTENER2 listener（）
A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two.
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command：
LSNRCTL> STOP
What happens to the sessions that are presently connected to the database instance（）
A.The sessions are able to perform only queries.
B.The sessions are not affected and continue to function normally.
C.The sessions are terminated and the active transactions are rolled back.
D.The sessions are not allowed to perform any operations till the listener is started.
What could be the reason for this（）
A.The listener is not running on the database node.
B.The TNS_ADMIN environmental variable is set to a wrong value.
C.The orcl.oracle.com database service is not registered with the listener.
D.The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client
while connecting to the database instance from a remote machine（）
A.host naming method
B.local naming method
C.external naming method
D.directory naming method
A.Listeners use only the TCP/IP protocol.
B.Multiple listener processes can run simultaneously on a host.
C.Multiple database instances can be registered with a single listener.
D.The listener-related errors can be traced only at the administrative level.
E.Only one database instance can be registered with a single listener at any time.
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith
Connected.
SQL> SELECT * FROM v$session；
SELECT * FROM v$session *
ERROR at line 1：
ORA-00942： table or view does not exist
Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）
A.granting SELECT privilege to SMITH on V$SESSION
B.granting SELECT privilege to SMITH on V_$SESSION
C.asking the user SMITH to run the catalog.sql script
D.granting SELECT privilege to SMITH on V$FIXED_TABLES
E.setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
F.creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Note the points about data dictionary views and dynamic performance views：
1.These are stored in the SYSTEM tablespace.
2.These are the based on the virtual tables.
3.These are owned by the SYSuser.
4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE.
5.V$FIXED_TABLE view can be queried to list the names of these views.
Which statements listed describe the data dictionary views（）
A.1 and 3
B.2，3，and 5
C.1，2，and 3
D.2，3，4，and 5
A.Running a query on a table returns "ORA-600： Internal Error."
B.Inserting a value in a table returns "ORA-01722： invalid number."
C.Creating a table returns "ORA-00955： name is already used by an existing object."
D.Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E.Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.
A.Running a query on a table returns "ORA-600： Internal Error."
B.Inserting a value in a table returns "ORA-01722： invalid number."
C.Creating a table returns "ORA-00955： name is already used by an existing object."
D.Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E.Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."
You want to check the details of few errors that users have reported. You search for the alert log fileand execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed.
What is the location of the alert_orcl.log file（）
A.ORACLE_HOME/dbs
B.ORACLE_HOME/rdbms
C./u01/app/oracle/admin/orcl/adump
D./u01/app/oracle/flash_recovery_area
E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert
F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
最新试题
In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
Which statements are true regarding a tablespace（）
The user HR receives the following error while inserting data into the TTK table：ERROR at line 1：ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace.Which three action would allow the user to insert data（）
In a new installation of Oracle Database 11g， you perform these activities：1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed（）
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted.The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）
Identify the situations in which you use the alert log file in your database to check the detail.（）
You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE；Which statements describe the effect of the command（）
The database instance has the following parameter setting：OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）
Which statements are true about checkpointing（）
Which statements are true about logical structures of the Oracle database（）