网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题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 table using the DELETE command” 相关考题
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()
A. ALTER TABLE SPLIT PARTITIONB. ALTER TABLE MERGE PARTITIONC. ALTER TABLE TRUNCATE PARTITIOND. ALTER TABLE ADD PARTITIONE. ALTER TABLE DROP PARTITIONF. ALTER TABLE MOVE PARTITION
考题
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
考题
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.
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）A、ALTER TABLE SPLIT PARTITIONB、ALTER TABLE MERGE PARTITIONC、ALTER TABLE TRUNCATE PARTITIOND、ALTER TABLE ADD PARTITIONE、ALTER TABLE DROP PARTITIONF、ALTER TABLE MOVE PARTITION
考题
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；
考题
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 tapeB、It is not supported for backup operations that produce image copiesC、Duplex backups need a parallelism for the device to be equal to number of copiesD、Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
考题
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）A、UPDATE TABLEB、CREATE CLUSTERC、TRUNCATE TABLED、ALTER TABLE MOVEE、INSERT INTO···VALUESF、ALTER TABLE···DROP COLUMNG、ALTER TABLE···DROP PARTITION
考题
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.
考题
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.
考题
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 tapeB、 It is not supported for backup operations that produce image copiesC、 Duplex backups need a parallelism for the device to be equal to number of copiesD、 Duplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously
考题
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)A、viewsB、fixed tablesC、heap tablesD、external tablesE、temporary tablesF、index-organized tables (IOT)
考题
Which two database operations can be performed at the MOUNT stage of database startup？（）A、renaming of data filesB、dropping the database userC、renaming of control filesD、multiplexing of control filesE、configuring the database in ARCHIVELOG mode
考题
Which two are true regarding external tables？ （）A、External tables can be updated. B、External tables are read-only tables. C、Indexes can be created on external tables. D、Indexes cannot be created on external tables.
考题
多选题Which two are true regarding external tables？ （）AExternal tables can be updated.BExternal tables are read-only tables.CIndexes can be created on external tables.DIndexes cannot be created on external tables.
考题
多选题Which three tasks can be performed using regular expression support in Oracle Database 10g？（）Ait can be used to concatenate two strings.Bit can be used to find out the total length of the string.Cit can be used for string manipulation and searching operations.Dit can be used to format the output for a column or expression having string data.Eit can be used to find and replace operations for a column or expression having string data.
考题
多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA 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
考题
多选题Which two statements regarding the Flashback Table feature are correct?（）AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.DFlashback Table operation acquires exclusive data manipulation language (DML) locks.
考题
多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.
考题
多选题Which two statements regarding external authentication servers for firewall userauthentication are true？（）AUp to three external authentication server types can be used simultaneously.BOnly one external authentication server type can be used simultaneously.CIf the local password database is not configured in the authentication order， and the configured authentication server is unreachable， authentication is not performed.DIf the local password database is not configured in the authentication order， and the configured authentication server rejects the authentication request， authentication is not performed
考题
多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION
考题
多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION
考题
多选题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 table using the DELETE command.
考题
多选题Which two database operations can be performed at the MOUNT stage of database startup？（）Arenaming of data filesBdropping the database userCrenaming of control filesDmultiplexing of control filesEconfiguring the database in ARCHIVELOG mode
考题
多选题Which two statements are true about the duplexing of the backups taken by RMAN？（）AIt’s only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously
考题
多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）ARAWBLONGCVARCHARDLONG RAW
考题
多选题Which two operations can be flashed back using the Flashback technology？（）ADROP USER SMITH；BDROP TABLE EMPLOYEES；CDROP TABLESPACE USERS；DALTER TABLE SALES_REP DROP PARTITION P1；EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
考题
多选题Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)AIt's only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
热门标签
最新试卷