SQL for Database Construction Questions and Answers

Practice Mode
Showing 10 of 19 questions
Q1
The SQL command to create a table is:
  • A MAKE TABLE.
  • B ALTER TABLE.
  • C DEFINE TABLE.
  • D CREATE TABLE.
Answer: Option D
Q2
A ________ is a stored program that is attached to a table or a view.
  • A pseudofile
  • B embedded SELECT statement
  • C trigger
  • D None of the above is correct.
Answer: Option C
Q3
 The DROP TABLE statement:
  • A deletes the table structure only.
  • B deletes the table structure along with the table data.
  • C works whether or not referential integrity constraints would be violated.
  • D is not an SQL statement.
Answer: Option B
Q4
SQL views can be used to hide:
  • A columns and rows only.
  • B complicated SQL syntax only.
  • C both of the above can be hidden by an SQL view.
  • D None of the above is correct.
Answer: Option C
Q5
The SQL statement to create a view is:
  • A CREATE VIEW.
  • B MAKE VIEW.
  • C SELECT VIEW.
  • D INSERT VIEW.
Answer: Option A
Q6
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
  • A a particular column in a particular underlying table.
  • B a particular column in a particular row.
  • C a particular row in a particular underlying table.
  • D None of the above is correct.
Answer: Option C
Q7
Which of the following is NOT a type of SQL constraint?
  • A PRIMARY KEY
  • B FOREIGN KEY
  • C ALTERNATE KEY
  • D UNIQUE
Answer: Option C
Q8
A ________ is a program that performs some common action on database data and that is stored in the database.
  • A trigger
  • B stored procedure
  • C pseudofile
  • D None of the above is correct.
Answer: Option B
Q9
For what purposes are views used?
  • A To hide columns only
  • B To hide rows only
  • C To hide complicated SQL statements only
  • D All of the above are uses for SQL views.
Answer: Option D
Q10
What is an SQL virtual table that is constructed from other tables?
  • A Just another table
  • B A view
  • C A relation
  • D Query results
Answer: Option B

📚 More from Database

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