Which two are true about virtual columns? A.They can be referenced In the where clause of an update or debete statement. B.They can be referenced in the set clause of an update statement as the name o ...

Which two statements are true about outer Joins? A.The outer join operator (+) can be used on both sides of the join condition in an outer join. B.An outer join is used to retrieve only the rows that ...

Examine this list of queries: Which two statements are true? A.1 and 4 give the same result. B.2 returns the value 20. C.2 and 3 give the same result. D.3 returns an error. E.1 and 4 give different re ...

Which statement falls to execute successfully? A.SELECT * FROM employees e JOIN department d WHERE e.department_id=d.department_id AND d.department_id=90; B.SELECT * FROM employees e JOIN departments ...

Examine this statement which executes successfully: Which statement will violate the CHECK constraint? A.UPDATE emp80 SET department_id=90 WHERE department_id=80; B.DELETE FROM emp80 WHERE department ...

Examine this statement,which executes successfully: In which order are the rows displayed? A. sorted by DEPARTMENT_NAME B. sorted by DEPARTMENT_NAME and AVGSAL C.sorted by DEPARTMENT_NAME and MAXSAL ...

Which two join conditions in a from clause are non-equijolns? A、table1 JOIN table2 on (tablet.column between table2.column 1 and table2.column2) B、JOIN table2 ON(table!.column >= table2.column) C. ...

Which two are true about unused columns? A.CASCADE constraints must be specified when setting a column tx> unused if that column is referenced In a constraint on another column. B.If you set all the c ...