SQL Server Data definition language interview questions
Define Data definition
What are the capabilities of Cursors?
SQL Server Data definition language - Nov 18, 2008 at 15:30
pm by Rajmeet Ghai
Define Data definition language.
A Data Definition language is a computer language. It defines how can
data be stored efficiently. All the commands used to create, delete databases
like CREATE or DELETE are a part of data definition language.
Explain the command Create Table, Alter Table and Drop Table with
Create table: Used to create a table in sql. Tables store the
data. Each row in a table has a unique identifier called as a primary key.
CREATE TABLE table_name (
PRIMARY KEY (Column_name1));
CREATE TABLE customer (
Last name varchar(200)
Explain Data Definition Language, Data Control Language and Data
Data Definition Language (DDL)
Data Control Language
Data Manipulation Language
Answer - Stored procedures provide performance
benefits through local storage, precompiling the code, and
Answer - Shared Lock allows
simultaneous access of record by multiple Select statements. Shared
Lock blocks record from updating and will remain in queue waiting
while record is accessed for reading......
Answer - Column with identity
property contains unique system generated value in the table. Column
with identity property is similar to AutoNumber field in MS
Answer - Master database is system
database. It contains information about server’s configuration. It
is a very important database and important to backup