Explanation: In database systems, durability is the ACID property which guarantees that transactions that have committed will survive permanently. 5. Which utilities can we used to export data from sql server to a text file?
A. DTS export wizard
B. BCP
C. ISQL
D. a and b
Answer:A
Explanation: In database systems, durability is the ACID property which guarantees that transactions that have committed will survive permanently. 5. Which utilities can we used to export data from sql server to a text file?
A. DTS export wizard B. BCP C. ISQL D. a and b
Explanation: The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. 6. You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?