单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A The materialized view should have a complete refresh performed after the online table redefinition is completed.B The materialized view should have a fast refresh performed after the online table redefinition is completed.C The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
单选题
The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）
A
The materialized view should have a complete refresh performed after the online table redefinition is completed.
B
The materialized view should have a fast refresh performed after the online table redefinition is completed.
C
The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.
D
The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
参考解析
解析：
暂无解析
相关考题：
以下语句不正确的是( )A.select * from emp;B.select ename,hiredate,sal from emp;C.select * from emp order deptno;D.select * from where deptno=1 and sal
View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）A. The second user‘s session immediately produces the resource busy error.B. The second user‘s command executes successfully.C. The second user‘s session waits for a time period before producing the resource busy error.D. A deadlock is created.
The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?() A.Each extra column in the copy with more columns must not have a default valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
The STUDENT_GRADES table has these columns:The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?（）A.B.C.D.E.F.
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‘)) );
In which of the following situations should correlation names be used?() A.A table referenced in the FROM clause has no indexed column.B.The table referenced in the FROM clause has more than 200 columns.C.Two or more tables in the FROM clause have identical column names.D.The FROM clause contains two or more tables in the SELECT statement.
emp表有主键字段empno,现需要查询empno为100的ename,并赋值给变量v_ename,请写出PL／SQL块实现该功能,要求在PL／SQL块中能够捕捉到不存在记录的异常和其它未知异常,并显示出来。
In which of the following situations should correlation names be used?（）A、A table referenced in the FROM clause has no indexed column.B、The table referenced in the FROM clause has more than 200 columns.C、Two or more tables in the FROM clause have identical column names.D、The FROM clause contains two or more tables in the SELECT statement.
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）A、Each extra column in the copy with more columns must not have a default valueB、Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC、The slave database cannot have more columns than the master. Only the master database can have more columnsD、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A、A check constraint on the EMPLOYEE tableB、A unique constraint on the EMPLOYEE table WORKDEPT columnC、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
下面的查询中哪一个会产生笛卡尔集（）A、SELECT e.empno，e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept d WHERE e.deptno=d.deptnoB、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept dC、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept d WHERE e.empno=101 and e.deptno=d.deptnoD、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept d WHEREe.deptno=d.deptno and d.deptno=60
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')) );
单选题EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table？（）A AB BC CD D
多选题You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）AEach extra column in the copy with more columns must not have a default valueBColumns that are common to both versions of the table must be defined in the same order on the master and the slaveCThe slave database cannot have more columns than the master. Only the master database can have more columnsDColumns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverEThe master database cannot have more columns than the slave. Only the slave deatbase can have more columns
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A The materialized view should have a complete refresh performed after the online table redefinition is completed.B The materialized view should have a fast refresh performed after the online table redefinition is completed.C The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
单选题Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）ACREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);BCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));CCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));DCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
单选题The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）ASELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;BSELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;CSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;DSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CDELETE FROM emp WHERE job=’MANAGER’;DINSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;ESELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
单选题Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）ACREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);BCREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));CCREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));DCREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));
单选题What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）AA check constraint on the EMPLOYEE tableBA unique constraint on the EMPLOYEE table WORKDEPT columnCA foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableDA foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
单选题The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?（）ASELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';BSELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';CSELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, 1,1) = 'n';DSELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, -1,1) = 'n';