Related Questions

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
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 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
Ten new television shows appeared during the month of September. Five of the shows were sitcoms, three were hour-long dramas, and two were news-magazine shows. By January, only seven of these new shows were still on the air. Five of the shows that remained were sitcoms.
A Only one of the news-magazine shows remained on the air.
B Only one of the hour-long dramas remained on the air.
C At least one of the shows that was cancelled was an hour-long drama.
D Television viewers prefer sitcoms over hour-long dramas.
When new data are to inserted into a data structure, but there is no available space ; this situation is usually called _______.
A underflow
B overflow
C houseful
D saturated
In a room there are six Bengali, twelve engineers and fifteen football players. Only one of them was a bengali Engineer who played Football. Two were Bengali Engineers but did not play football and two were Bengali football players and were not engineers. If there were 24 people in the room, and at least one of them were Bengali, engineer or a football player, how many were engineers and played football but not bngali?
A 1
B 9
C 6
D 3
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
A ZIP
B PACK
C COMMIT
D SAVE
E None of the above
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
A REPEATABLE READ
B SERIALIZABLE
C READ COMMITTED
D READ UNCOMMITTED
Read the paragraph and answer the question Viruses are living organisms.We may consider them regular chemical molecule since they have normal atomic structure, but on the other hand, we must also consider them as being alive since they are able to multiply unlimited quantities Viruses are alive because they
A need warmth
B live
C have a complex atomic structure
D multiply
In SQL, which command is used to add new rows to a table?
A Alter Table
B Add row
C Insert
D Append

Next steps