Which data type should you use?

Correct Answer for the following Question is given below

You are a database developer. You plan to design a database solution by using SQL Server 2008.The database will contain a table to stage data from an external source. The imported data will contain a field named TransactionTime. The TransactionTime field will use the hh:mm:ss.[n] format (such as 12:55:30.1).You need to select the appropriate data type for the TransactionTime field. You need to achieve this goal by incurring the minimum amount of storage cost.Which data type should you use?time [ (fractional second precision) ] defines a time of a day in hh:mm:ss[.nnnnnnn] format. The time is without time zone awareness and is based on a 24-hour clock. (Range is 00:00:00.0000000 through 23:59:59.9999999) fractional seconds precision specifies the number of digits for the fractional part of the seconds. This can be an integer from 0 to 7. The default fractional precision is 7 (100ns).In the current scenario, the TransactionTime field will use the hh:mm:ss.[n] format (such as 12:55:30.1). So we need to use 1 as a fractional seconds precision.

Question:

Which data type should you use?

Options:

time

smalldatetime

datetime2

time(1)

Correct Answer

The Correct Answer for this Question is

time(1)

Explanation

The Question – Which data type should you use? has been answered correctly and answers for the question is time(1)

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *