Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What RDMS objects are created with the SQL CREATE statements?

The SQL CREATE statements are used to create the below objects:

Object

Description

STOGROUP        

 A storage group

DATABASE        

  A logical collection of tables

TABLESPACE    

 An area that stores tables

TABLE

A data structure organized by specified columns

INDEX

  An alternate path to a table data

VIEW

 An alternate representation of one or more tables

SYNONYM

An alternate name for local table or view

ALIAS 

 An alternate name for a table definition which may be local or remote, existence or nonexistent

 




Next 5 interview question(s)

1
How many types of Joins in SQL Server?
2
Explain the differences between char, nvarchar and varchar in SQL Server?
3
What is Index in SQL Server?
4
Explain SQL Server Index Optimization tips?
5
Explain different types of Locks in SQL Server?