DBMS Miscellaneous Questions

Q.1. Consider the following relational database:
STUDENT (name, student#, class, major)
COURSE (course name, course#, credit hours, department)
SECTION (section identifier, course#, semester, year, instructor)
GRADE_REPORT (student#, section identifier, grade)
PREREQUISITE (course#, presequisite#)
Specify the following queries in SQL on the above database schema.
(i) Retrieve the names of all students majoring in ‘CS’ (Computer Science).
(ii) Retrieve the names of all courses taught by Professor King in 1998.
(iii) Delete the record for the student whose name is ‘Smith’ and whose student number is 17.
(iv) Insert a new course <’Knowledge Engineering’, ‘CS4390’, 3, ‘CS’>

(v)Select all the Students who score ‘O’ Grade.
(vi) Sort all the students in ascending order by course and within course descending order by their name.
(vii) list out the maximum and minimum grade.
(viii) Display the name of student who has top grade.
(ix) Display all the students semV.
(x) Display the students who opt for 'Computer Engg' Course.

Q.2. Given the following relations
TRAIN (TNAME, START, DEST)
TICKET (PNRNO.,TNAME, START, DEST, FARE)
PASSENGER (NAME, ADDRESS, PNRNO.)
Write SQL expressions for the following queries:
Note: Assume NAME of Train is a column of Ticket.
(i) List the names of passengers who are travelling from the start to the destination station of the train.
(ii) List the names of passengers who have a return journey ticket.
(iii) Insert a new Shatabdi train from Delhi to Bangalore.
(iv) Cancel the ticket of Tintin.
(e) Define view with example.

Q.3. Consider the job database described above (the primary keys are underlined) and write SQL queries for the following:

(1) employee(employeename, street, city)

(2) works(employeename, company_name, salary)

(3) company(companyname, city)

(4) manages(employeename, manager_name)

(1) Find the names of all employees who work for First Bank Corporation.

(2) Find the names of all employees in this database who live in the same city as the company for which they work.

(3) Find the names of all employees who live in the same city and on the same street as their managers.

(4) Find the company with the smallest payroll.

(5) Find the employees who earn more than the average salary of all the employees at their company.

(6) Find the names of all employees who do not have a manager.

Miscellaneous Questions

2Marks

1.       State characteristics of a good MIS?

2.       What is a computer based Information System?

3.       What is a business process?

4.       Define MIS ? write goal of MIS?

5.       Define Data Governance , Master Data and Transactional Data?

6.       Define Data, Information and Knowledge with example?

7.       What is a knowledge Management?

8.       illustrate with example ER Diagram?

9.       What is the difference between Tacit knowledge and explicit knowledge?

10.   Explain in Brief Data warehouse and data mart?

11.   Describe the issue of privacy as it is affected by IT?

12.   Differentiate among threat and vulnerability?

5Marks

1.       Describe the components of Computer-Based Information System?

2.       Descibe the cross functional business process, and provide several example of such processes?

3.       Discuss ways that common challenges in managing data can be addressed using data governance?

4.       Describe the benefits and challenges of implementing knowledge management systems in organizations?

5.       Describe how company can use Big data to gain competitive advantage?

6.       Compare and contrast human mistakes and social engineering, and provide a specifi c example of each one?

7.       Write Business intelligence application for presenting Results?

8.       Write Ethical issue and privacy?

9.       Discuss different types of deliberate attacks?

MIS Chapter wise Questions

Chapter 1

2 Marks/Short Questions 

1. What is data?
2. What is information?
3. What is MIS? What are the goals of MIS?
4. State and explain any five characteristic of a good Management Information System?
5. How data differ from information?
6. How data transform into information?
7. What is a computer based Information System?
8.  Mention major capabilities of Information System?
9. Discuss some disadvantages of (a) telepresence robots; (b)autonomous cars; and (c) drones.
10. Can the terms data, information, and knowledge have different meanings for different people?
11. What is a business process?
12. What are the strategic information system?
13. 
    
14. 
    

5/10 Marks

1. Describe the components of Computer-Based Information System?
2. Explain how information system provide support for knowledge worker?
3. How does IT impact organisation?
4. Discuss several ways in which IT impact IT impact employees at work?
5. Describe How IT might change the manager Job?
6.  Describe the various types of computer-based information systems in an organization?
7. Discuss Importance of Information Systems to Society?
8. List down the types of support provided by Accounting IS, finance IS, production/operations management (POM) IS, marketing IS, and human resources IS?
9. Describe the several business process carried out at  (eg. University)?
10. Descibe the cross functional business process, and provide several example of such processes?
11. Pick any one process identify its inputs, outputs,customers, and resources . How does a process create value of its customer?
12. What is a business process reengineering?
13. What is a business process improvement?
14. What is a business process management?
15. What strategy company use to get competitive advantage?
16. Discuss some of the pressure that characterizes the modern global business environment?
17.   

Chapter 2

2 Marks/Short Questions 

1. What is a business intelligence?
2. What are the difficulties involved in managing the data?
3. Define Data Governance , Master Data and Transactional Data?
4. What is a data model?
5. What is a primary key and secondary key?
6. What is a Foreign key?
7. What is an Entity and an Attribute?
8. What are the benefits of data Dictionary?
9. Desricbe how structured query language works?
10. What is a knowledge Management?
11. What is the difference between Tacit knowledge and explicit knowledge?
12. What are the problems associated with poor-quality data? 
13. Describe multi dimensional analysis?
14. Whats a real time BI?

5/10 Marks

1. Discuss ways that common challenges in managing data can be addressed using data governance?
2. Define Big Data, and discuss its basic characteristics?
3. Explain how to interpret the relationships depicted in an entity-relationship diagram?
4. Discuss the advantages and disadvantages of relational databases?
5. Explain the elements necessary to successfully implement and maintain data warehouses?
6. Describe the benefits and challenges of implementing knowledge management systems in organizations?
7. Describe how company can use Big data to gain competitive advantage?
8. Differentiate between data warehouse and data mart?
9. Describe the characteristics of a Data warehouse?
10. What are three possible architectures for data warehouses and data marts in an organisation?
11. Describe the knowledge management system cycle?
13. What are the implications of having incorrect data points in your Big Data? What are the implications of incorrect or duplicated customer data? How valuable are decisions that are made based on faulty information derived from incorrect data?
14. Explain the difficulties involved in managing data?
16. What is master data management? What does it have to do with high-quality data?
17. Describe the business management approach proposed by Simon?
19. Provide examples of different ways that organizations make use of business intelligence (BI).
21. Explain the value that different BI applications provide to large and small businesses?
22. Identify and Discuss three basic targets of BI?
23. Discuss the breadth support provided by the BI applications to organisational employee?
24. What are the two basic operation of data mining?
25. What is the purpose of DSS?
26. What is a Dashboard? Why are Dashboard so valuable to employee?
27. Discuss the strategic benefits of BI systems.

Chapter 3

2 Marks/Short Questions 

1. What does a code of Ethics contain?
2. Describe the fundamental tenets of ethics?
3. Describe the issue of privacy as it is affected by IT?
4. Discuss how privacy issue can impact transborder data flows? 
5. How important are backup plans and fi le backup procedures to small businesses?
6. Why is it important to protect customer information in businesses of any size?
7. Define Information security?
8. Differentiate among a threat ,an exposure and a vulnerability?
9. Why are skill needed to be a hacker are decreasing?
10. What is an unintentional threat to an information system?
11.  

5/10 Marks

1. Define ethics, list and describe the three fundamental tenets of ethics, and describe the four categories of ethical issues related to information technology.
2. Identify three places that store personal data, and for each one, discuss at least one potential threat to the privacy of the data stored there? 
3. Identify the five factors that contribute to the increasing vulnerability of information resources, and provide a specific example of each one? 
4. Compare and contrast human mistakes and social engineering, and provide a specifi c example of each one?
5. Discuss the ten types of deliberate attacks? 
6. Define the three risk mitigation strategies, and provide an example of each one in the context of owning a home? 
7. Identify the three major types of controls that organizations can use to protect their information resources, and provide an example of each one?
8. What is a single most important information security control for an organisation?
9. Compare and contrast whitelisting and blacklisting?
10.