databases Online Quiz - 55
|Description: databases Online Quiz - 55|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
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 substitution variable would you use if you want to reuse the variable value without prompting the user each time?
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
CELL_OFFLOAD_PROCESSING parameter effect can be also achieved by OPT_PARAM hint
- CELL_OFFLOAD_PROCESSING parameter can be used to compare the performance of Exadata Cell with conventional storage
- CELL_OFFLOAD_PLAN_DISPLAY parameter determines whether the SQL EXPLAIN PLAN command displays the predicates that can be evaluated by Exadata Cell as STORAGE predicates for a given SQL command