网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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 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” 相关考题
考题
Oracle的Internet解决方案主要包括哪几部分工具?Ⅰ.Oracle Express ServerⅡ.Oracle Express ObjectsⅢ.Oracle Express AnalyzerⅣ.Oracle WebListenerⅤ.Oracle WebAgentⅥ.Oracle WebServerA.Ⅰ,Ⅴ和ⅥB.Ⅰ,Ⅱ和ⅢC.Ⅳ.Ⅴ和ⅥD.全部
考题
when you are reading an article, your purpose is to find the general idea of the article. then which reading strategy will you employ ()
A. SkimmingB. Identifying and understanding argumentC. Identifying attitudes and making inferencesD. Scanning
考题
-Shall I use your dictionary?- ________.A、Certain, you mayB、Of course, you can.C、Surely, you can'tD、No, please get out
考题
You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?()
A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.
考题
下列关于Oracle数据仓库的叙述中,哪条是不正确的?( )A) Oracle Express Server是服务器端的产品B) Oracle Express Objects和Oracle Express Analyzer是客户端的产品C) Oracle Express Analyzer是联机分析处理服务器D) Oracle Express Objects是可视化工具A.B.C.D.
考题
Oracle的数据仓库解决方案主要包括哪几部分工具?Ⅰ.Oracle Express ServerⅡ.Oracle Express ObjectsⅢ,Oracle Express AnalyzerⅣ.Oracle WebListenerⅤ.Oracle WebAgentⅥ.Oracle WebServerA.Ⅰ,Ⅴ和ⅥB.Ⅰ,Ⅱ和ⅢC.Ⅳ,Ⅴ和ⅥD.全部
考题
Do you think I could borrow your dictionary?()AYes, you may borrowBYes, you couldCYes, go onDYes, help yourself
考题
May I use your dictionary? ()A、Yes, here you areB、No, you won'tC、Never mindD、Sorry here it is
考题
If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?()A、 TS_OBJECTS_TO_BE_DROPPEDB、 TS_PTTR_OBJECT_DROPPEDC、 TS_PITR_OBJECTS_TO_BE_DROPPEDD、 TS_OBJECTS_DROPPEDE、 TS_DROPPED_OBJECTS
考题
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.
考题
You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()A、ownerB、touserC、includeD、schemasE、fromuserF、transformG、remap_schemaH、remap_datafileI、reuse_datafilesJ、remap_tablespace
考题
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 work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.
考题
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()A、Library cache B、Row cacheC、Dictionary cache D、Large area E、Buffer cache
考题
You need to recommend a strategy for managing Windows Firewall that meets the companys technical requirements. What should you include in the recommendation?()A、domain-based Group Policy objects (GPOs)B、local Group Policy objects (GPOs)C、Starter Group Policy objects (GPOs)D、System Starter Group Policy objects (GPOs)
考题
单选题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
考题
单选题If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?()A
TS_OBJECTS_TO_BE_DROPPEDB
TS_PTTR_OBJECT_DROPPEDC
TS_PITR_OBJECTS_TO_BE_DROPPEDD
TS_OBJECTS_DROPPEDE
TS_DROPPED_OBJECTS
考题
填空题If you have problems with the foreign language, you should take a bilingual dictionary along.____
考题
单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()A
DBA_USERS B
DBA_OBJECTS C
DBA_TS_QUOTAS D
DBA_TAB_PRIVS
考题
单选题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
考题
单选题Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance?()A
Java poolB
Large poolC
Shared poolD
Streams poolE
Library cacheF
Redo log bufferG
Data dictionary cacheH
Database buffer cache
考题
单选题You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()A
ownerB
touserC
includeD
schemasE
fromuserF
transformG
remap_schemaH
remap_datafileI
reuse_datafilesJ
remap_tablespace
考题
单选题You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A
The trace fileB
The fixed viewsC
The data dictionary viewsD
The operating system log fieldsE
The dynamic performance views.
考题
单选题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
考题
单选题To study a foreign language,()A
a good dictionary should be boughtB
buying a good dictionary is necessaryC
you should buy a good dictionaryD
it is necessary that you will buy a good dictionary
热门标签
最新试卷