网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “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” 相关考题
考题
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 tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.
考题
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.
考题
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
考题
A data ( ) is a file that contains metadata - that is, data about data. A .structure
B .table
C .base
D .dictionary
考题
_____ is a file that contains metadata-that is, data about data.
A.Document
B.Excel table]
C.Database]
D.Data dictionary
考题
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 clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
考题
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 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.
考题
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.
考题
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.
考题
Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）A、V$DATAFILEB、V$DATAFILE_HEADERC、DBA_DATA_FILESD、V$DBFILEE、V$DATAFILE_ERRORS
考题
You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A、 creating a table in your schema and you exceed your allocated space quota on the tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
考题
You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based？（）A、 column sizesB、 column data typesC、 PCTFREED、 projected number of rowE、 PCTUSED
考题
Note the points about data dictionary views and dynamic performance views： 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 5.V$FIXED_TABLE view can be queried to list the names of these views. Which statements listed describe the data dictionary views（）A、1 and 3B、2，3，and 5C、1，2，and 3D、2，3，4，and 5
考题
单选题Note the points about data dictionary views and dynamic performance views： 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 5.V$FIXED_TABLE view can be queried to list the names of these views. Which statements listed describe the data dictionary views（）A
1 and 3B
2，3，and 5C
1，2，and 3D
2，3，4，and 5
考题
单选题Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.A
1 and 3B
2， 3， and 5C
1， 2， and 3D
2， 3， 4， and 5
考题
单选题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
考题
多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation（）ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
考题
单选题You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）A
a table name which has 100s of recordsB
a table name which has 10s of recordsC
a table name which has empty recordsD
a table name which has 1000s of recordsE
never use a table name
考题
单选题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 tableC
Truncate the table.D
Add a column to the table.E
Rename a column in the table.
考题
多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
考题
单选题You issued the following statement in your SQL*Plus session： SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）A
creating a table in your schema and you exceed your allocated space quota on the tablespaceB
executing a long query that involves a sort operation and the statement runs out of temporary spaceC
loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD
creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
考题
单选题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.
考题
单选题You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based？（）A
column sizesB
column data typesC
PCTFREED
projected number of rowE
PCTUSED
考题
多选题Which three are true?（）AA MERGE statement is used to merge the data of one table with data from another.BA MERGE statement replaces the data of one table with that of another.CA MERGE statement can be used to insert new rows into a table.DA MERGE statement can be used to update existing rows in a table.
考题
单选题Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）A
V$DATAFILEB
V$DATAFILE_HEADERC
DBA_DATA_FILESD
V$DBFILEE
V$DATAFILE_ERRORS
考题
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）A
V$DATABASE B
DBA_TABLES C
SYSAUD$ D
EMP
考题
单选题You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）A
DROP TABLE B
ALTER TABLE C
RESIZE D
COALESCE
热门标签
最新试卷