Arithmetic expressions containing a null value evaluate to null.
True
False
Concatenation operator is
+
-
||
*
What are SQL “SELECT” statement capabilities.
Projection
Selection
Join
All of the above
To select all the columns from a table EMP, which one of the following is TRUE?
Select all columns from EMP;
Select distinct columns from EMP;
Select * from EMP;
Select ename from emp where ename =”Scott”; This select statement executes successfully.
A Literal is enclosed in double quotes.
SQL is
Structured Query Language
Standard Query Language
System Query Language
Simple Query Language
Duplicate values are eliminated by which keyword
Duplicate
Distinct
Remove
Delete
The two types of subqueries are:
Single-row subquery, Double-row subquery
Double-row subquery, Multiple-row subquery
Multiple-row subquery
Single-row subquery and Multiple subquery
Single-row subquery returns:
Only one row
Two rows
Zero rows
There is no such subquery