网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）
A
CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B
CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C
CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D
CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
参考答案
参考解析
解析：
暂无解析
更多 “单选题Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）A CREATE UNIQUE INDEX idx_partno ON parts(part_no)B CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)” 相关考题
考题
Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;（）A.3B.2C.1D.0
考题
Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?A.SELECT TABLE(EMPLIST()) FROM EMPLOYEEB.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
考题
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))
考题
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）A.CREATE UNIQUE INDEX idx_partno ON parts(part_no)B.CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C.CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D.CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
考题
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）A、CREATE UNIQUE INDEX idx_partno ON parts(part_no)B、CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C、CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D、CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
考题
A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
考题
Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); What is the result of the following query? SELECT count(*) FROM tab2;（）A、3B、2C、1D、0
考题
Given the following function: CREATE FUNCTION emplist （ ） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?A、SELECT TABLE(EMPLIST()) FROM EMPLOYEEB、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
考题
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP 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.
考题
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.
考题
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A、The table created by SKD is not accessible and SKD cannot create new tables.B、The tables created by SKD and HR remain， but both cannot create new tables.C、The table created by HR remains and HR still has the CREATE TABLE system privilege.D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
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 is a valid CREATE TABLE statement?（）A、CREATE TABLE EMP9$# AS (empid number(2));B、CREATE TABLE EMP*123 AS (empid number(2));C、CREATE TABLE PACKAGE AS (packid number(2));D、CREATE TABLE 1EMP_TEST AS (empid number(2));
考题
Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）A、 Create a FOR trigger. B、 Create an INSTEAD OF trigger. C、 Create an AFTER trigger. D、 Create a DDL trigger.
考题
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))
考题
单选题假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。A
TAKE BACK CREATE ANY TABLE FROM testB
REVOKE CREATE ANY TABLE FROM testC
REVOKE CREATE ANY TABLE testD
TAKE BACK CREATE ANY TABLE test
考题
单选题Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）A
Create a FOR trigger. B
Create an INSTEAD OF trigger. C
Create an AFTER trigger. D
Create a DDL trigger.
考题
单选题Examine the following steps performed on a database instance： 1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2：The SKD usercreates a table. 3：The SKD user grants theCREATETABLE system privilege to the HR user. 4：The HR user creates a table. 5：The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 is performed（）A
The table created by SKD isnot accessibleand SKD cannot create new tables.B
The tables created by SKD and HR remain， but both cannot create new tables.C
The table created by HR remains and HR still has the CREATE TABLE system privilege.D
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
单选题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))
考题
单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A
All database operations performed by the impdp command are logged.B
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D
None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
考题
单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?（）A
You cannot create a table form within Forms. B
You must use the FORMS_DDL built-in to create the table. C
You must use the DBMS_DYNAMIC_DDL package to create the table. D
You can write the CREATE TABLE statement directly into the trigger.
考题
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
单选题Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A
The table created by SKD is not accessible and SKD cannot create new tables.B
The tables created by SKD and HR remain， but both cannot create new tables.C
The table created by HR remains and HR still has the CREATE TABLE system privilege.D
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
单选题You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）A
DROP TABLE B
ALTER TABLE C
RESIZE D
COALESCE
热门标签
最新试卷
