Which data dictionary table should you query to view the object privileges granted to the user on specific columns? （）

A . Use Data Pump to transfer the existing data to a new encrypted tablespace B . Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace C . Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace D . Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace E . Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

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 .  Flash back all the tables in the data file， one by one. B .  Restore the data file to a new location and perform a media recovery. C .  Flash back the database， there is no need to restore the data file. D .  Restore the data file from the most recent backup and flash the database.

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 .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 . SYSTEM  B . OUTLN  C . INTERNAL  D . SYS

A . DROP TABLE  B . ALTER TABLE  C . RESIZE  D . COALESCE

A . V$DATAFILE B . V$DATAFILE_HEADER C . DBA_DATA_FILES D . V$DBFILE E . V$DATAFILE_ERRORS

A . DBA_USERS  B . DBA_OBJECTS  C . DBA_TS_QUOTAS  D . DBA_TAB_PRIVS&e

A . RAW B . LONG C . VARCHAR D . LONG RAW

A . Library cache  B . Row cache  C . Session UGA  D . Buffer cache

A . By adding all subnets listed by the show ip route connected command B . By adding the subnets of working interfaces over which static neighbors have been defined C . By adding subnets redistributed on the local router from another routing source D . By adding all subnets listed by the show ip route static command

A . table  B . transactional trigger  C . stored procedure  D . FROM clause query

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 LOB values are automatically compressed. B .  The LOB values are cached by default in the buffer cache. C .  The LOB values are automatically stored in encrypted mode. D .  All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

A . INDEXES B . SKIP_INDEXES_MAINTENANCE C . SKIP_UNUSABLE_INDEXES D . RESUMABLE E . INDEXES_UNUSABLE

A .  The data is decrypted during SORT and JOIN operations. B .  The data remains encrypted when it is read into memory. C .  The data remains encrypted when it is stored in the redo logs. D .  The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

A .  Drop the table. B .  Partition the table. C .  Truncate the table. D .  Add a column to the table. E .  Rename a column in the table.

A .  column sizes B .  column data types C .  PCTFREE D .  projected number of row E .  PCTUSED

A .  displaying the minimum list price for each product status B .  displaying all supplier IDs whose average list price is more than 500 C .  displaying the number of products whose list prices are more than the average list price D .  displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable E .  displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

A . if a table is not in a cluster B . if a table has an active trigger C . if a table has an encrypted D . if a table has a column of data type LONG defined on it E . if a table has a referential integrity constraint defined on it

A . flash back all the tables in the data file， one by one B . restore the data file to a new location and perform a media recovery C . flash back the database; there is no need to restore the data file D . restore the data file from the most recent backup and flash back the database

A . V$DATABASE  B . DBA_TABLES  C . SYSAUD$  D . EMP

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));