多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）ARAWBLONGCVARCHARDLONG RAW

题目
多选题
Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）
A

RAW

B

LONG

C

VARCHAR

D

LONG RAW

相似考题

1.Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

2.A company uses raw logical volumes. Which command can be used to back up the data in the raw logical volumes to a tape？（）A、ddB、tarC、cpioD、mksysb

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

4.The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）A、data filesB、backup setsC、control filesD、archived redo log files

更多“多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）ARAWBLONGCVARCHARDLONG RAW”相关问题

  • 第1题：

    Which two statements are true about a bitmap index？ （）

    • A、It is recommended for the columns that have unique values.
    • B、It can be converted to a B-tree index by using the ALTER INDEX command.
    • C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
    • D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

    正确答案:C,D

  • 第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 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

  • 第4题：

    Which two statements about Flashback Query are true？（）

    • A、It is generated by using the redo log files. 
    • B、It helps in row-level recovery from user errors.
    • C、It can be performed to recover ALTER TABLE statements 
    • D、It fails when undo data pertaining to the transaction is overwritten.
    • E、The database has to be opened with the resetlogs option after performing Flashback Query.

    正确答案:B,D

  • 第5题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第6题：

    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL *Loader.
    • D、New data conforms to the constraint， but existing data is not checked.
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第7题：

    单选题
    Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
    A

    Oracle Data Pump.

    B

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

    C

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

    D

    Online Table Redefinition.

    E

    Edition-Based Table Redefinition.


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

  • 第8题：

    多选题
    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL *Loader.

    D

    New data conforms to the constraint， but existing data is not checked.

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第9题：

    多选题
    Which two statements are true about a bitmap index？ （）
    A

    It is recommended for the columns that have unique values.

    B

    It can be converted to a B-tree index by using the ALTER INDEX command.

    C

    It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.

    D

    Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.


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

  • 第10题：

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


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

  • 第11题：

    多选题
    Which two statements about Flashback Query are true？（）
    A

    It is generated by using the redo log files.

    B

    It helps in row-level recovery from user errors.

    C

    It can be performed to recover ALTER TABLE statements

    D

    It fails when undo data pertaining to the transaction is overwritten.

    E

    The database has to be opened with the resetlogs option after performing Flashback Query.


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

  • 第12题：

    多选题
    Which two chart base types can you select using the Chart Wizard?（）
    A

    Line

    B

    Column

    C

    Bubble

    D

    Flowchart

    E

    OHLC candle stock


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

  • 第13题：

    Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）

    • A、RAW
    • B、LONG
    • C、VARCHAR
    • D、LONG RAW

    正确答案:B,D

  • 第14题：

    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

  • 第15题：

    Which two statements are true regarding the USING and ON clauses in table joins?（）

    • A、Both USING and ON clauses can be used for equijoins and nonequijoins 
    • B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
    • C、The ON clause can be used to join tables on columns that have different names but compatible data types 
    • D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

    正确答案:C,D

  • 第16题：

    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

  • 第17题：

    User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

    • A、UPDATE pets…
    • B、SELECT….FROM pets
    • C、INSERT INTO pets…
    • D、ALTER TABLE pets…

    正确答案:B

  • 第18题：

    TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）

    • A、ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders
    • B、DROP TRIGGER trg InsertOrders
    • C、DISABLE TRIGGER trg InsertOrders ON Orders
    • D、ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

    正确答案:A,C

  • 第19题：

    多选题
    Which two statements are true regarding the USING clause in table joins?（）
    A

    It can be used to join a maximum of three tables

    B

    It can be used to restrict the number of columns used in a NATURAL join

    C

    It can be used to access data from tables through equijoins as well as nonequijoins

    D

    It can be used to join tables that have columns with the same name and compatible data types


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

  • 第20题：

    多选题
    Which two statements are true regarding the USING and ON clauses in table joins?（）
    A

    Both USING and ON clauses can be used for equijoins and nonequijoins

    B

    Amaximum of one pair of columns can be joined between two tables using the ON clause

    C

    The ON clause can be used to join tables on columns that have different names but compatible data types

    D

    The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause


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

  • 第21题：

    多选题
    Which two statements regarding a SQL profile are true？（）
    A

    It is built by Automatic Tuning Optimizer.

    B

    It cannot be stored persistently in the data dictionary.

    C

    It can be used by the query optimizer automatically.

    D

    It can be created manually by using the CREATE PROFILE command.


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

  • 第22题：

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


    正确答案： E,F
    解析： 暂无解析

  • 第23题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第24题：

    多选题
    Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）
    A

    RAW

    B

    LONG

    C

    VARCHAR

    D

    LONG RAW


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

相关内容