Question 1 : NULL is
1. the same as 0 for integer
2. the same as blank for character
3. the same as 0 for integer and blank for character
4. not a value
View Answer   Discuss with Members

Question 2 : Which of the following is a valid SQL type?
1. CHARACTER
2. NUMERIC
3. FLOAT
4. All of the above
View Answer   Discuss with Members

Question 3 : Count function in SQL returns the number of
1. values.
2. distinct values.
3. groups.
4. columns.
View Answer   Discuss with Members

Question 4 : 'AS' clause is used in SQL for
1. Selection operation.
2. Rename operation.
3. Join operation.
4. Projection operation.
View Answer   Discuss with Members

Question 5 : In SQL, which of the following is not a data definition language commands?
1. REVOKE
2. RENAME
3. UPDATE
4. GRANT
View Answer   Discuss with Members

Question 6 : In SQL, which command is used to change a table's storage characteristics?
1. ALTER TABLE
2. MODIFY TABLE
3. CHANGE TABLE
4. None of these
View Answer   Discuss with Members

Question 7 : ............. joins two or more tables based on a specified column value not equaling a specified column value in another table.
1. EQUIJOIN
2. NON-EQUIJOIN
3. OUTER JOIN
4. NATURAL JOIN
View Answer   Discuss with Members

Question 8 : How to select all data from student table starting the name from letter 'r'?
1. SELECT * FROM student WHERE name LIKE 'r%';
2. SELECT * FROM student WHERE name LIKE '%r%';
3. SELECT * FROM student WHERE name LIKE '%r';
4. SELECT * FROM student WHERE name LIKE '_r%';
View Answer   Discuss with Members

Question 9 : The SQL keyword BETWEEN is used:
1. to limit the columns displayed.
2. for ranges.
3. as a wildcard.
4. None of these is correct.
View Answer   Discuss with Members

Question 10 : SQL can be used to:
1. create database structures only.
2. query database data only.
3. modify database data only.
4. All of the above can be done by SQL.
View Answer   Discuss with Members