当前位置:1Z0-060题库

问题:

[多选] You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?()

A . The database must have multiplexed redo logs for the flashback to succeed.
B . The database must be MOUNTED for the flashback to succeed.
C . The database must use block change tracking for the flashback to succeed.
D . The database must be opened in restricted mode for the flashback to succeed.
E . The database must be opened with the RESETLOGS option after the flashback is complete.
F . The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?() SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary。 SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent。 SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary。 You cannot find the information because there is no common column between the two tables.。 垂直绿化类特点 利用()对象的LineTo等绘图方法,可以绘制基本图形。 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?()  The materialized view should have a complete refresh performed after the online table redefinition is completed.。  The materialized view should have a fast refresh performed after the online table redefinition is completed.。  The materialized view,materialized log,and the index should be dropped and re-created after the online table redefinition is complete.。  The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.。 浇筑式沥青混凝土集料组成中,粗集料的用量一般占()。 25%。 35%。 45%。 55%。 You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?()
参考答案:

  参考解析

本题暂无解析

在线 客服