Which three table transformations can be done using online redefinition of tables？（）https://assets.asklib.com/images/image2/201808011056166030.jpg

A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id); B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); C . SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); D . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); E . SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id); F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))

A . The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output. B . The DESCRIBE commands in SQL *Plus will not display the invisible column in the output. C . Referential integrity constraint cannot be set on the invisible column. D . The invisible column cannot be made visible and can only be marked as unused. E . A primary key constraint can be added on the invisible column.

A . INSERT INTO employees VALUES ( NULL, 'John', 'Smith'); B . INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith'); C . INSERT INTO employees VALUES ( '1000', 'John', NULL); D . INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith'); E . INSERT INTO employees (employee_id) VALUES (1000); F . INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ')

A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id); B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id); C . SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id); D . SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id); E . SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id); F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY))

A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL *Loader. D . New data conforms to the constraint， but existing data is not checked. E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

A . The corresponding indexes for the table are also truncated. B . Delete triggers on the table are fired during the execution of the TRUNCATE command. C . The child table is truncated when the TRUNCATE command is applied on the parent table. D . The high-water mark （HWM） is set to point to the first usable data block in the table segment. E . No undo or very little undo data is generated during the execution of the TRUNCATE command

A . INSERT INTO employees VALUES (NULL, 'JOHN','Smith'); B . INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith'); C . INSERT INTO employees VALUES ('1000','JOHN','NULL'); D . INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith'); E . INSERT INTO employees (employee_id) VALUES (1000); F . INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',")

A .https://assets.asklib.com/images/image2/2018080114532989067.jpg B .https://assets.asklib.com/images/image2/2018080114533475360.jpg C .https://assets.asklib.com/images/image2/201808011453398583.jpg D .https://assets.asklib.com/images/image2/2018080114534220354.jpg E .https://assets.asklib.com/images/image2/2018080114534550259.jpg F .https://assets.asklib.com/images/image2/2018080114535031305.jpg

A . Indexes and views can be created on temporary tables. B . Both the data and the structure of temporary tables can be exported. C . Temporary tables are always created in a user’s temporary tablespace. D . The data inserted into a temporary table in a session is available to other sessions. E . Data manipulation language （DML） locks are never acquired on the data of temporary table

A . Design a trigger that verifies that the first names and surnames are not empty strings. B . Design a check constraint that verifies that the first names and surnames are not empty strings. C . Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid. D . Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid. E . Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format. F . Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.

A . It releases the storage space used by the table. B . It does not release the storage space used by the table. C . You can roll back the deletion of rows after the statement executes. D . You can NOT roll back the deletion of rows after the statement executes. E . An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error. F . You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

A . INSERT INTO employees VALUES (NULL, 'John', 'smith'); B . INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith'); C . INSERT INTO employees VALUES ('1000, 'John', 'smith'); D . INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith'); E . INSERT INTO employees (employee_id) VALUES (1000); F . INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','')

A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL*Loader. D . New data conforms to the constraint， but existing data is not checked E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

A . External tables can be updated.  B . External tables are read-only tables.  C . Indexes can be created on external tables.  D . Indexes cannot be created on external tables.

A . A B . B C . C D . D E . E

A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id); B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id); C . SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id); D . SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id); E . SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id); F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY))

A . INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’); B . INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’); C . INSERT INTO employees VALUES (‘1000’,‘John’,NULL); D . INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’); E . INSERT INTO employees (employee_id) VALUES (1000); F . INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’)

A .  A lightweight AP receives control and configuration from a WLAN controller to which it is associated. B .  A WLAN client that is operating in half-duplex mode will delay all clients in that WLAN C .  A dhoc mode allows mobile clients to connect directly without an intermediate AP D .  Another term for infrastructure mode is independent service set （IBSS） E .  The Aironet 1230 access point is an example of an access point that operates solely as a lightweight  access point. F .  WLANs are designed to share the medium and can easily handle an increased demand of channel  contention.

A . SYS sessions, regardless of the roles that are set in the session B . SYSTEM sessions, regardless of the roles that are set in the session C . SCOTT sessions, only if the MGR role is set in the session D . SCOTT sessions, only if the MGR role is granted to SCOTT E . SCOTT sessions, because he is the owner of the table F . SYSTEM session, only if the MGR role is set in the sessio

A . Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status.  B . You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.  C . Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.  D . Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.

A . Indexes and views can be created on temporary tables. B . Both the data and the structure of temporary tables can be exported. C . Temporary tables are always created in a user’s temporary tablespace. D . The data inserted into a temporary table in a session is available to other sessions. E . Data manipulation language （DML） locks are never acquired on the data of temporary tables.

A . Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. B . Statistics collection is not done for the CUSTOMERS table when database stats are gathered. C . Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time. D . Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics. E . Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Questions 33-36 Complete the table using NO MORE THAN THREE WORDS for each answer. <img src='https://img2.soutiyun.com/shangxueba/ask/11019001-11022000/11020376/ct_ei_007(20095).jpg' /> 【33】

A. SELECT * FROM employees where salary ＞ (SELECT MIN(salary) FROM employees GROUP BY department _ id); B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id); C. SELECT distinct department_id FROM employees Where salary ＞ ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id); D. SELECT department_id FROM employees WHERE SALARY ＞ ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id); E. SELECT last_name FROM employees Where salary ＞ ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id); F. SELECT department_id FROM employees WHERE salary ＞ ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));