单选题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 i1A1, 2, 3, 3B1, 2, 2, 4C1, 2, 3, 3, 6D1, 2, 2, 5, 6
单选题
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
参考解析
解析：
暂无解析
相关考题：
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.
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.
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.
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.
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 UPDATABLEB.Define the column MAINID as a PRIMARY KEYC.Define the column MAINID as a FOREIGN KEYD.Define an UPDATE trigger on table TABLEX
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.
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 clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
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.
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 i1A、1, 2, 3, 3B、1, 2, 2, 4C、1, 2, 3, 3, 6D、1, 2, 2, 5, 6
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 UPDATABLEB、Define the column MAINID as a PRIMARY KEYC、Define the column MAINID as a FOREIGN KEYD、Define an UPDATE trigger on table TABLEX
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.
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.
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.
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 sizesB、 column data typesC、 PCTFREED、 projected number of rowE、 PCTUSED
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.
单选题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？（）AYou should drop the XML index on the table. Modify the primary key. Recreate the XML index BYou 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. CYou 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. DYou should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.
单选题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?（）ACREATE 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))BCREATE 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))CCREATE 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))DCREATE 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))
单选题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？（）ADefine 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.BDefine the new column as NOT NULL with a default value of ’Undefined.’CDefine the new column as NULL. Use application logic to enforce the data constraint.DDefine the new column as NULL with a default value of ’Undefined.’
单选题You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）ADrop the table.BPartition the tableCTruncate the table.DAdd a column to the table.ERename a column in the table.
多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
单选题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.
单选题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 sizesB column data typesC PCTFREED projected number of rowE PCTUSED
单选题You need to meet the business requirements of the packaging department. What should you do?（）AAdd the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Set the order of the ProductSKU attribute to the ProductSizeDescriptor column.BAdd 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.CAdd 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.DAdd 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.
单选题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?（）AThe Query Only property is set to Yes. BThe Conceal Data property is set to Yes. CThe Insert Allowed property is set to Yes. DThe Update Allowed property is set to Yes.
单选题In which of the following situations should correlation names be used?（）AA table referenced in the FROM clause has no indexed column.BThe table referenced in the FROM clause has more than 200 columns.CTwo or more tables in the FROM clause have identical column names.DThe FROM clause contains two or more tables in the SELECT statement.
单选题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?（）ADefine a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.BDefine a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).CDefine column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.DDefine column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
单选题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 i1A1, 2, 3, 3B1, 2, 2, 4C1, 2, 3, 3, 6D1, 2, 2, 5, 6