Structured Query Language Objective Type Questions and Answers for Interview | SQL MCQs

Questions

16 Which of the following statement is not true about embedded SQL ?

A Embedded SQL expressions for database modification always returns a result.

B An embedded SQL program must be processed by a special processor prior to compilation.

C The exact syntax for embedded SQL request depends on the language in which SQL is embedded.

D In embedded SQL, all query processing is performed by the database system.

Answer: Option [A]

17 Which of the following is an aggregate function is SQL ?

A Union

B Like

C Group

D Min

Answer: Option [D]

⭐ Make GKSeries Your Preferred Source on Google

18 Which one of these is an aggregate function in SQL ?

A AVG

B SELECT

C ORDER BY

D None of these

Answer: Option [A]

19 Language used by programmers to communicate with database is :

A DML

B DDL

C QL

D None of these

Answer: Option [C]

20 Which of the following is an authorization command of SQL ?

A Access

B Secondary key

C Foreign key

D None of these

Answer: Option [D]