Introduction to SQL Questions and Answers

Practice Mode
Showing 10 of 34 questions
Q21
 Which of the following do you need to consider when you make a table in SQL?
  • A Data types
  • B Primary keys
  • C Default values
  • D All of the above.
Answer: Option D
Q22
SQL query and modification commands make up a(n) ________ .
  • A DDL
  • B DML
  • C HTML
  • D XML
Answer: Option B
Q23
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
  • A LIKE only.
  • B IN only.
  • C NOT IN only.
  • D Both IN and NOT IN.
Answer: Option D
Q24
The Microsoft Access wildcards are ____ and ____ .
  • A asterisk (*); percent sign (%)
  • B percent sign (%); underscore (_)
  • C underscore(_); question mark (?)
  • D question mark (?); asterisk (*)
Answer: Option D
Q25
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
  • A SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
  • B SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
  • C SELECT NAME IN CUSTOMER WHERE STATE = 'V';
  • D SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Answer: Option D
Q26
Which one of the following sorts rows in SQL?
  • A SORT BY
  • B ALIGN BY
  • C ORDER BY
  • D GROUP BY
Answer: Option C
Q27
To sort the results of a query use:
  • A SORT BY.
  • B GROUP BY.
  • C ORDER BY.
  • D None of the above is correct.
Answer: Option C
Q28
To define what columns should be displayed in an SQL SELECT statement:
  • A use FROM to name the source table(s) and list the columns to be shown after SELECT.
  • B use USING to name the source table(s) and list the columns to be shown after SELECT.
  • C use SELECT to name the source table(s) and list the columns to be shown after USING.
  • D use USING to name the source table(s) and list the columns to be shown after WHERE.
Answer: Option A
Q29
SQL can be used to:
  • A create database structures only.
  • B query database data only.
  • C modify database data only.
  • D All of the above can be done by SQL.
Answer: Option D
Q30
The SQL statement that queries or reads data from a table is ________ .
  • A SELECT
  • B READ
  • C QUERY
  • D None of the above is correct.
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