SQL MCQ Questions and answers Page-5 section-1

41.
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

A. SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

B. SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

C. SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

D. SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

Answer & Solution Discuss in Board Save for Later

42.
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

A. Hi

B. FLASE

C. TRUE

D. Nothing

Answer & Solution Discuss in Board Save for Later

43.
Which of the following is illegal?

A. SELECT SYSDATE - SYSDATE FROM DUAL;

B. SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;

C. SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;

D. None of these

Answer & Solution Discuss in Board Save for Later

44.
If a query involves NOT, AND, OR with no parenthesis

A. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

B. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

C. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

D. The order of occurrence determines the order of evaluation.

Answer & Solution Discuss in Board Save for Later

45.
Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return

A. less than 10 rows

B. more than 10 rows

C. exactly 10 rows

D. None of these

Answer & Solution Discuss in Board Save for Later

46.
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints

A. 10

B. 9

C. 5

D. 0

Answer & Solution Discuss in Board Save for Later

47.
Which of the following SQL commands can be used to add data to a database table?

A. ADD

B. UPDATE

C. APPEND

D. INSERT

Answer & Solution Discuss in Board Save for Later

48.
Which of the following join is also called as an 'inner-join'?

A. Non-Equijoin

B. Self-Join

C. Equijoin

D. None of these

Answer & Solution Discuss in Board Save for Later

49.
Which of the following is NOT a type of SQL constraint?

A. PRIMARY KEY

B. ALTERNATE KEY

C. FOREIGN KEY

D. UNIQUE

Answer & Solution Discuss in Board Save for Later

50.
What is an SQL virtual table that is constructed from other tables?

A. view

B. A relation

C. Just another table

D. Query results

Answer & Solution Discuss in Board Save for Later

SQL MCQ Questions and answers

41. Which of the following query finds the total rating of the sailors who have reserved boat "103"?

Answer & Solution

42. The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

Answer & Solution

43. Which of the following is illegal?

Answer & Solution

44. If a query involves NOT, AND, OR with no parenthesis

Answer & Solution

45. Let the statement SELECT column1 FROM myTable; return 10 rows. The statement SELECT ALL column1 FROM myTable; will return

Answer & Solution

46. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. The SQL statement SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE); prints

Answer & Solution

47. Which of the following SQL commands can be used to add data to a database table?

Answer & Solution

48. Which of the following join is also called as an 'inner-join'?

Answer & Solution

49. Which of the following is NOT a type of SQL constraint?

Answer & Solution

50. What is an SQL virtual table that is constructed from other tables?

Answer & Solution

41.
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

42.
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

43.
Which of the following is illegal?

44.
If a query involves NOT, AND, OR with no parenthesis

45.
Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return

46.
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints

47.
Which of the following SQL commands can be used to add data to a database table?

48.
Which of the following join is also called as an 'inner-join'?

49.
Which of the following is NOT a type of SQL constraint?

50.
What is an SQL virtual table that is constructed from other tables?