Question 1 of 25
Hints left: 3
Q1
A view that contains a computed column can be easily updated.
Q2
A SQL view is a virtual table that is constructed from other tables or views.
Q3
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Q4
A transaction in which either all of the database actions occur or none of them do is called:
Q5
The advantage of optimistic locking is that:
Q6
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Q7
Locks placed by command are called ________ .
Q8
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
Q9
Three types of triggers are: BEFORE, AFTER and EXCEPTION.
Q10
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Q11
A stored procedure is a program that performs some common action on database data and is stored in the database.
Q12
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Q13
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Q14
A benefit of using a stored procedure is that it can be distributed to client computers.
Q15
Which of the following locks the item from change but not from read?
Q16
A cursor type in which the application can only move forward through the recordset is called:
Q17
Views can be used to show the results of computed columns.
Q18
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
Q19
A transaction for which all committed changes are permanent is called:
Q20
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Q21
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
Q22
There are three SQL data modification operations: insert, modify and delete.
Q23
A trigger is a stored program that is attached to a database.
Q24
SQL statements can be embedded in triggers, stored procedures, and program code.
Q25
Which of the following refers to a cursor type where changes of any type and from any source are visible?