User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第1题:
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()
第2题:
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()
第3题:
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
第4题:
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()
第5题:
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session()
第6题:
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command: SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION; The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim; Now, the user HR decides to revoke privileges from JIM using this command: SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim; Which statement is true after HR issues the REVOKE command()
第7题:
REVOKE ACCESS ON DATABASE FROM USER bob
REVOKE CONNECT ON DATABASE FROM USER tom
REVOKE tom FROM ACCESS ON DATABASE BY USER bob
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
第8题:
The query starts under the CLERKS group and the user, SCOTT, switches back to the MANAGERS group after the query completes.
The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
The query starts under the MANAGERS group, the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes, and then switches back to the MANAGERS group after the query completes.
第9题:
all sessions of the HR user only
all sessions of the HR user and the SYS user
the session of the HR user that executed the commands
all the sessions for which the database users have access privilege to the PERSONS table
第10题:
The command fails because SCOTT still has privileges.
The command succeeds and privileges are revoked from JIM.
The command fails because HR cannot revoke the privileges from JIM.
The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.
第11题:
LOCK TABLE emp IN SHARE MODE;
LOCK TABLE emp IN EXCLUSIVE MODE;
DELETE FROM emp WHERE job=’MANAGER’;
INSERT INTO emp(empno,ename) VALUES (1289,’Dick’);
SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
第12题:
User user = // retrieve the User object from the database session.setDurationInterval(user.getSessionDuration());
User user = // retrieve the User object from the database session.setMaxDuration(user.getSessionDuration());
User user = // retrieve the User object from the database session.setInactiveInterval(user.getSessionDuration());
User user=//retrieve the User object from the database session.setDuration(user.getSessionDuratio());
User user = // retrieve the User object from the database session.setMaxInactiveInterval(user.getSessionDuration());
第13题:
All the database users are presently connected to the database instance and working. The HR userhas opened 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 seethe effect of the UPDATE and DELETE commands ()
第14题:
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()
第15题:
You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement: SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (PLAN => ’SALES_PLAN’, GROUP_OR_SUBPLAN => ’MANAGERS’, CPU_P1 => 100, CPU_P2 =>0, SWITCH_GROUP => ’CLERKS’, SWITCH_TIME_IN_CALL => 600); A user, SCOTT, who is assigned to the MANAGERS group, starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete?()
第16题:
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()
第17题:
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command: SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()
第18题:
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command: SQL> SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()
第19题:
Alice only
Alice and Reena
Alice, Reena, and Timber
Sue, Alice, Reena, and Timber
第20题:
All sessions of the HR user only
All sessions of the HR user and the SYS user
The session of the HR user that executed the commands
All the sessions for which the database users have access privilege to the PERSONS table
第21题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第22题:
It would return information regarding only the last committed transaction.
It would return only the active transactions in all the undo segments in the database.
It would return only the committed transactions in all the undo segments in the database.
It would return both active and committed transactions in all the undo segments in the database.
It would return information regarding the transactions that began and were committed in the last 30 minutes.
第23题:
LOCK TABLE emp IN SHARE MODE;
LOCK TABLE emp IN EXCLUSIVE MODE;
UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?
INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);
SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno