单选题Which of the following resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space

题目
单选题
Which of the following resources can be referenced in the LOCK statement?（）
A

Row

B

Table

C

Column

D

Table space

相似考题

1.View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

2.Which two statements are true about InnoDB auto－increment locking?()A.The auto-increment lock can be a table-level lockB.InnoDB never uses table-level locksC.Some settings for innodb_autoinc_lock_mode can help reduce lockingD.InnoDB always protects auto-increment updates with a table-level lock

3.Which kind of non－sourced UDF can be created so that it only returns a single value?()A.RowB.TableC.ScalarD.Column

4.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题Which of the following resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space”相关问题

  • 第1题：

    Which of the following resources can be explicitly locked?()

    A.Row

    B.Page

    C.Table

    D.Column


    参考答案：C

  • 第2题：

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

    A.View

    B.Catalog Table

    C.Stored Procedure

    D.Global Temporary Table


    参考答案：A

  • 第3题：

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

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

    正确答案:A

  • 第4题：

    Which of the following resources can be referenced in the LOCK statement?（）

    • A、Row
    • B、Table
    • C、Column
    • D、Table space

    正确答案:B

  • 第5题：

    A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）

    • A、Sequence
    • B、Table Function
    • C、Identity Column
    • D、INSTEAD OF Trigger

    正确答案:A

  • 第6题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第7题：

    You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

    • A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
    • B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
    • C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
    • D、 You cannot shrink the SCOTT.EMP table.

    正确答案:D

  • 第8题：

    Which two statements are true about InnoDB auto-increment locking?（）

    • A、The auto-increment lock can be a table-level lock
    • B、InnoDB never uses table-level locks
    • C、Some settings for innodb_autoinc_lock_mode can help reduce locking
    • D、InnoDB always protects auto-increment updates with a table-level lock

    正确答案:A,C

  • 第9题：

    单选题
    To which of the following resources can a lock be applied?（）
    A

    Row

    B

    Alias

    C

    Bitmap

    D

    Column


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

  • 第10题：

    单选题
    You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）
    A

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.

    B

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.

    C

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.

    D

     You cannot shrink the SCOTT.EMP table.


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

  • 第11题：

    单选题
    Which statement is true regarding synonyms?（）
    A

    Synonyms can be created only for a table 

    B

    Synonyms are used to reference only those tables that are owned by another user 

    C

    A public synonym and a private synonym can exist with the same name for the same table 

    D

    The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid


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

  • 第12题：

    单选题
    Which of the following resources can be referenced in the LOCK statement?（）
    A

    Row

    B

    Table

    C

    Column

    D

    Table space


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

  • 第13题：

    In which of the following situations should correlation names be used?()

    A.A table referenced in the FROM clause has no indexed column.

    B.The table referenced in the FROM clause has more than 200 columns.

    C.Two or more tables in the FROM clause have identical column names.

    D.The FROM clause contains two or more tables in the SELECT statement.


    参考答案：C

  • 第14题：

    A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）

    A.Sequence

    B.Table Function

    C.Identity Column

    D.INSTEAD OF Trigger


    参考答案：A

  • 第15题：

    In which of the following situations should correlation names be used?（）

    • A、A table referenced in the FROM clause has no indexed column.
    • B、The table referenced in the FROM clause has more than 200 columns.
    • C、Two or more tables in the FROM clause have identical column names.
    • D、The FROM clause contains two or more tables in the SELECT statement.

    正确答案:C

  • 第16题：

    Which of the following resources can be explicitly locked?（）

    • A、Row
    • B、Page
    • C、Table
    • D、Column

    正确答案:C

  • 第17题：

    To which of the following resources can a lock be applied?（）

    • A、Row
    • B、Alias
    • C、Bitmap
    • D、Column

    正确答案:A

  • 第18题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,F

  • 第19题：

    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

    • A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
    • B、 executing a long query that involves a sort operation and the statement runs out of temporary space
    • C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
    • D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

    正确答案:D

  • 第20题：

    单选题
    A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）
    A

    Sequence

    B

    Table Function

    C

    Identity Column

    D

    INSTEAD OF Trigger


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

  • 第21题：

    单选题
    Which of the following resources can be explicitly locked?（）
    A

    Row

    B

    Page

    C

    Table

    D

    Column


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

  • 第22题：

    多选题
    Which three are true? （）
    A

    A MERGE statement is used to merge the data of one table with data from another.

    B

    A MERGE statement replaces the data of one table with that of another.

    C

    A MERGE statement can be used to insert new rows into a table.

    D

    A MERGE statement can be used to update existing rows in a table.


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

  • 第23题：

    单选题
    In which of the following situations should correlation names be used?（）
    A

    A table referenced in the FROM clause has no indexed column.

    B

    The table referenced in the FROM clause has more than 200 columns.

    C

    Two or more tables in the FROM clause have identical column names.

    D

    The FROM clause contains two or more tables in the SELECT statement.


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

  • 第24题：

    单选题
    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
    A

     creating a table in your schema and you exceed your allocated space quota on the tablespace

    B

     executing a long query that involves a sort operation and the statement runs out of temporary space

    C

     loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

    D

     creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error


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

相关内容