CS8492 Question Paper Database Management Systems
CS8492 Question Paper Database Management Systems Regulation 2017 Anna University free download. Database Management Systems Question Paper CS8492 pdf free download.
Sample CS8492 Question Paper Database Management Systems:
1. What is a view? How can it be created? Explain with an example.
2. Discuss in detail the operators SELECT, PROJECT, UNION with suitable
examples.
3. Explain static and dynamic SQL in detail.
4. Diagrammatically illustrate and discuss the steps involved in processing a query. CS8492 Question Paper Database Management Systems
5. Give briefly about Query evaluations cost & Selection operation
6. How does a DBMS represent a relational query evaluation plan?
7. Since indices speed query processing, why might they not be kept on several search CS8492 Question Paper Database Management Systems
keys? List as many reasons as possible.
8. Consider the database given by the following schemes.
Customer (Cust_No, Sales_ Person_No ,City)
Sales_ Person(Sales_ Person_No
,Sales_ Person_Name,
Common_Prec,Year_of_Hire)
Give an expression in SQL for each of the following queries:
Display the list of all customers by Cust_No with the city in which each is
located. Select Cust No, city from Customer
List the names of the sales persons who have accounts in Delhi.
Select Sales_Person_Name from Sales_Person_Name where( select * from
customer where city = delhi) CS8492 Question Paper Database Management Systems
9. Write short notes on the following:
Data Manipulation Language (DML), Data Definition Language
(DDL) Transaction Control Statements (TCS),Data Control
Language (DCL) CS8492 Question Paper Database Management Systems
10. Consider the employee database , where the primary keys are Underlined.
employee(empname,street,city) works(empname,companyname,salary)
company(companyname,city)
manages(empname,management)
Give an expression in the relational algebra for each request.
1) Find the names of all employees who work for First Bank Corporation.
2) Find the names, street addresses and cities of residence of all employees who work for First Bank Corporation and earn more than 200000 per annum.
3) Find the names of all employees in this database who live in the same city as the company for which they work. CS8492 Question Paper Database Management Systems
4) Find the names of all employees who earn more than every employees of small Bank Corporation.
| Subject name | Database Management Systems |
| Short Name | DMS |
| Semester | 4 |
| Subject Code | CS8492 |
| Regulation | 2017 regulation |
CS8492 Database Management Systems Question Paper Click Here To Download
CS8492 Database Management Systems Important Questions
CS8492 Database Management Systems Syllabus
CS8492 Database Management Systems Notes