granting SELECT privilege to SMITH on V$SESSION
granting SELECT privilege to SMITH on V_$SESSION
asking the user SMITH to run the catalog.sql script
granting SELECT privilege to SMITH on V$FIXED_TABLES
setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
第1题:
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?()
A.A
B.B
C.C
D.D
E.E
第2题:
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?()
第3题:
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?()
第4题:
Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL> DROP TABLE emp; Table dropped. What happens in this scenario? ()
第5题:
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()
第6题:
In what view are you likely to see the following output?() SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup & recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
第7题:
Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *ERROR at line 1:ORA-00942: table or view does not exist Client B needs the dropped table and reports the problem to you.With reference to this scenario, which action should you take?()
第8题:
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?()
第9题:
V$SESSION_EVENT
V$SESSION
V$WAITS
V$WAITSTAT
V$SYSSTAT
第10题:
The table is moved to the SYSAUX tablespace.
The table is moved to the SYSTEM tablespace.
The table is removed from the database permanently.
The table is renamed and remains in the TBSFD tablespace.
第11题:
GRANT SELECT ANY TRANSACTION TO ARREN
GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN
GRANT SELECT_ANY_TRANSACTION TO ARREN
GRANT FLASHBACK TO ARREN
GRANT SELECT ANY VIEW TO ARREN
第12题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第13题:
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?()
第14题:
Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord * ERROR at line 1: ORA/x7f00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()
第15题:
The HR user creates a view with this command: SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp; Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario?()
第16题:
You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()
第17题:
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()
第18题:
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()
第19题:
当需要返回当前用户的名字,可以执行如下()SQL语句。
第20题:
TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal?()
第21题:
In SQL Server Management Studio, open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.
In SQL Server Management Studio,open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.
In SQL Server Management Studio, open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.
In SQL Server Management Studio, open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.
第22题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第23题:
granting SELECT privilege to SMITH on V$SESSION
granting SELECT privilege to SMITH on V_$SESSION
asking the user SMITH to run the catalog.sql script
granting SELECT privilege to SMITH on V$FIXED_TABLES
setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
第24题:
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;