CMS专题
单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid =
题目
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
参考答案和解析
相似问题和答案
第1题：
A. GRANT select ON dept TO ALL_ USER;
B. GRANT select ON dept TO ALL;
C. GRANT QUERY ON dept TO ALL_USERS
D. GRANT select ON dept TO PUBLIC;
第2题：
SQL是 ______的缩写。
A．Standard Query Language
B．Structured Query Language
C．Select Query Language
D．以上都不是
解析：SQL是结构化查询语言Structured Query Language的缩写。
第3题：
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）
A.
B.
C.
D.
第4题：
A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）
- A、increase the size of redo log files
- B、increase the size of the undo tablespace
- C、increase the size of the Database Buffer Cache
- D、increase the size of the default temporary tablespace
- E、enable the retention guarantee for the undo tablespace
正确答案:B,E
第5题：
SQL是那几个英文单词的缩写（）
- A、Standard Query Language
- B、Structured Query Language
- C、Select Query Language
- D、以上都不是
正确答案:B
第6题：
Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）
A. Rollback segment
B. Temporary segment
C. Data segment
D. Index segment
第7题：
以下哪一个语句是正确的SQL语句（）
- A、select*fromuser_name
- B、show*user_name
- C、ls*fromuser_name
- D、display*user_name
正确答案:A
第8题：
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?（）
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
第9题：
SQL是（）英文单词的缩写。
- A、Structured Query Language
- B、Standard Query Language
- C、Select Query Language
- D、以上都不是
正确答案:A
第10题：
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
正确答案:B,F