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（）A1 and 3B2，3，and 5C1，2，and 3D2，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?（）ALibrary cache BRow cache CSession UGA DBuffer 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?（）ASYSTEM BOUTLN CINTERNAL DSYS
多选题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?（）AThe file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.BThe file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.CThe file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.DThe 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?（）AUSER_TAB_PRIVS_MADEBUSER_TAB_PRIVSCUSER_COL_PRIVS_MADEDUSER_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？（）AIt updates the control file with the new location of the data file. BIt updates only the data dictionary with the new location of the data file. CIt changes the location of the user_data01.dbf file in the operating system. DIt 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？（）AV$DATAFILEBV$DATAFILE_HEADERCDBA_DATA_FILESDV$DBFILEEV$DATAFILE_ERRORS
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）AV$DATABASE BDBA_TABLES CSYSAUD$ DEMP
单选题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?（）AUse the DESCRIBE command on the EMP_DEPT_VU view.BUse the DEFINE VIEW command on the EMP_DEPT_VU view.CUse the DESCRIBE VIEW command on the EMP_DEPT_VU view.DQuery the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.EQuery the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.FQuery 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？（）ARepair damaged data dictionary entries.BDelete data dictionary information about database objects you no longer need.CExtract data definition commands from the data dictionary in a variety of formats.DPrepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator