databases Online Quiz - 56
|Description: databases Online Quiz - 56|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
We can use the joiner in case of?
In which of the transformation we can discard duplicate data?
What does a power center domain require,at a minimum?
Why is it best to use shortcuts to a common directory for source and target definition objects?
Null value in SQL represent?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e.department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?