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

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

[单项选择]Which statement about the enabling of table compression in Oracle Database 11g is true?（）
A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
B. Compression can be enabled only at the table level for both direct loads and conventional DML.
C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

[多项选择]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.
G. All synonyms based on the DEPT table are deleted.

[单项选择]Which statement is true about the forwarding table?（）
A. The forwarding table is stored in the control plane only.
B. The forwarding table is stored in the control plane and in the forwarding plane.
C. The forwarding table contains both active and inactive routes.
D. The forwarding table can contain only a single next hop per destination.

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

[单项选择]Which statement is true about a forwarding table?（）
A. It stores a subset of information from the routing table.
B. It contains routes learned from all protocols to a destination.
C. It provides a database for routes selected and placed into the routing table.
D. Every routing protocol maintains its own forwarding table.

[单项选择]The statement for which there is support in the passage is that ______.
A. guilt is a psychic impediment
B. low scores on the Mosher scales are evidence of good mental health
C. the best military commanders feel little sense of guilt about carrying out their assignments even if it goes against their brain to do so
D. individuals should not feel guilty about fulfilling their own needs and desires as long as they do not act counter to the needs of society

[单项选择]Which statement is true about the routing table?（）
A. The routing table exists in the control plane only.
B. The routing table exists in the control plane and in the forwarding plane.
C. The routing table contains both active and inactive routes.
D. The routing table is stored on compact flash.

[单项选择]Which statement is true about a routing table?（）
A. It contains routes learned dynamically only.
B. It finds the best path to each destination by using a modified shortest-path-first calculation.
C. It contains only active BGP routes.
D. It contains all accepted routes to all destinations.

[多项选择] You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）
A. Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D. Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E. Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table