Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What is the syntax for a CREATE TABLE statement?

CREATE TABLE table name (column name list primary key (column name)) in database-name, tablespace-name.

Syntax:

CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );?

CREATE TABLE is the keyword in DB telling the database system what you want to do.




Next 5 interview question(s)

1
What RDMS objects are required before you can create a table?
2
What RDMS objects are created with the SQL CREATE statements?
3
How many types of Joins in SQL Server?
4
Explain the differences between char, nvarchar and varchar in SQL Server?
5
What is Index in SQL Server?