Download Mobile APP to get Instant Free Job Alert on your Mobile

.Net Interview questions home

What is table and what are the items to consider while creating table in SQL Server?
Tables are basic building blocks of Database. Tables will be used to store data in to database.

Points to remember while creating table in SQL Server
• You should be able to separate data in to different columns in table and assign corresponding data types to those columns.
• The amount of space consumed on disk
• The amount of memory consumed when processing data
• The queries required to manipulate the data for application use

What are the different data types available in SQL Server?
Numeric: Stores numeric values.
Monetary: It stores numeric values with decimal places. It is used specially for currency values.
Data and Time: It stores date and time information.
Character: It supports character based values of varying lengths.
Binary: It stores data in strict binary (0 or 1) Representation.
Special purpose: SQL Server contains Complex data types to handle the XML Documents, Globally unique identifiers etc.

What are the specialized data types in SQL Server?
bit :Stores a 0, 1, or null. Used for basic “flag” values.
TRUE is converted to 1, and FALSE is converted to 0.

Timestamp: An automatically generated value. Each database contains an internal counter that designates a relative time counter not associated with an actual clock. A table can have only one time stamp column, which is set to the database timestamp when the row is inserted or modified.

Uniqueidentifier: A 16-bit GUID used to globally identify a row across databases, instances, and servers.

sql_variant: It can change the data type based on the data that is stored within it.

Cursor: Cursor is used by applications that declare cursors. It contains a reference to the cursor that can be used for operations. This data type cannot be used in a table.

Table: It is used to hold a result set for subsequent processing. This data type cannot be used for a column. The only time you use this data type is when declaring table variables in triggers, stored procedures, and functions.

Xml: It stores an XML document of up to 2 GB in size. You can specify options to force only well-formed documents to be stored in the column.

SQL Server Interview Questions

.Net Interview questions home

Advertisements

Tags: basic sql server interview questions and answers, create table, create table sql, SQL Server, sql server interview questions, sql server interview questions and answers, sql server interview questions and answers for developers, sql server interview questions and answers for freshers, sql server interview questions and answers for testers

Responses to “SQL Server interview questions | create table”

  • anil rajak says:

    Very useful

  • Preeti says:

    This is really very useful specially for freshers.. thank you

  • Krishna Kumar says:

    If you want a good job then join the free job alert.com.

  • hafiz says:

    Superb.

  • SATYANARAYANA says:

    THIS INFORMATION SI REALLY USEFUL AND THANKS TO SUBJECT DETAILS.

  • Arti jhariya says:

    This is very useful for us

  • Trishala says:

    such proper opportunity for students.Thanks alot

  • Madhu says:

    @prateek

    1.To get latest recruitment updates visit regularly https://www.freejobalert.com
    (or)
    2.To get daily free SMS alerts for all Government/Sarkari Naukri jobs, Bank jobs, Engineering jobs, Police and Defence jobs, Teaching jobs and other Govt jobs on your mobile send SMS as “ON GOVTJOBSALERT” to 9870807070. Make sure you give SPACE after ON.
    (or)
    3.To get daily E-mail alerts on Jobs enter your E-mail ID at right side top corner of the page and click on SUBSCRIBE button.

  • PRATEEK KUMAR says:

    I am Prateek Kumar I have done MCA. So, I am searching php developers degination Job in India I am fresher candidate for php developer, please inform me for the openings

  • neelu says:

    good info. Is given here….but it’s not enough as there is much more to learn to learn interview…

  • umesh kumar says:

    be honest

Leave a Reply


Share:
Free E-mail Job Alerts
Enter your email address: 
STATE JOB NOTIFICATIONS