QUESTION PAPER SET-1
Ques1- Write
core components of SQL Server? 3
Ques2- Write
type of SQL Statements? 3
Ques3- Write
Range operator.
2
Ques4- What
is the use of the ORDER BY clause, LIKE keyword &offsetfetch? 3
Ques5- What
is the use of the AGGREGATE function, ROLLUP & CUBE operators? 3
Ques6- Display
all territories whose name begin with ‘N’. 2
Ques7-
Display the details of the orders that have been placed by customers
online.
2
Que8-
Display the maximum, minimum and the average rate of the sales orders.
2
Ques9- What
is the use of the HAVING clause in group by. 2
Ques10.
Write shots notes on type of keys in sql. 3
QUESTION PAPER SET-2
Ques1- What is the use of the IN, IS NULL
& LIKE keyword? 3
Ques2- Write
Logical operator.
2
Ques3- what
is Literals?
2 Ques4- What is the use of the ORDER BY clause, Where clause &
offset-fetch? 3 Ques5- Write
types of data type in database. 3
Ques6- Write
type of SQL Statements? 3
Ques7-
Display the details of those stores that have Bike in their name.
2
Ques8-
Display the values of all the orders put together. 2
Ques9-
Display the total amount collected from the orders for each order date.
2
Ques10-
write short note RDBMS 3
No comments:
Post a Comment