On the table there are（）.._第1考题试题答案

第1题

[单选题] Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: What happens when you execute the DELETE statement?（）

A、Only the row with department ID 40 is deleted in the DEPARTMENTS table. B、The statement fails because there are child records in the EMPLOYEES table with department ID 40. C、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table. D、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table. E、The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted. F、The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

点击查看答案

第2题

[单选题] Which statement is correct about the forwarding table?（）

A、The forwarding table is stored only on the PFE B、The forwarding table contains all known routes C、The forwarding table is stored on both the RE and PFE D、The forwarding table is stored only on the RE

点击查看答案

第3题

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

点击查看答案

第4题

[单选题] On the table there are（）

A、five ten-dollar bills B、five ten-dollars bill C、five ten dollars bills

点击查看答案

第5题

[单选题] The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode. What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table？（）

A、Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially B、Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE command C、Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE command D、Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command

点击查看答案

第6题

[多选题] Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? （）

A、You cannot roll back this statement. B、All pending transactions are committed. C、All views based on the DEPT table are deleted. D、All indexes based on the DEPT table are dropped. E、All data in the table is deleted, and the table structure is also deleted. F、All data in the table is deleted, but the structure of the table is retained. H、All synonyms based on the DEPT table are deleted.

点击查看答案

第7题

[多选题] Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）

A、You cannot roll back this statement. B、All pending transactions are committed. C、All views based on the DEPT table are deleted. D、All indexes based on the DEPT table are dropped. E、All data in the table is deleted, and the table structure is also deleted. F、All data in the table is deleted, but the structure of the table is retained. H、All synonyms based on the DEPT table are deleted.

点击查看答案

第8题

[多选题] Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）

A、You cannot roll back this statement. B、All pending transactions are committed. C、All views based on the DEPT table are deleted. D、All indexes based on the DEPT table are dropped. E、All data in the table is deleted, and the table structure is also deleted. F、All data in the table is deleted, but the structure of the table is retained. H、All synonyms based on the DEPT table are deleted.

点击查看答案

第9题

[多选题] Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）

A、You cannot roll back this statement. B、All pending transactions are committed. C、All views based on the DEPT table are deleted. D、All indexes based on the DEPT table are dropped. E、All data in the table is deleted, and the table structure is also deleted. F、All data in the table is deleted, but the structure of the table is retained. H、All synonyms based on the DEPT table are deleted.

点击查看答案

On the table there are（）

请使用微信扫码支付