A user executes a query on the EMPtable, which contains thou

题目
单选题
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.

参考答案和解析
正确答案: D
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()

A. USER_CONSTRAINTS

B. USER_OBJECTS

C. ALL_CONSTRAINTS

D. USER_CONS_COLUMNS

E. USER_COLUMNS


参考答案:D

第2题:

Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()

A. USER_TAB_PRIVS_MADE

B. USER_TAB_PRIVS

C. USER_COL_PRIVS_MADE

D. USER_COL_PRIVS


参考答案:D

第3题:

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.


参考答案:D

第4题:

Which best describes an inline view? ()

  • A、a schema object
  • B、a subquery that can contain an ORDER BY clause
  • C、another name for a view that contains group functions
  • D、a subquery that is part of the FROM clause of another query

正确答案:D

第5题:

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?()

  • A、USER_TAB_PRIVS_MADE
  • B、USER_TAB_PRIVS
  • C、USER_COL_PRIVS_MADE
  • D、USER_COL_PRIVS

正确答案:D

第6题:

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

第7题:

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 tool
  • B、the Export-CSV cmdlet
  • C、the Get-ADUser cmdlet
  • D、the Net.exe user command

正确答案:C

第8题:

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 creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D.


参考答案:B, C

第9题:

Which view should a user query to display the columns associated with the constraints on a table owned by the user?()

  • A、USER_CONSTRAINTS
  • B、USER_OBJECTS
  • C、ALL_CONSTRAINTS
  • D、USER_CONS_COLUMNS
  • E、USER_COLUMNS

正确答案:D

第10题:

Which of the following contains the user profile directory for Microsoft Windows 2000 and XP?()

  • A、Users
  • B、My Documents
  • C、Documents and Settings
  • D、Application Data

正确答案:C

更多相关问题