网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which of the following database objects can be used to raise an error if a table is updated?（）
- A、Package
- B、Trigger
- C、Stored Procedure
- D、Informational Constraint
参考答案
更多 “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” 相关考题
考题
Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()
A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
考题
Which of the following utilities can be used to list the routing table?()
A.ipconficjB.nslookupC.netstatD.dig
考题
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()
A.UniqueB.CheckC.ReferentialD.Informational
考题
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
考题
Which of the following describes the objects of a DB2 database and their relationships?()
A.InstanceB.Table spaceC.System catalogD.Schema repository
考题
A trigger can be created on which of the following objects?()
A.ViewB.Catalog TableC.Stored ProcedureD.Global Temporary Table
考题
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()
A.Define the column MAINID as NOT UPDATABLEB.Define the column MAINID as a PRIMARY KEYC.Define the column MAINID as a FOREIGN KEYD.Define an UPDATE trigger on table TABLEX
考题
What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?()
A.CheckB.RangeC.ReferentialD.Informational
考题
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 constraint types can be used to ensure the value of an INTEGER column references only positive values?（）A、UniqueB、CheckC、ReferentialD、Informational
考题
A trigger can be created on which of the following objects?（）A、ViewB、Catalog TableC、Stored ProcedureD、Global Temporary Table
考题
What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?（）A、CheckB、RangeC、ReferentialD、Informational
考题
Which of the following are valid program types for a lightweight job？（）A、 PLSQL_BLOCKB、 EXECUTABLEC、 JAVA_STORED_PROCEDURED、 STORED_PROCEDUREE、 EXTERNAL
考题
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
考题
Which of the following are valid program types for a lightweight job?（）A、PLSQL_BLOCK PLSQLB、EXECUTABLEC、JAVA_STORED_PROCEDURED、STORED_PROCEDUREE、EXTERNAL
考题
Which of the following utilities can be used to list the routing table?（）A、ipconficjB、nslookupC、netstatD、dig
考题
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）A、Define the column MAINID as NOT UPDATABLEB、Define the column MAINID as a PRIMARY KEYC、Define the column MAINID as a FOREIGN KEYD、Define an UPDATE trigger on table TABLEX
考题
Which of the following describes the objects of a DB2 database and their relationships?（）A、InstanceB、Table spaceC、System catalogD、Schema repository
考题
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
考题
Identify two situations in which the alert log file is updated.（）A、Running a query on a table returns ORA-600: Internal Error.B、Inserting a value into a table returns ORA-01722: invalid number.C、Creating a table returns ORA-00955: name us already in used by an existing objects.D、Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.E、Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
考题
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL *Loader.D、New data conforms to the constraint， but existing data is not checked.E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）A
UniqueB
CheckC
ReferentialD
Informational
考题
单选题A trigger can be created on which of the following objects?（）A
ViewB
Catalog TableC
Stored ProcedureD
Global Temporary Table
考题
多选题Identify the two situations in which the alert log file is updated with details. （）ARunning a query on a table returns ORA-600： Internal Error.BInserting a value in a table returns ORA-01722： invalid number.CCreating a table returns ORA-00955： name is already used by an existing object.DInserting a value in a table returns ORA-00001： unique constraint （SYS.PK_TECHP） violated.ERebuilding an index using ALTER INDEX ...REBUILD fails with an error ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.
考题
单选题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
热门标签
最新试卷