网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Data Dictionary表示（）。
A
数据字典
B
协议
C
决策树
D
OSPI协议
参考答案
参考解析
解析：
暂无解析
更多 “单选题Data Dictionary表示（）。A 数据字典B 协议C 决策树D OSPI协议” 相关考题
考题
●( 72) is a file that contains metadata-that is, data about data.●(72) A. documentB. Excel tableC. databaseD. data dictionary
考题
Which two statements about the SQL Management Base (SMB) are true?()
A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
考题
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．structureB．tableC．baseD．dictionary
考题
A （72） is a file that contains metadata—that is,data about data.A.documentB.Excel tableC. databaseD.data dictionary
考题
●A (72) is a file that contains metadata—that is，data about data.(72)A．documentB．Excel tableC. databaseD．data dictionary
考题
A data ( ) is a file that contains metadata - that is, data about data. A .structure
B .table
C .base
D .dictionary
考题
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 need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.A、large poolB、shared poolC、data buffer cacheD、redo log bufferE、data dictionary cache
考题
Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR？（）A、 All objects in the databaseB、 Tables owned by SYS and SYSTEMC、 Data dictionary tablesD、 NCHAR columnsE、 CHAR columns
考题
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
考题
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 two statements about the SQL Management Base (SMB) are true?（）AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
考题
单选题Records from the data dictionary information are stored in which of the following database memory areas?（）A
Library cache B
Row cache C
Session UGA D
Buffer cache
考题
单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）A
SYSTEM B
OUTLN C
INTERNAL D
SYS
考题
多选题Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
考题
单选题Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR？（）A
All objects in the databaseB
Tables owned by SYS and SYSTEMC
Data dictionary tablesD
NCHAR columnsE
CHAR columns
考题
单选题You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）A
The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.B
The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.C
The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.D
The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.
考题
单选题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 issue this SQL statement： ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’； What does this SQL statement do？（）A
It updates the control file with the new location of the data file. B
It updates only the data dictionary with the new location of the data file. C
It changes the location of the user_data01.dbf file in the operating system. D
It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.
考题
单选题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 need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）A
Use the DESCRIBE command on the EMP_DEPT_VU view.B
Use the DEFINE VIEW command on the EMP_DEPT_VU view.C
Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.D
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
单选题What does the Metadata Application Programming Interface （API） allow you to do？（）A
Repair damaged data dictionary entries.B
Delete data dictionary information about database objects you no longer need.C
Extract data definition commands from the data dictionary in a variety of formats.D
Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator
热门标签
最新试卷