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?()
The following query will provide what information about transportable tablespaces for the current database?() select d.platform_name "Source", t.platform_name "Compatible Targets", endian_format from v$transportable_platform t, v$database d where t.endian_format = (select endian_format from v$transportable_platform t, v$database d where d.platform_name = platform_name);
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?()
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()
A user executes a query on the EMPtable, which contains thousands of rows, to get details about employees in one of the departments. The user receives the following error: SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal ERROR at line 1: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201:’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason?()
Which of the following is a typical data warehouse query?()
At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group deleted?()
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?()
An administrator wants to query the CPU resources of the managed system 9117-MMA*6512345 from the Hardware Management Console (HMC) command line. Which of the following HMC commands could achieve this?()
A user executes a query on the EMP table, which contains thousands of rows, to get details about employees in one of the departments. The user receives the following error: SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1: ORA/x7f01157: cannot identify/lock data file 201 /x7f see DBWR trace file ORA/x7f01110: data file 201: ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason?()