SQL Database Construction(Ict-Basic)Q1

What is not an advantage of stored procedures?

1 Mark(s)

Greater security
Code sharing
SQL can be optimized
Increased network traffic

What is an advantage of placing computations in SQL views?

1 Mark(s)

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

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

1 Mark(s)

None of the above is correct
trigger
pseudofile
embedded SELECT statement

The DROP TABLE statement:

1 Mark(s)

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

The SQL statement to create a view is:

1 Mark(s)

CREATE VIEW.
MAKE VIEW.
INSERT VIEW.
SELECT VIEW.

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

1 Mark(s)

AFTER
INSTEAD OF
All of the above.
BEFORE

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

1 Mark(s)

None of the above is correct.
stored procedure
trigger
pseudofile

The SQL command to create a table is:

1 Mark(s)

DEFINE TABLE.
MAKE TABLE.
CREATE TABLE.
ALTER TABLE.

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

1 Mark(s)

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

For what purposes are views used?

1 Mark(s)

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

The SQL ALTER statement can be used to:

1 Mark(s)

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

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

1 Mark(s)

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

SQL views can be used to hide:

1 Mark(s)

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

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

1 Mark(s)

Just another table
A view
Query results
A relation

When using the SQL INSERT statement:

1 Mark(s)

rows can either be inserted into a table one at a time or in groups.
rows can be modified according to criteria only.
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.

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

1 Mark(s)

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

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

1 Mark(s)

WHERE.
FROM.
ORDER BY.
GROUP BY.

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

1 Mark(s)

FOREIGN KEY
PRIMARY KEY
ALTERNATE KEY
UNIQUE

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

1 Mark(s)

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

SQL Database Construction(Ict-Basic)Q1 : Question 1 of 19

Career Academy