SQL for Database Construction(1st)

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

1 Mark(s)

False
True

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

1 Mark(s)

False
True

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

1 Mark(s)

False
True

What SQL structure is used to limit column values of a table?

1 Mark(s)

The LIMIT constraint
The VALUE constraint
The CHECK constraint
None of the above is correct.

The DROP TABLE statement:

1 Mark(s)

is not an SQL statement.
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.

Which of the following is an SQL trigger supported by Oracle?

1 Mark(s)

INSTEAD OF
BEFORE
All of the above.
AFTER

What is an SQL virtual table that is constructed from other tables?

1 Mark(s)

Just another table
A view
A relation
Query results

For what purposes are views used?

1 Mark(s)

To hide complicated SQL statements only
All of the above are uses for SQL views.
To hide rows only
To hide columns only

The SQL command to create a table is:

1 Mark(s)

CREATE TABLE
ALTER TABLE
DEFINE TABLE
MAKE TABLE

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

1 Mark(s)

False
True

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

1 Mark(s)

False
True

The SQL ALTER statement can be used to:

1 Mark(s)

change the table structure.
change the table data.
add rows to the table.
delete rows from the table.

When using the SQL INSERT statement:

1 Mark(s)

rows cannot be copied in mass from one table to another only.
rows can be inserted into a table only one at a time only.
rows can be modified according to criteria only.
rows can either be inserted into a table one at a time or in groups.

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

1 Mark(s)

None of the above is correct.
a particular row in a particular underlying table.
a particular column in a particular underlying table.
a particular column in a particular row.

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

1 Mark(s)

pseudofile
None of the above is correct.
trigger
stored procedure

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

1 Mark(s)

True
False

A ________ is a stored program that is attached to a table or a view.

1 Mark(s)

pseudofile
trigger
None of the above is correct.
embedded SELECT statement

SQL views can be used to hide:

1 Mark(s)

complicated SQL syntax only.
columns and rows only.
both of the above can be hidden by an SQL view.
None of the above is correct.

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

1 Mark(s)

False
True

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

1 Mark(s)

True
False

Which is NOT one of the most common types of SQL CHECK constraints?

1 Mark(s)

Comparing one column value to another within the same table
Lists of values
System date
Range checks

Which of the following is NOT a type of SQL constraint?

1 Mark(s)

ALTERNATE KEY
PRIMARY KEY
UNIQUE
FOREIGN KEY

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

1 Mark(s)

True
False

SQL Server does not support the BEFORE trigger.

1 Mark(s)

False
True

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

1 Mark(s)

False
True

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

1 Mark(s)

True
False

A updatable view has its own data.

1 Mark(s)

True
False

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

1 Mark(s)

GROUP BY
WHERE
FROM
ORDER BY

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

1 Mark(s)

False
True

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

1 Mark(s)

False
True

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

1 Mark(s)

False
True

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

1 Mark(s)

True
False

The SQL statement to create a view is:

1 Mark(s)

CREATE VIEW
SELECT VIEW
MAKE VIEW
INSERT VIEW

A reason for using an SQL view to hide columns is:

1 Mark(s)

to prevent the display of sensitive data only.
to accomplish both of the above.
to simplify a result only.
None of the above are reasons for using an SQL view.

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

1 Mark(s)

True
False

What is not an advantage of stored procedures?

1 Mark(s)

Greater security
Increased network traffic
Code sharing
SQL can be optimized

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

1 Mark(s)

True
False

What is an advantage of placing computations in SQL views?

1 Mark(s)

To save users from having to write an expression.
To accomplish both of the above.
To ensure that the results are consistent.
None of the above is correct - computations cannot be placed in a view.

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

1 Mark(s)

False
True

SQL for Database Construction(1st) : Question 1 of 39