当前位置:1Z0-053题库

问题:

[多选]

The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema. 
Which two statements are true regarding the outcome of this action?()

A .  All the related indexes and views are automatically dropped
B .  The flashback drop feature can recover only the table structure
C .  Only the related indexes are dropped whereas views are invalidated
D .  The flashback drop feature can recover both the table structure and its data

What are the two proper locations of deployment descriptors files inside of archives deployed to WebLogic?() the WEB-INF subdirectory for a WAR file。 the META-INF subdirectory for an EAR file, or EJB-JAR。 the DD-INF subdirectory。 the root of archive。 any searchable locatio。 在选择车辆调度形式的时,若采用区间车调度形式,则需要满足条件――路段客流差大于等于()倍的计划车载客定额; 2。 2~4。 1.2~1.5。 1.5。 For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()  RMAN image copies.。  RMAN database backups.。  RMAN tablespace backups.。  User-managed backups placed in the flash recovery area.。  User-managed backups that have been cataloged with RMAN.。  User-managed data file backups for which the pull path name is specified.。 Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?() When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.。 When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.。 When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.。 When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.。 Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?() SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;。 SELECT e.employee_id "Emp_id", e.emp_name "Employee",。 salary,。 employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000。

The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema. 
Which two statements are true regarding the outcome of this action?()

参考答案:

  参考解析

本题暂无解析

在线 客服