Introduction to SQL Questions and Answers
Introduction to SQL Questions with Answers help you master the fundamentals of Structured Query Language used in database management. SQL knowledge is essential for data handling, queries, and relational database operations, making it a vital skill for technical interviews and placement exams like TCS, Accenture, and Infosys. These programming questions and answers cover SELECT, INSERT, JOIN, and normalization concepts. Practice online SQL tests or download SQL MCQ PDFs with solutions to build strong command over database queries and improve your interview readiness.
Introduction to SQL
Showing 10 of
34 questions
11. The SQL keyword(s) ________ is used with wildcards.
- LIKE only
- IN only
- NOT IN only
- IN and NOT IN
12. Which of the following is the correct order of keywords for SQL SELECT statements?
- SELECT, FROM, WHERE
- FROM, WHERE, SELECT
- WHERE, FROM,SELECT
- SELECT,WHERE,FROM
13. A subquery in an SQL SELECT statement is enclosed in:
- braces -- {...}.
- CAPITAL LETTERS.
- parenthesis -- (...) .
- brackets -- [...].
14. The result of a SQL SELECT statement is a(n) ________ .
- report
- form
- file
- table
15. Which of the following are the five built-in functions provided by SQL?
- COUNT, SUM, AVG, MAX, MIN
- SUM, AVG, MIN, MAX, MULT
- SUM, AVG, MULT, DIV, MIN
- SUM, AVG, MIN, MAX, NAME
16. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
- all columns of the table are to be returned.
- all records meeting the full criteria are to be returned.
- all records with even partial criteria met are to be returned.
- None of the above is correct.
17. The HAVING clause does which of the following?
- Acts like a WHERE clause but is used for groups rather than rows.
- Acts like a WHERE clause but is used for rows rather than columns.
- Acts like a WHERE clause but is used for columns rather than groups.
- Acts EXACTLY like a WHERE clause.
18. The SQL -92 wildcards are ____ and ____ .
- asterisk (*); percent sign (%)
- percent sign (%); underscore (_)
- underscore(_); question mark (?)
- question mark (?); asterisk (*)
19. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
- ONLY
- UNIQUE
- DISTINCT
- SINGLE
20. The benefits of a standard relational language include which of the following?
- Reduced training costs
- Increased dependence on a single vendor
- Applications are not needed.
- All of the above.