[单项选择]The table is made of ______.

[单项选择]This table is made of.
A. a wood
B. some wood
C. the wood
D. wood

[单项选择]The table is made of ______.

[单项选择] You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）
A. You get an error because of a primary key violation.
B. The data and structure of the EMPLOYEES table are deleted.
C. The data in the EMPLOYEES table is deleted but not the structure.
D. You get an error because the statement is not syntactically correct.

[判断题]TABLE为数据段中每存储单元的符号名，则指令MOV AX，TABLE和指令LEA AX，TABLE是等价的。

[单项选择]Who made the remark
A. A student.
B. A teacher.
C. A lecture.
D. A president.

[单项选择]A dress made of silk feels better than ______ made of cotton.
A. that
B. which
C. one
D. those

[多项选择]Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
A. ALTER TABLE SPLIT PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE TRUNCATE PARTITION
D. ALTER TABLE ADD PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION

[多项选择]Which two statements describe the forwarding table in the Junos OS?（）
A. The forwarding table contains all known routes.
B. The forwarding table stores a subset of information from the routing table.
C. Junos devices use the forwarding table to compare incoming packets against existing entries to determine the next hop.
D. If multiple matches exist, the forwarding table uses the least-specific entry to forward packets toward the destination.

[多项选择]Which statements are true regarding table compression? （）(Choose all that apply.)
A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.

[单项选择] 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

[多项选择]Which two statements regarding the Flashback Table feature are correct?（）
A. Flashback Table can be performed on system tables.
B. Flashback Table operation does not shrink the segments.
C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.

[单项选择] The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT 101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote 105 ANNE -106 BOB A11 The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT 1 WU B01 - 2 JONES A11 - 3 CHEN - - 4 SMITH - -5 THOMAS C12 - After this statement is executed: UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno) What is the result of the following query?（） SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid
A. MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1
B. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1
C. MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3
D. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1

[单项选择]Who made a bigger mistake


A. Betty
B. Mrs. Alison
C. Mr. Alison

[单项选择]Who made Donald Duck cartoons
A. Mickey Mouse.
B. Clarence Nash.
C. Walter Disney.
D. Pluto.