Which two statements are true regarding subqueries?

Which two statements are true regarding subqueries? (Choose two.) A.Only two subqueries can be placed at one level. B.A subquery can be used to access data from one or more tables or views. C.If the subquery returns 0 rows, then the value returned by the subquery expression is NULL. D.The columns in a subquery must […]

Read More

Which three statements are true?

Which three statements are true? (Choose three.) A.Only one LONG column can be used per table. B.A TIMESTAMP data type column stores only time values with fractional seconds. C.The BLOB data type column is used to store binary data in an operating system file. D.The minimum column width that can be specified for a varchar2 […]

Read More

Which three statements are true regarding single-row functions?

Which three statements are true regarding single-row functions? (Choose three.) A.They can accept only one argument. B.They can be nested up to only two levels. C.They can return multiple values of more than one data type. D.They can be used in SELECT, WHERE, and ORDER BY clauses. E.They can modify the data type of the […]

Read More

Which three statements are true regarding group functions?

Which three statements are true regarding group functions? (Choose three.) A.They can be used on columns or expressions. B.They can be passed as an argument to another group function. C.They can be used only with a SQL statement that has the GROUP BY clause. D.They can be used on only one column in the SELECT […]

Read More

Which two statements are true regarding constraints?

Which two statements are true regarding constraints? (Choose two.) A.A foreign key cannot contain NULL values. B.A column with the UNIQUE constraint can contain NULL. C.A constraint is enforced only for the INSERT operation on a table. D.A constraint can be disabled even if the constraint column contains data. E.All the constraints can be defined […]

Read More