- Nonrepeatable read
- Phantom read
- Dirty read
- Consistent read
1 Answers
Call
Talk Doctor Online in Bissoy App
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?
Answer: Option 2 Let'
1 Answers 1 views
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Answer: Option 1 Let'
1 Answers 1 views
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.?
Answer: Option 1 Let'
1 Answers 1 views
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.?
Answer: Option 2 Let'
1 Answers 1 views
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.?
Answer: Option 2 Let'
1 Answers 1 views
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.?
Answer: Option 2 Let'
1 Answers 1 views
When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.?
Answer: Option 2 Let'
1 Answers 1 views
Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.?
Answer: Option 1 Let'
1 Answers 1 views
Before a disk drive can access any sector record, a computer program has to provide the record's disk address. What information does this address specify?
Answer: Option 4 Before a disk drive can access any sector record, a computer program has to provide the record's disk address by Track number, Sector number, Surface number and...
1 Answers 1 views
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Answer: Option 4 Let'
1 Answers 1 views