itgle.com

单选题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 database objects can be used to raise an error if a table is updated?（）
A

Package

B

Trigger

C

Stored Procedure

D

Informational Constraint

相似考题

1.Which of the following utilities can be used to list the routing table?()A.ipconficjB.nslookupC.netstatD.dig

2.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

3.Which of the following describes the objects of a DB2 database and their relationships?()A.InstanceB.Table spaceC.System catalogD.Schema repository

4.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”相关问题

  • 第1题：

    A trigger can be created on which of the following objects?()

    A.View

    B.Catalog Table

    C.Stored Procedure

    D.Global Temporary Table


    参考答案：A

  • 第2题：

    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.Check

    B.Range

    C.Referential

    D.Informational


    参考答案：A

  • 第3题：

    Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）

    • A、Unique
    • B、Check
    • C、Referential
    • D、Informational

    正确答案:B

  • 第4题：

    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、Check
    • B、Range
    • C、Referential
    • D、Informational

    正确答案:A

  • 第5题：

    Which of the following are valid program types for a lightweight job?（）

    • A、PLSQL_BLOCK PLSQL
    • B、EXECUTABLE
    • C、JAVA_STORED_PROCEDURE
    • D、STORED_PROCEDURE
    • E、EXTERNAL

    正确答案:A,D

  • 第6题：

    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

    正确答案:B

  • 第7题：

    Which of the following describes the objects of a DB2 database and their relationships?（）

    • A、Instance
    • B、Table space
    • C、System catalog
    • D、Schema repository

    正确答案:C

  • 第8题：

    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.

    正确答案:A,E

  • 第9题：

    单选题
    Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）
    A

    Unique

    B

    Check

    C

    Referential

    D

    Informational


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    Which of the following utilities can be used to list the routing table?（）
    A

    ipconficj

    B

    nslookup

    C

    netstat

    D

    dig


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    A technician installs a new sound card but no sound can be heard. Which of the following utilities can be used to see an error?（）
    A

    MSCONFIG

    B

    Device Manager

    C

    DXDIAG

    D

    REGEDIT


    正确答案： C
    解析： 暂无解析

  • 第12题：

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

    B

    Define the column MAINID as a PRIMARY KEY

    C

    Define the column MAINID as a FOREIGN KEY

    D

    Define an UPDATE trigger on table TABLEX


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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 UPDATABLE

    B.Define the column MAINID as a PRIMARY KEY

    C.Define the column MAINID as a FOREIGN KEY

    D.Define an UPDATE trigger on table TABLEX


    参考答案：D

  • 第14题：

    Which of the following objects contains control structures that are considered the bound form of SQL statements?（）

    • A、UDT
    • B、Trigger
    • C、Package
    • D、Access plan

    正确答案:C

  • 第15题：

    A trigger can be created on which of the following objects?（）

    • A、View
    • B、Catalog Table
    • C、Stored Procedure
    • D、Global Temporary Table

    正确答案:A

  • 第16题：

    Which of the following are valid program types for a lightweight job？（）

    • A、 PLSQL_BLOCK
    • B、 EXECUTABLE
    • C、 JAVA_STORED_PROCEDURE
    • D、 STORED_PROCEDURE
    • E、 EXTERNAL

    正确答案:A,D

  • 第17题：

    Which of the following utilities can be used to list the routing table?（）

    • A、ipconficj
    • B、nslookup
    • C、netstat
    • D、dig

    正确答案:C

  • 第18题：

    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 UPDATABLE
    • B、Define the column MAINID as a PRIMARY KEY
    • C、Define the column MAINID as a FOREIGN KEY
    • D、Define an UPDATE trigger on table TABLEX

    正确答案:D

  • 第19题：

    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、Alias
    • B、View
    • C、Schema
    • D、Trigger

    正确答案:B

  • 第20题：

    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 checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第21题：

    单选题
    A trigger can be created on which of the following objects?（）
    A

    View

    B

    Catalog Table

    C

    Stored Procedure

    D

    Global Temporary Table


    正确答案： B
    解析： 暂无解析

  • 第22题：

    多选题
    Identify the two situations in which the alert log file is updated with details. （）
    A

    Running a query on a table returns ORA-600： Internal Error.

    B

    Inserting a value in a table returns ORA-01722： invalid number.

    C

    Creating a table returns ORA-00955： name is already used by an existing object.

    D

    Inserting a value in a table returns ORA-00001： unique constraint （SYS.PK_TECHP） violated.

    E

    Rebuilding an index using ALTER INDEX ...REBUILD fails with an error ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.


    正确答案： B,C
    解析： 暂无解析

  • 第23题：

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

    Alias

    B

    View

    C

    Schema

    D

    Trigger


    正确答案： B
    解析： 暂无解析

相关内容