单选题Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 =

题目
单选题
Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1
A

1, 2, 3, 3

B

1, 2, 2, 4

C

1, 2, 3, 3, 6

D

1, 2, 2, 5, 6

相似考题

1.You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

2.Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()A.Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.B.Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).C.Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.D.Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

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

4.You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.C. Data is never redacted for the EMP_V.SAL column.D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“Given table T1 has column I1 containing the following data:”相关问题

  • 第1题：

    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()

    A.Define the column MAINID as NOT UPDATABLE

    B.Define the column MAINID as a PRIMARY KEY

    C.Define the column MAINID as a FOREIGN KEY

    D.Define an UPDATE trigger on table TABLEX


    参考答案：D

  • 第2题：

    In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）

    • A、if a table is not in a cluster
    • B、if a table has an active trigger
    • C、if a table has an encrypted
    • D、if a table has a column of data type LONG defined on it
    • E、if a table has a referential integrity constraint defined on it

    正确答案:B,C,E

  • 第3题：

    Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1

    • A、1, 2, 3, 3
    • B、1, 2, 2, 4
    • C、1, 2, 3, 3, 6
    • D、1, 2, 2, 5, 6

    正确答案:A

  • 第4题：

    You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

    • A、Drop the table.
    • B、Partition the table
    • C、Truncate the table.
    • D、Add a column to the table.
    • E、Rename a column in the table.

    正确答案:D

  • 第5题：

    You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）

    • A、The Query Only property is set to Yes. 
    • B、The Conceal Data property is set to Yes. 
    • C、The Insert Allowed property is set to Yes. 
    • D、The Update Allowed property is set to Yes.

    正确答案:A

  • 第6题：

    Consider the following statement：   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2> ownname => ‘OE’， -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， -  4> method opt => ‘for all columns size AUTO’）；   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）

    • A、The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. 
    • B、The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
    • C、The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. 
    • D、The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

    正确答案:C

  • 第7题：

    单选题
    Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique. Which of the following CREATE statements will successfully create this table?（）
    A

    CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

    B

    CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))

    C

    CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

    D

    CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))


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

  • 第8题：

    单选题
    You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
    A

    Drop the table.

    B

    Partition the table

    C

    Truncate the table.

    D

    Add a column to the table.

    E

    Rename a column in the table.


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

  • 第9题：

    单选题
    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）
    A

     Drop the table.

    B

     Partition the table.

    C

     Truncate the table.

    D

     Add a column to the table.

    E

     Rename a column in the table.


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

  • 第10题：

    单选题
    You need to meet the business requirements of the packaging department. What should you do?（）
    A

    Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Set the order of the ProductSKU attribute to the ProductSizeDescriptor column.

    B

    Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Set the order of the key attribute of the ProductSize dimension to the ProductSizeDescriptor column.

    C

    Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Create a user-defined hierarchy that has ProductSKU as the top-level attribute and ProductSizeDescriptor as the bottom-level attribute.

    D

    Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Create a user-defined hierarchy within the ProductSize dimension. Set the ProductSizeDescriptor attribute as the top-level attribute.


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

  • 第11题：

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


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

  • 第12题：

    单选题
    Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1
    A

    1, 2, 3, 3

    B

    1, 2, 2, 4

    C

    1, 2, 3, 3, 6

    D

    1, 2, 2, 5, 6


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

  • 第13题：

    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

  • 第14题：

    You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）

    • A、It is created as a nondisplay item. 
    • B、The Lock Record property is set to Yes. 
    • C、It cannot be referenced in item level triggers. 
    • D、It is placed on the canvas with the highest sequence number.

    正确答案:A

  • 第15题：

    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）

    • A、Define the column MAINID as NOT UPDATABLE
    • B、Define the column MAINID as a PRIMARY KEY
    • C、Define the column MAINID as a FOREIGN KEY
    • D、Define an UPDATE trigger on table TABLEX

    正确答案:D

  • 第16题：

    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

    • A、 Drop the table.
    • B、 Partition the table.
    • C、 Truncate the table.
    • D、 Add a column to the table.
    • E、 Rename a column in the table.

    正确答案:D

  • 第17题：

    You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）

    • A、 column sizes
    • B、 column data types
    • C、 PCTFREE
    • D、 projected number of row
    • E、 PCTUSED

    正确答案:E

  • 第18题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）
    A

    You should drop the XML index on the table. Modify the primary key. Recreate the XML index 

    B

    You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 

    C

    You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 

    D

    You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.


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

  • 第19题：

    单选题
    You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）
    A

    Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.

    B

    Define the new column as NOT NULL with a default value of ’Undefined.’

    C

    Define the new column as NULL. Use application logic to enforce the data constraint.

    D

    Define the new column as NULL with a default value of ’Undefined.’


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

  • 第20题：

    多选题
    In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）
    A

    if a table is not in a cluster

    B

    if a table has an active trigger

    C

    if a table has an encrypted

    D

    if a table has a column of data type LONG defined on it

    E

    if a table has a referential integrity constraint defined on it


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

  • 第21题：

    单选题
    You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）
    A

     column sizes

    B

     column data types

    C

     PCTFREE

    D

     projected number of row

    E

     PCTUSED


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

  • 第22题：

    单选题
    You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）
    A

    The Query Only property is set to Yes. 

    B

    The Conceal Data property is set to Yes. 

    C

    The Insert Allowed property is set to Yes. 

    D

    The Update Allowed property is set to Yes.


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

  • 第23题：

    单选题
    Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）
    A

    Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.

    B

    Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).

    C

    Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.

    D

    Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.


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

相关内容