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 ...

Which two are true about creating tables in an Oracle database? A.A create table statement can specify the maximum number of rows the table will contain. B.The same table name can be used for tables i ...

No user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)? A.COMMIT erases all the transaction^ savepoints and releases its locks. B.COMMIT ends th ...

Which three are true about subqueries? A.A subquery can be used in a WHERE clause. B.A subquery can be used in a HAVING clause. C.=ANY can only evaluate the argument against a subcjuery if it returns ...