Database - Sample Questions

 1) One of the goals of database management is to secure information against system failure or tampering. Discus.

2) Give an example of data integrity problems.

 Define the following terms: (i) database, (ii) DBMS, (iii) entities and

    relationships (iv) backup and recovery and (v) transaction processing

    application.        

3) (a) What are the main types of action involved in databases?      

    (b) Briefly discuss each.       

    (c) Discuss the capabilities that should be provided by a DBMS.    

4)

(a) What is a file?

(b) What are the terms commonly used in discussing structure of a file?

(c) How can you distinguish one file from another?

(d) What do you understand by file attributes?

(e) List out and describe the attributes a file could possess.

5) (a)What is file organization?

(b)What is the relationship between file organization and access method?

(c) What are the important issues to consider when selecting a file organization?

6) (a) What is a file management system?

(b) What are the objectives of a file management system?

(c) List the different operations supported by a file management system.

7)

(a) Define the following terms: (i) data model (ii) database schema (iii) DDL (iv) DML

        (v) query language  

        (b) Discuss the main characteristics of the database approach and how it differs from the   

         traditional file systems.

8) A. Explain directory structure and its practical applications.   

B. What is the difference between absolute pathname and relative pathname?   

C. List some of the strategies that can be used in free space fragmentation.

 9) A. How can access to files in networked environment be controlled?

B. Differentiate between the following with regards to files operations:   

           (i) Truncating (ii) deleting

C. Outline and discuss briefly the various access rights that can be granted to a file user.

 

 

 

 

 

 

 

Comments

Post a Comment

Popular posts from this blog

Osun State University in Collaboration with British Computer Society

is offering   The British Computer Society Chartered Institute of IT Professionals Foundation in Business Analysis On successfully passing the examination, candidates will be awarded the Chartered Certificate of the Foundation in Business Analysis Candidates will also be awarded Associate Membership of the Chartered IT Professional (CITP) Registration is on !!! Registration can be made through the following link   https://docs.google.com/forms/d/e/1FAIpQLSc95O9kEpLfxtqpwV5ofhS-qVv3AlDk7T2SfVRRMm829-VKEw/viewform Note: F ee offered by Osun State University is very much less than the amount offered by the body in the UK. T his is because UNIOSUN is an accredited training provider (ATP). Examination date: September 28, 2020 Examination is online based accessible through individual computers Lecture materials can be obtained by enquiring email: patrick.ozoh@uniosun.edu.ng There are periodic classes on Skype Send enquiry to patrick.ozoh@uniosun.edu.ng  
Read more

Database PowerPoint Presentation Lectures by Dr Patrick Ozoh Dept of ICT Osun State University

A transaction is a sequence of DML commands that forms a logical unit of work Example: transferring money from one bank account to another Transaction Management A transaction is a sequence of DML commands that forms a logical unit of work Example: transferring money from one bank account to another Some Definitions Atomicity - a transaction must execute completely or not at all Consistency - once a transaction completes successfully, the database must be in a consistent state Isolation: A transaction must not be affected by other transactions that are executing concurrently Durability: Once a transaction compketes successfully, its effect must persist even in the presence of system failures Concurrency control Concurrency control is a database management systems (DBMS) concept meant to coordinate simultaneous transactions while preserving data integrity. Control protocols ensures atomicity, isolation, and serializability of concurrent transactions Concurrency control protoc
Read more

Osun State University in Collaboration with British Computer Society

Become a BCS Associate member for free on gaining a certification and enjoy all the benefits of membership Gain an internationally- recognized  certification, enabling you to take your skills around the world Map your skills and identify your goals along your career path by following the SFIAplus industry-standard framework Get certified !!! The British Computer Society Chartered Institute of IT Professionals Foundation in Business Analysis Register using the following link https://docs.google.com/forms/d/e/1FAIpQLSc95O9kEpLfxtqpwV5ofhS-qVv3AlDk7T2SfVRRMm829-VKEw/viewform Lecture materials can be accessed freely by joining the following link https://chat.whatsapp.com/9n1rTFD8dM97pLYJVEZQec  
Read more