SQL Server Data manipulation language interview questions
Define Data manipulation
Explain the command
Select, Insert, Update and Delete with syntax.
SQL Server Data manipulation language- Nov 18, 2008 at 15:30 pm
by Rajmeet Ghai
Define Data manipulation language.
Data manipulation language is used for managing data. Managing data
would mean retrieving, inserting, deleting or updating data. SQL is the most
common data manipulation language. SELECT, INSERT, UPDATE keywords are a part
of Data manipulation language. Data manipulation language can be procedural or
Explain the command Select, Insert, Update and Delete with syntax.
a. Select: Select statement is used to select data
from a table.
For selecting all columns
Select * from table_name
Select * from customer;
b. Insert: Insert statement is used to insert data (row) in a
Insert into table_name
Values (value1, 2 ..)
Insert into customer values (1,’steve’,’james’);
c. Update: Update statement is used to update existing data
(row) in a table. It is used to update some column value by specifying a
Update table_name Set column_name1= ‘value’, column_name2=’value2’
Update customer Set first_name=’john’ Where last_name=’james’;
Define Data control language, Explain the command Grant, Revoke
and Deny with syntax.............
Define Data definition language, What are the capabilities of
Explain Data Definition Language, Data Control Language and Data Manipulation
Answer - The start and end of each transaction......
Answer - Data definition language is used to
define and manage all attributes and properties of a
Answer - Null means no entry has been made. It implies that the
value is either unknown or undefined.....