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