databases Online Quiz - 55
Description: databases Online Quiz - 55 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
When should you create a role? (Choose two.)
Which two statements about sequences are true? (Choose two.)
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES table. How can you accomplish this task?
Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?
The Exadata Hybrid Columnar Compression is of following types
When tables use Exadata Hybrid Columnar Compression, Oracle DML locks larger blocks of data (compression unit) which might reduce concurrency
CELL_OFFLOAD_PROCESSING parameter effect can be also achieved by OPT_PARAM hint