单选题EMPDET is an external table containing the columns EMPNO and ENAME.   Which command would work in relation to the EMPDET table?()A AB BC CD D

题目
单选题
EMPDET is an external table containing the columns EMPNO and ENAME.   Which command would work in relation to the EMPDET table?()
A

A

B

B

C

C

D

D

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You would like to view all Fast Ethernet interfaces currently using VLAN tagging and the specific VLANs each interface is using.Which CLI command displays this information?()

A.A

B.B

C.C

D.D


参考答案:C

第2题:

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()

A.Table

B.Columns

C.Table and Alias

D.Columns and Alias


参考答案:A

第3题:

Which three methods will show the storage engine for the Country table?()

A.A

B.B

C.C

D.D

E.E


参考答案:A, C, E

第4题:

Which two operations can be performed on an external table()

  • A、Create a view on the table.
  • B、Create an index on the table.
  • C、Create a synonym on the table.
  • D、Add a virtual column to the table.
  • E、Update the table using the UPDATE statement.
  • F、Delete rows in the table using the DELETE command.

正确答案:A,C

第5题:

You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()

  • A、MERGE
  • B、SELECT …CROSS JOIN
  • C、INSERT ALL …SELECT
  • D、CREATE VIEW …CONSTRAINT

正确答案:A

第6题:

Which command would correctly set a router‘s date and time?()

A.A

B.B

C.C

D.D


参考答案:C

第7题:

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()

  • A、Table
  • B、Columns
  • C、Table and Alias
  • D、Columns and Alias

正确答案:A

第8题:

Consider the following table:Which method should used to add a new g201305 partition to the table?()

A.A

B.B

C.C

D.D

E.E


参考答案:E

第9题:

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()

  • A、Immediately following statement execution 
  • B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
  • C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
  • D、After the ALTER TABLE MODIFY command is issued

正确答案:B

第10题:

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to?()

  • A、null lock on the row being updated
  • B、null lock on the table containing the row
  • C、ROW SHARE lock for the row being updated
  • D、ROW EXCLUSIVE lock for the row being updated
  • E、shared row-exclusive lock for the row being updated
  • F、a shareable table lock for the table containing the row
  • G、exclusive table-level lock for the table containing the row

正确答案:D,F

更多相关问题