Examine the CREATE DISKGROUP command used to create a disk group:<br /> SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY<br /> DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;<br /> In which situation would you use this method of disk group creation?（）..

第1题

[单选题] Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）

A、An error is generated. B、You will have two identical tables in the HR schema with different names. C、You create a table called employees in the HR schema based on you EMP table. D、You create an alternative name for the employees table in the HR schema in your own schema.

点击查看答案

第2题

[单选题] Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）

A、An error is generated. B、You will have two identical tables in the HR schema with different names. C、You create a table called employees in the HR schema based on you EMP table. D、You create an alternative name for the employees table in the HR schema in your own schema.

点击查看答案

第3题

[单选题] Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）

A、All database operations performed by the impdp command are logged. B、Only CREATE INDEX and CREATE TABLE statements generated by the import are logged. C、Only CREATE TABLE and ALTER TABLE statements generated by the import are logged. D、None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

点击查看答案

第4题

[单选题] Examine the structure of the EMPLOYEES table: You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）

A、CREATE INDEX NAME_IDX (first_name, last_name); B、CREATE INDEX NAME_IDX (first_name AND last_name); C、CREATE INDEX NAME_IDX ON (first_name, last_name); D、CREATE INDEX NAME_IDX ON employees (first_name AND last_name); E、CREATE INDEX NAME_IDX ON employees(first_name, last_name); F、CREATE INDEX NAME_IDX FOR employees(first_name, last_name);

点击查看答案

第5题

[] View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（） View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（）

A、A. The pending area is automatically submitted after the plan creation B、B. The procedure must be executed before creating the resources plan directive C、C. The SYS_GROUP resource consumer group is not included in the resource plan directive D、D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

点击查看答案

第6题

[] View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（） View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（）

A、A. The pending area is automatically submitted after the plan creation B、B. The procedure must be executed before creating the resources plan directive C、C. The SYS_GROUP resource consumer group is not included in the resource plan directive D、D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

点击查看答案

第7题

[单选题] Examine the CREATE DISKGROUP command used to create a disk group: In which situation would you use this method of disk group creation?（）

A、When two-way disk mirroring is required for the allocation units B、When three-way disk mirroring is required for the allocation units C、When using hardware mirroring or RAID D、When disk mirroring is required for the Automatic Storage Management (ASM) disks

点击查看答案

第8题

[] Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（） Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD&ens

A、A.The table created by SKD is not accessible and SKD cannot create new tables. B、B.The tables created by SKD and HR remain， but both cannot create new tables. C、C.The table created by HR remains and HR still has the CREATE TABLE system privilege. D、D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

点击查看答案

第9题

[单选题] Examine the structure if the EMPLOYEES table: You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?（）

A、CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120); B、CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120); C、CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_id; D、CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

点击查看答案

Examine the CREATE DISKGROUP command used to create a disk group:<br /> SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY<br /> DISK &#39;ORCL: FRA3&#39; NAME misc1, &#39;ORCL: FRA4&#39; NAME misc2;<br /> In which situation would you use this method of disk group creation?（）

请使用微信扫码支付

Examine the CREATE DISKGROUP command used to create a disk group:<br /> SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY<br /> DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;<br /> In which situation would you use this method of disk group creation?（）