Introduction to SQL Questions and Answers

Practice Mode
Showing 10 of 34 questions
Q11
The SQL keyword(s) ________ is used with wildcards.
  • A LIKE only
  • B IN only
  • C NOT IN only
  • D IN and NOT IN
Answer: Option A
Q12
Which of the following is the correct order of keywords for SQL SELECT statements?
  • A SELECT, FROM, WHERE
  • B FROM, WHERE, SELECT
  • C WHERE, FROM,SELECT
  • D SELECT,WHERE,FROM
Answer: Option A
Q13
A subquery in an SQL SELECT statement is enclosed in:
  • A braces -- {...}.
  • B CAPITAL LETTERS.
  • C parenthesis -- (...) .
  • D brackets -- [...].
Answer: Option C
Q14
The result of a SQL SELECT statement is a(n) ________ .
  • A report
  • B form
  • C file
  • D table
Answer: Option D
Q15
Which of the following are the five built-in functions provided by SQL?
  • A COUNT, SUM, AVG, MAX, MIN
  • B SUM, AVG, MIN, MAX, MULT
  • C SUM, AVG, MULT, DIV, MIN
  • D SUM, AVG, MIN, MAX, NAME
Answer: Option A
Q16
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
  • A all columns of the table are to be returned.
  • B all records meeting the full criteria are to be returned.
  • C all records with even partial criteria met are to be returned.
  • D None of the above is correct.
Answer: Option A
Q17
The HAVING clause does which of the following?
  • A Acts like a WHERE clause but is used for groups rather than rows.
  • B Acts like a WHERE clause but is used for rows rather than columns.
  • C Acts like a WHERE clause but is used for columns rather than groups.
  • D Acts EXACTLY like a WHERE clause.
Answer: Option A
Q18
The SQL -92 wildcards are ____ and ____ .
  • A asterisk (*); percent sign (%)
  • B percent sign (%); underscore (_)
  • C underscore(_); question mark (?)
  • D question mark (?); asterisk (*)
Answer: Option B
Q19
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
  • A ONLY
  • B UNIQUE
  • C DISTINCT
  • D SINGLE
Answer: Option C
Q20
The benefits of a standard relational language include which of the following?
  • A Reduced training costs
  • B Increased dependence on a single vendor
  • C Applications are not needed.
  • D All of the above.
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test