Introduction to SQL Questions and Answers

Practice Mode
Showing 10 of 34 questions
Q1
 You can add a row using SQL in a database with which of the following?
  • A ADD
  • B CREATE
  • C INSERT
  • D MAKE
Answer: Option C
Q2
The command to remove rows from a table 'CUSTOMER' is:
  • A REMOVE FROM CUSTOMER ...
  • B DROP FROM CUSTOMER ...
  • C DELETE FROM CUSTOMER WHERE ...
  • D UPDATE FROM CUSTOMER ...
Answer: Option C
Q3
The SQL WHERE clause:
  • A limits the column data that are returned.
  • B limits the row data are returned.
  • C Both A and B are correct.
  • D Neither A nor B are correct.
Answer: Option B
Q4
Which of the following is the original purpose of SQL?
  • A To specify the syntax and semantics of SQL data definition language
  • B To specify the syntax and semantics of SQL manipulation language
  • C To define the data structures
  • D All of the above.
Answer: Option D
Q5
The wildcard in a WHERE clause is useful when?
  • A An exact match is necessary in a SELECT statement.
  • B An exact match is not possible in a SELECT statement.
  • C An exact match is necessary in a CREATE statement.
  • D An exact match is not possible in a CREATE statement.
Answer: Option B
Q6
A view is which of the following?
  • A A virtual table that can be accessed via SQL commands
  • B A virtual table that cannot be accessed via SQL commands
  • C A base table that can be accessed via SQL commands
  • D A base table that cannot be accessed via SQL commands
Answer: Option A
Q7
The command to eliminate a table from a database is:
  • A REMOVE TABLE CUSTOMER;
  • B DROP TABLE CUSTOMER;
  • C DELETE TABLE CUSTOMER;
  • D UPDATE TABLE CUSTOMER;
Answer: Option B
Q8
ON UPDATE CASCADE ensures which of the following?
  • A Normalization
  • B Data Integrity
  • C Materialized Views
  • D All of the above.
Answer: Option B
Q9
SQL data definition commands make up a(n) ________ .
  • A DDL
  • B DML
  • C HTML
  • D XML
Answer: Option A
Q10
Which of the following is valid SQL for an Index?
  • A CREATE INDEX ID;
  • B CHANGE INDEX ID;
  • C ADD INDEX ID;
  • D REMOVE INDEX ID;
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