QUESTION NO: 1
Which of the following datatypes has a fixed precision and a scale of six digits?
A. DoubleB. Money
C. Int
D. Numeric
E. SmallInt
F. VarInt
G. Float
Answer: B
QUESTION NO: 2
You are employed as a SQL Server 2012 database developer at ABC.com. ABC.com has a database named HRDB with tables named Staff and SalaryHistory. The Staff and Salary History tables were created using the following Transact-SQL code: CREATE TABLE HRDB.Staff(StaffID int NOT NULL PRIMARY KEY,FirstName nvarchar(50) NOT NULL,LastName nvarchar(50) NOT NULL,JobTitle...
