单选题Given the following requirements: Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a

第1题：

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.

第2题：

Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）

• A、DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
• B、When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
• C、When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.
• D、When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

第3题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

• A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
• D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
• F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

第4题：

You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?（）

• A、It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• B、It generates an error when creating the table because the wallet is closed.
• C、It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• D、It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

第5题：

Examine the command：   ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS；   What does the command accomplish？（）

• A、Creates an additional copy of the database online redo log files. 
• B、Stores the primary key column values of each row involved in a DML operation in the online redo log files. 
• C、Stores the primary key column values of each row involved in a DML operation in the supplemental log files. 
• D、Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.

第6题：

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))

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Given the following requirements: Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table. Which of the following CREATE statements will successfully create this table?（）

• A、CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')), );
• B、CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N') );
• C、CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN ('C','H','N')), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );
• D、CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );

第14题：

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.

第15题：

In which scenario will you create a sorted hash cluster？ （）

• A、 if the application uses queries joining tables only occasionally
• B、 if the full table scan is executed often on only one table of the clustered tables
• C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
• D、 when you want the data to be returned automatically in the chronological order

第16题：

In which scenario will you create a hash cluster？（）

• A、 when you want the data to be returned automatically in chronological order
• B、 if the application uses queries joining tables only occasionally
• C、 if the queries against the clustered table use the equality operator （=） to retrieve the desired row
• D、 if the full table scan is executed often on only one of the clustered tables

第17题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

• A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
• D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
• F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

第18题：

Which two statements are true regarding single row functions?（）

• A、They accept only a single argument 
• B、They can be nested only to two levels 
• C、Arguments can only be column values or constants 
• D、They always return a single result row for every row of a queried table 
• E、They can return a data type value different from the one that is referenced

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：