True Or False

Question 1 :

The SQL statement used to create a view is CREATE VIEW.


A). True
B). False
Answer : Option A

Question 2 :

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.


A). True
B). False
Answer : Option B

Question 3 :

SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.


A). True
B). False
Answer : Option A

Question 4 :

Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.


A). True
B). False
Answer : Option B

Question 5 :

The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.


A). True
B). False
Answer : Option B

Question 6 :

SQL Server does not support the BEFORE trigger.


A). True
B). False
Answer : Option A

Question 7 :

A updatable view has its own data.


A). True
B). False
Answer : Option B

Question 8 :

The SQL DELETE statement is used to delete both the table structure and table data.


A). True
B). False
Answer : Option B

Question 9 :

Common types of SQL CHECK constraints include range checks and limiting columns values.


A). True
B). False
Answer : Option A

Question 10 :

If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.


A). True
B). False
Answer : Option A

Question 11 :

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.


A). True
B). False
Answer : Option A

Question 12 :

Views can be used to show the results of computed columns.


A). True
B). False
Answer : Option A

Question 13 :

A benefit of using a stored procedure is that it can be distributed to client computers.


A). True
B). False
Answer : Option B

Question 14 :

A trigger is a stored program that is attached to a database.


A). True
B). False
Answer : Option B

Question 15 :

A stored procedure is a program that performs some common action on database data and is stored in the database.


A). True
B). False
Answer : Option A

Question 16 :

A SQL view is a virtual table that is constructed from other tables or views.


A). True
B). False
Answer : Option A

Question 17 :

There are three SQL data modification operations: insert, modify and delete.


A). True
B). False
Answer : Option A

Question 18 :

SQL statements can be embedded in triggers, stored procedures, and program code.


A). True
B). False
Answer : Option A

Question 19 :

A view that contains a computed column can be easily updated.


A). True
B). False
Answer : Option B

Question 20 :

Three types of triggers are: BEFORE, AFTER and EXCEPTION.


A). True
B). False
Answer : Option B