PrepAway - Latest Free Exam Questions & Answers

You need to design tables and other database objects.You need to store media files in several tables

You develop a database for a travel application. You need to design tables and other database objects.You
need to store media files in several tables. Each media file is less than 1 MB in size. The media files will require
fast access and will be retrieved frequently. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the CAST function.

B.
Use the DATE data type.

C.
Use the FORMAT function.

D.
Use an appropriate collation.

E.
Use a user-defined table type.

F.
Use the VARBINARY data type.

G.
Use the DATETIME data type.

H.
Use the DATETIME2 data type.

I.
Use the DATETIMEOFFSET data type.

J.
Use the TODATETIMEOFFSET function.

Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms188362.aspx

17 Comments on “You need to design tables and other database objects.You need to store media files in several tables

  1. Renda Aragus says:

    Great site you have here but I was wanting to know if you knew of any discussion boards that cover the same topics talked about here? I’d really love to be a part of community where I can get responses from other experienced people that share the same interest. If you have any suggestions, please let me know. Thanks a lot!|

    http://www.dJCaruwC1t.com/dJCaruwC1t




    0



    0

Leave a Reply