Tag Archives: user

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION

In one of your databases, you create a user, HR, and then execute this command:GRANT CREATE SESSION TO hr WITH ADMIN OPTION;Which three actions can HR perform? (Choose three.) A. Revoke the CREATE SESSION privilege from other users B. Revoke the CREATE SESSION privilege from user HR C. Log in to the database instance D. Grant the CREATE… Read More »

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must be the value of the SERVICE_NAMES parameter on the client side B. It must be… Read More »

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.Each database has a tnsnames.ora file defining DALLAS_DB as a service name.Examine this command:CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB? A.… Read More »

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.U1 executes this command:SQL> CREATE TABLE t1 AS(SELECT object_name, sharing, createdFROM dba_objects);U1 complains that the command is taking too long to execute.In the alert log, the database administrator (DBA) finds this:2017/3/6 14:45:17statement in resumable session ‘User U1(136), Session… Read More »

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance

In one of your databases, the user HR has the password HRMGR.You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file B. It must resolve to… Read More »

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.U1 executes this command:SQL> CREATE TABLE t1 AS(SELECT object_name, sharing, createdFROM dba_objects);U1 complains that the command is taking too long to execute.In the alert log, the database administrator (DBA) finds this:2017-03-06T12:15:17.183438+05:30statement in resumable session ‘User U1(136), Session 1,… Read More »

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance

In one of your databases, the user HR has the password HRMGR.You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must resolve to a valid connect descriptor in the client’s tnsnames.ora file B. It must be the… Read More »

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION

In one of your databases, you create a user, HR, and then execute this command:GRANT CREATE SESSION TO hr WITH ADMIN OPTION;Which three actions can HR perform? (Choose three.) A. Revoke the CREATE SESSION privilege from other users B. Revoke the CREATE SESSION privilege from user HR C. Log in to the database instance D. Grant the CREATE… Read More »

A user complains about poor database performance. You suspect that the user's session is waiting for

A user complains about poor database performance. You suspect that the user’s session is waiting for an event to complete.You want to verify this.Which two views may reveal for what the user’s session is currently waiting? (Choose two.) A. V$SYSTEM_EVENT B. V$SESSION C. V$SESSION_WAIT D. V$SESSION_EVENT E. V$SESSION_WAIT_CLASS Correct Answer: C,D

A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database,

A script abc.sql must be executed to perform a job.A database user HR, who is defined in this database, executes this command:$ sqlplus hr/[email protected] @abc.sqlWhat will happen upon execution? A. The command succeeds and HR will be connected to the orcl and abc.sql databases B. The command fails and reports an error because @ is used twice C.… Read More »