Related Questions

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?
A Nonrepeatable read
B Phantom read
C Dirty read
D Consistent read
A transaction for which all committed changes are permanent is called:
A atomic.
B consistent.
C isolated.
D durable.
A durable transaction is one in which all committed changes are permanent.
A True
B False
The number of student in 3 classes is in the ratio 2:3:4 if 12 students are increased in each class this ratio changes to 8:11:14. The total number of students in the three classes in the beginning in the three classes in the beginning was:
A 162
B 108
C 96
D 54
In SQL, which command is used to changes data in a table?
A UPDATE
B INSERT
C BROWSE
D APPEND
E None of the above
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
A Open
B Show
C Alter
D Edit
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
A Nonrepeatable read
B Phantom read
C Dirty read
D Consistent read
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
A True
B False
When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
A True
B False
In a village the growth rate of population is 5% every year . There are 1600 people in the beginning of 2008 . what will be the approximate number of people in the beginning of 2011?
A 2,012
B 1,696
C 1,698
D 1,689

Next steps