SQL for Database Construction - General Questions Online Exam Quiz
SQL for Database Construction - General Questions GK Quiz. Question and Answers related to SQL for Database Construction - General Questions. MCQ (Multiple Choice Questions with answers about SQL for Database Construction - General Questions
The SQL command to create a table is:
Options
A : MAKE TABLE.
B : ALTER TABLE.
C : DEFINE TABLE.
D : CREATE TABLE.
A ________ is a stored program that is attached to a table or a view.
Options
A : pseudofile
B : embedded SELECT statement
C : trigger
D : None of the above is correct.
The DROP TABLE statement:
Options
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.
SQL views can be used to hide:
Options
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.
The SQL statement to create a view is:
Options
A : CREATE VIEW.
B : MAKE VIEW.
C : SELECT VIEW.
D : INSERT VIEW.
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Options
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.
Which of the following is NOT a type of SQL constraint?
Options
A : PRIMARY KEY
B : FOREIGN KEY
C : ALTERNATE KEY
D : UNIQUE
A ________ is a program that performs some common action on database data and that is stored in the database.
Options
A : trigger
B : stored procedure
C : pseudofile
D : None of the above is correct.
For what purposes are views used?
Options
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.
What is an SQL virtual table that is constructed from other tables?
Options
A : Just another table
B : A view
C : A relation
D : Query results
Advanced SQL - General Questions more Online Exam Quiz
Modeling Data in the Organization - General Questions
Object-Oriented Database - General Questions
Object-Oriented Data Modeling - General Questions
ODBC, OLE DB, ADO, and ASP - General Questions
Physical Database Design - General Questions
The Client-Server Database - General Questions
The Database Development Process - General Questions
The Database Environment - General Questions