Explanation: The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. 7. Problems occurs if we don’t implement proper locking strategy
A. Dirty reads
B. Phantom reads
C. Lost updates
D. Unrepeatable reads
Answer:A
Explanation: The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. 7. Problems occurs if we don’t implement proper locking strategy
A. Dirty reads B. Phantom reads C. Lost updates D. Unrepeatable reads
Explanation: Phantom reads occur when an insert or delete action is performed against a row that belongs to a range of rows being read by a transaction. 8. Which of the following fixed database roles can add or remove user IDs?