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 garden has to plant tress in rows containing equal number of trees. If he plants in rows of 6,8,10 or 12. then five tress are ledt unplated. But if he plants in rows of 13 tress each, then no tress is left. What is the number of tress that the gardener plants?
A 485
B 854
C 725
D 625
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
A READ_ONLY
B SCROLL_LOCK
C OPTIMISTIC
D READCOMMITTED
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
Maria needs to install software on a Windows NT Server computer which is a backup domain controller. When she attempts to log on to the server, she receives the message "Unable to log on locally". What must you do to enable Maria to log on to the server?
A In User Manager for Domains, define Maria as a local account
B In User Manager for Domains, assign Maria to a group that has the right to log on locally
C In the System option in Control Panel, select the setting that allows users to log on locally
D In the System option in Control Panel, set the user environment variables to allow Maria to log on locally
E None of the above
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
Which of the following locks the item from change but not from read?
A Implicit lock
B Explicit lock
C Exclusive lock
D Shared lock
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
A True
B False
A nurse caring for a patient with an infectious disease who requires isolation should refers to guidelines published by the
A National league for nursing
B Centers for disease control
C American medical association
D American nurses association
You are to arrange 36 identical chairs in rows such that there is same number of chairs in each row. Each row must contain at least 4 chairs and there must be at least 3 rows. How many different arrangements are possible?
A 4
B 2
C 6
D 5

Next steps