违法和不良信息举报 联系客服
免费注册 登录

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

参考答案和解析
正确答案： C
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

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

A.Row

B.Page

C.Table

D.Column


参考答案：C

第3题：

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 adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

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


参考答案：B

第4题：

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

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

正确答案:A

第5题：

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

A.View

B.Catalog Table

C.Stored Procedure

D.Global Temporary Table


参考答案：A

第6题：

Which kind of non－sourced UDF can be created so that it only returns a single value?()

A.Row

B.Table

C.Scalar

D.Column


参考答案：C

第7题：

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

第8题：

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, D, F

第9题：

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

第10题：

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

更多相关问题
相关内容