Which three are true? A.LAST_DAY returns the date of the last day of the current ,month onlyu. B.CEIL requires an argument which is a numeric data type. C.ADD_MONTHS adds a number of calendar months t ...

.Examine this statement which executes successfully: Which three are true? A.Regardless of salary,only if the employee id is less than 125,insert EMPLOYEE_ID,NANAGER_ID,SALARY into the MGR_HISTORY tab ...

Which three are true about scalar subquery expressions? A.A scalar subquery expression that returns zero rows evaluates to zoro B.They cannot be used in the values clause of an insert statement* C.The ...

Examine the description of EMPLOYEES table: Which three queries return all rows for which SALARY+COMMISSION is greate than 20000? A.SELECT * FROM employees WHERE salary+NULLF(commission,0)>=20000; B.S ...

Which three are key components of an Entity Relationship Model? A.a table B.an attribute C.a unique identifier D.an activity E.a relationship F.an entity **** 本内容被作者隐藏 ****

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