题目内容

YouareworkingonanewOracleDatabase11gserver，whereonlythesoftwareisinstalledandnodatabaseiscreated.YouplantocreateadatabaseonthisserverusingtheDatabaseConfigurationAssistant（DBCA）.
Someoftherequirementssetforyourdatabasecreationtaskare：
1：Configurethedatabasetooperateinsharedservermode.
2：Disableautomaticmaintenancetaskssuchasoptimizerstatisticscollection.
3：Configureanamingmethodtohelptheremoteuserconnecttothedatabaseinstance.
4：UseAutomaticStorageManagement（ASM）forstoringthedatabasefiles.
5：Configuredailydatabasebackuptoflashrecoveryarea.
6：ConfigureEnterpriseManagerDatabaseControltomanagethedatabase.
Whichoftheserequirementscanbemetwhilecreatingthedatabase（）

查看答案

搜索结果不匹配？点我反馈

更多问题

水煤气管道广泛应用在小直径的低压管路上。

EMPLOYEES and DEPARTMENTS data:
EMPLOYEES
DEMP_NAME DEPT_ID MGR_ID JOB_ID SALARY
EMPLOYEE_I
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 IT_ADMIN 5000
106 Smith 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
DEPARTMENTS
DEPARTMENT_ID DEPARTMENT_NAME
10 Admin
20 Education
30 IT
40 Human Resources
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
Evaluate this UPDATE statement.
UPDATE employees
SET mgr_id =
(SELECT mgr_id
FROM employees
WHERE dept_id=
(SELECT department_id
FROM departments
WHERE department_name = ‘Administration‘)),
Salary = (SELECT salary
FROM employees
WHERE emp_name = ‘Smith‘)
WHERE job_id = ‘IT_ADMIN‘;
What happens when the statement is executed？（）

管道进行蒸气吹扫时不需对管进行预热。

安全阀在设备正常工作时是处于关闭状态的。