CMS专题

多选题Which two operations can be performed on an external table()ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the tab

题目
多选题
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

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

第1题:

Which three tasks can be performed using regular expression support in Oracle Database 10g?()

  • A、 it can be used to concatenate two strings.
  • B、 it can be used to find out the total length of the string.
  • C、 it can be used for string manipulation and searching operations.
  • D、 it can be used to format the output for a column or expression having string data.
  • E、 it can be used to find and replace operations for a column or expression having string data.

正确答案:C,D,E

第2题:

Which two operations can be flashed back using the Flashback technology?()

  • A、DROP USER SMITH;
  • B、DROP TABLE EMPLOYEES;
  • C、DROP TABLESPACE USERS;
  • D、ALTER TABLE SALES_REP DROP PARTITION P1;
  • E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

正确答案:A,B

第3题:

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()

A. ALTER TABLE SPLIT PARTITION

B. ALTER TABLE MERGE PARTITION

C. ALTER TABLE TRUNCATE PARTITION

D. ALTER TABLE ADD PARTITION

E. ALTER TABLE DROP PARTITION

F. ALTER TABLE MOVE PARTITION


参考答案: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题:

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()

  • A、UPDATE TABLE
  • B、CREATE CLUSTER
  • C、TRUNCATE TABLE
  • D、ALTER TABLE MOVE
  • E、INSERT INTO···VALUES
  • F、ALTER TABLE···DROP COLUMN
  • G、ALTER TABLE···DROP PARTITION

正确答案:A,E

第6题:

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()

  • A、ALTER TABLE SPLIT PARTITION
  • B、ALTER TABLE MERGE PARTITION
  • C、ALTER TABLE TRUNCATE PARTITION
  • D、ALTER TABLE ADD PARTITION
  • E、ALTER TABLE DROP PARTITION
  • F、ALTER TABLE MOVE PARTITION

正确答案:C,E

第7题:

Which two statements are true about the duplexing of the backups taken by RMAN? ()(Choose two.)

  • A、It's only supported for the backups performed on the tape
  • B、It is not supported for backup operations that produce image copies
  • C、Duplex backups need a parallelism for the device to be equal to number of copies
  • D、Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

正确答案:B,D

第8题:

Which two statements are true regarding views?()

  • A、A subquery that defines a view cannot include the GROUP BY clause 
  • B、A view that is created with the subquery having the DISTINCT keyword can be updated 
  • C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
  • D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

正确答案:C,D

第9题:

Which two statements are correct regarding the Flashback Versions Query feature?()

  • A、 You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.
  • B、 You can use this feature to identify the versions of V$ views.
  • C、 You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.
  • D、 You can use this feature for a table only if row movement is enabled for the table.
  • E、 You can use this feature to identify the versions of external and fixed tables.

正确答案:A,C

第10题:

Which two statements are true about the duplexing of the backups taken by RMAN?()  

  • A、 It’s only supported for the backups performed on the tape
  • B、 It is not supported for backup operations that produce image copies
  • C、 Duplex backups need a parallelism for the device to be equal to number of copies
  • D、 Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

正确答案:B,D

更多相关问题