Oracle认证考试

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 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
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

_____ is a file that contains metadata-that is, data about data.

A.Document
B.Excel table]
C.Database]
D.Data dictionary

答案：D
解析：
数据字典是一个包含元数据(即关于数据的数据)的文件。

第3题：

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()

A. Drop the table.

B. Partition the table

C. Truncate the table.

D. Add a column to the table.

E. Rename a column in the table.


参考答案：D

第4题：

Which three are true?（）

  • A、A MERGE statement is used to merge the data of one table with data from another.
  • B、A MERGE statement replaces the data of one table with that of another.
  • C、A MERGE statement can be used to insert new rows into a table.
  • D、A MERGE statement can be used to update existing rows in a table.

正确答案:A,C,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题：

A data ( ) is a file that contains metadata - that is, data about data.

A .structure
B .table
C .base
D .dictionary

答案：D
解析：
数据字典就是包含元数据的文件，即关于数据的数据。

第7题：

In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）

  • A、if a table is not in a cluster
  • B、if a table has an active trigger
  • C、if a table has an encrypted
  • D、if a table has a column of data type LONG defined on it
  • E、if a table has a referential integrity constraint defined on it

正确答案:B,C,E

第8题：

You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()

A. The statistics are stored in the pending statistics table in the data dictionary.

B. The statistics are treated as the current statistics by the optimizer for all sessions.

C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.


参考答案：A

第9题：

Which action(s) will cause a compression dictionary to be removed from a table?（）

  • A、Set the table COMPRESS attribute to NO.  
  • B、Set the table COMPRESS attribute to NO; run REORG against the table.  
  • C、Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.  
  • D、Set the table COMPRESS attribute to NO; run RUNSTATS against the table.

正确答案:B

第10题：

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

  • A、 Drop the table.
  • B、 Partition the table.
  • C、 Truncate the table.
  • D、 Add a column to the table.
  • E、 Rename a column in the table.

正确答案:D

更多相关问题
相关内容