单选题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？（）A The tempfile belonging to the default temporary tablespace is missing.B The database is opened in restricted mode， so queries are not allowedC The default temporary tablespace required to execute the query is offline.D The default temporary tablespace required to execute the query is dropped.E The default temporary tablespace required to execute the query is read-only.
单选题
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？（）
A
The tempfile belonging to the default temporary tablespace is missing.
B
The database is opened in restricted mode， so queries are not allowed
C
The default temporary tablespace required to execute the query is offline.
D
The default temporary tablespace required to execute the query is dropped.
E
The default temporary tablespace required to execute the query is read-only.
参考解析
解析：
暂无解析
相关考题：
You use Microsoft .NET Framework 4 to create a Windows Forms client application.You write the following code segment.The application contains a form of type Form1 that contains a FormSettings object named frmSettings1.You need to maintain the user‘s form size preference each time the user executes the application.Which code segment should you use? （）A.B.C.D.
The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?() A. The job is enabled by default after creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD.
Which view should a user query to display the columns associated with the constraints on a table owned by the user? () A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS
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_USERSD. GRANT select ON dept TO PUBLIC;
Which data dictionary table should you query to view the object privileges granted to the user on specific columns? () A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS
Your network contains an Active Directory forest. The forest schema contains a custom attribute for user objects. You need to give the human resources department a file that contains the last logon time and the custom attribute values for each user in the forest. Which should you use（）A、the Dsquery toolB、the Export-CSV cmdletC、the Get-ADUser cmdletD、the Net.exe user command
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）A、USER_TAB_PRIVS_MADEB、USER_TAB_PRIVSC、USER_COL_PRIVS_MADED、USER_COL_PRIVS
Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）A、USER_CONSTRAINTSB、USER_OBJECTSC、ALL_CONSTRAINTSD、USER_CONS_COLUMNSE、USER_COLUMNS
Which best describes an inline view? （）A、a schema objectB、a subquery that can contain an ORDER BY clauseC、another name for a view that contains group functionsD、a subquery that is part of the FROM clause of another query
Which of the following contains the user profile directory for Microsoft Windows 2000 and XP?（）A、UsersB、My DocumentsC、Documents and SettingsD、Application Data
Which of the following logs contains information on overall performance and events not related to user authentication?（）A、SecurityB、AuditC、ApplicationD、System
A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）A、20B、25C、50D、55
You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）A、The main query executes with the first value returned by the subquery.B、The main query executes with the last value returned by the subquery.C、The main query executes with all the values returned by the subquery.D、The main query fails because the multiple-row subquery cannot be used with the comparison operator.E、You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
Your network contains an Active Directory forest. The forest schema contains a custom attribute for user objects. You need to modify the custom attribute value of 500 user accounts. Which tool should you use（）A、CsvdeB、DsmodC、DsrmD、Ldifde
单选题To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it.
单选题Your network contains an Active Directory forest. The forest schema contains a custom attribute for user objects. You need to give the human resources department a file that contains the last logon time and the custom attribute values for each user in the forest. Which should you use（）Athe Dsquery toolBthe Export-CSV cmdletCthe Get-ADUser cmdletDthe Net.exe user command
多选题Which two statements are true regarding the execution of the correlated subqueries？（）AThe nested query executes after the outer query returns the row.BThe nested query executes first and then the outer query executes.CThe outer query executes only once for the result returned by the inner query.DEach row returned by the outer query is evaluated for the results returned by the inner query.
单选题Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）AEXECUTE_CATALOG_ROLEBCONNECTCRESOURCEDRECOVERY_CATALOG_OWNERERECOVERY_CATALOG_USER
单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it
单选题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？（）AThe tempfile belonging to the default temporary tablespace is missing.BThe database is opened in restricted mode， so queries are not allowed.CThe default temporary tablespace required to execute the query is offline.DThe default temporary tablespace required to execute the query is dropped.EThe default temporary tablespace required to execute the query is readonly.
单选题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： SQLEXEC 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？（）A The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C 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.D 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.
单选题You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）AThe main query executes with the first value returned by the subquery.BThe main query executes with the last value returned by the subquery.CThe main query executes with all the values returned by the subquery.DThe main query fails because the multiple-row subquery cannot be used with the comparison operator.EYou cannot define a multiple-row subquery in the WHERE clause of a SQL query.
单选题Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）AUSER_CONSTRAINTSBUSER_OBJECTSCALL_CONSTRAINTSDUSER_CONS_COLUMNSEUSER_COLUMNS
单选题The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）AGRANT select ON dept TO ALL_ USER;BGRANT select ON dept TO ALL;CGRANT QUERY ON dept TO ALL_USERSDGRANT select ON dept TO PUBLIC;