单选题Which of the following database objects is considered executable using SQL?()AViewBTableCRoutineDPackage

单选题
Which of the following database objects is considered executable using SQL?()
A

View

B

Table

C

Routine

D

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?()AMaterialized views BIndexes CIndex-organized tables DHash clusters

单选题A trigger can be created on which of the following objects?()AViewBCatalog TableCStored ProcedureDGlobal 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?()AThe buoy should be considered to always be in the charted locationBIf the light is flashing,the buoy should be considered to be in the charted locationCThe buoy may not be in the charted positionDThe 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?()AThe value for MINEXTENTS setting BThe value for PCTINCREASE setting CThe value for MAXEXTENTS setting DBy default, Oracle allocates six extents to all database objects

多选题Which of the following would be considered a routing protocol?()AOSPFBDHCPCSMTPDSNMPERIP

单选题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?()AIGNORE=YBDIRECT=YCCONSISTENT=YDBUFFER=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? ()AClone BCopy CTemplate DTerminal

单选题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

单选题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?()AOPENBMOUNTCNOMOUNTDCLOSE