Thursday, November 5, 2015

SQL quespaper

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