单选题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 =

题目

单选题

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 = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）

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题：

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()

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;

参考答案：D

第2题：

SQL是 ______的缩写。

A．Standard Query Language

B．Structured Query Language

C．Select Query Language

D．以上都不是

正确答案：B
解析：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?（）

参考答案：B

第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

参考答案：B

第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)

参考答案：B

第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

A user named Arren is executing this query： select table_n

题目

相似问题和答案

更多相关问题

相关内容