网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which of the following database objects is considered executable using SQL?（）
A
View
B
Table
C
Routine
D
Package
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which of the following database objects is considered executable using SQL?（）A ViewB TableC RoutineD Package” 相关考题
考题
Which of the following risks are generally considered unpredictable:A business riskB financial riskC inflationD natural hazardsE taxes
考题
Before relativistic particle physics, the constituents of matter had always been considered as being either elementary units which were indestructible and unchangeable, or as composite objects which could be broken up into their constituent parts;
考题
You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?()
A. All the objects of scott are moved to the Recycle Bin.B. Any objects in the Recycle Bin belonging to scott are purged.C. All the objects owned by scott are permanently dropped from the database.D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
考题
Which of the following database objects can be used to raise an error if a table is updated?()
A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint
考题
On which of the following database objects may the SELECT privilege be controlled?()
A.SequenceB.SchemaC.GroupD.View
考题
Which of the following database objects is considered executable using SQL?()
A.ViewB.TableC.RoutineD.Package
考题
Which of the following describes the objects of a DB2 database and their relationships?()
A.InstanceB.Table spaceC.System catalogD.Schema repository
考题
Which of the following objects contains control structures that are considered the bound form of SQL statements?()
A.UDTB.TriggerC.PackageD.Access plan
考题
Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A、UDTB、TriggerC、PackageD、Access plan
考题
Which of the following are considered plug and play technologies in a laptop？（）A、SATAB、RAIDC、USBD、EIDE
考题
Which of the following database objects is considered executable using SQL?（）A、ViewB、TableC、RoutineD、Package
考题
On which of the following database objects may the SELECT privilege be controlled?（）A、SequenceB、SchemaC、GroupD、View
考题
Which of the following database objects can be used to raise an error if a table is updated?（）A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint
考题
An insurance provider maintains a claims database where claims adjusters are adding new claims and updating existing claims everyday. In the evening， a batch process is run to analyze data entered throughout the day. To reduce costs， a shared storage solution is being considered. Which of the following questions should the consultant ask to select the best performing storage configuration that meets their budget requirements？（）A、What database is being used？B、Which client operating systems will access the database？C、Which vendor’s Fibre Channel switch do they prefer？D、What volume of data is analyzed each evening？
考题
Which of the following are types of routine objects?（）A、Package and functionB、Function and userexitC、Procedure and packageD、Function and procedure
考题
A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）A、AliasB、ViewC、SchemaD、Trigger
考题
Which of the following statements are true regarding the Recycle Bin？（）A、 The Recycle Bin is a physical storage area for dropped objects.B、 The Recycle Bin is a logical container for dropped objects.C、 The Recycle Bin stores the results of a Flashback Drop operation.D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A、The value for MINEXTENTS setting B、The value for PCTINCREASE setting C、The value for MAXEXTENTS setting D、By default, Oracle allocates six extents to all database objects
考题
单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）A
Materialized views B
Indexes C
Index-organized tables D
Hash clusters
考题
单选题A trigger can be created on which of the following objects?（）A
ViewB
Catalog TableC
Stored ProcedureD
Global Temporary Table
考题
多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
考题
单选题When using a buoy as an aid to navigation which of the following should be considered?（）A
The buoy should be considered to always be in the charted locationB
If the light is flashing，the buoy should be considered to be in the charted locationC
The buoy may not be in the charted positionD
The buoy should be considered to be in the charted position if it has been freshly painted
考题
单选题A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A
The value for MINEXTENTS setting B
The value for PCTINCREASE setting C
The value for MAXEXTENTS setting D
By default, Oracle allocates six extents to all database objects
考题
单选题Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）A
IGNORE=YB
DIRECT=YC
CONSISTENT=YD
BUFFER=Y
考题
单选题You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）A
Clone B
Copy C
Template D
Terminal
考题
单选题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
考题
单选题To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）A
OPENB
MOUNTC
NOMOUNTD
CLOSE
热门标签
最新试卷
