Database Management System Questions Answers pdf - Set 06 - ObjectiveBooks

Database Management System Questions Answers pdf - Set 06

Practice Test: Question Set - 06

1. In an Entity-Relationship Diagram “Diamonds” represents
    (A) Attributes
    (B) Multi-valued attributes
    (C) Weak entity set
    (D) Relationship sets

2. Which algebra is widely used in DBMS?
    (A) Relational algebra
    (B) Arithmetic algebra
    (C) Both
    (D) None

3. How many types of keys in Database Design?
    (A) Candidate key
    (B) Primary key
    (C) Foreign key
    (D) All of these

4. ________ is a classical approach to database design?
    (A) Left – Right approach
    (B) Right – Left approach
    (C) Top – Down approach
    (D) Bottom – Up approach

5. A database management system might consist of application programs and a software package called
    (C) BPL
    (D) TOTAL

6. When using a database management system, the first thing that you must do is to
    (A) Create a database file
    (B) Activate file editor
    (C) Load the software into your micro-computer
    (D) Keep a floppy disk in readiness

7. If a calculation is embedded in a form
    (A) The result of the calculations are stored with the form
    (B) The calculations are stored with the form
    (C) The result of the calculations are printed in report
    (D) All of the above

8. A multiple-form file management system
    (A) Lets you define different forms for different operations
    (B) Lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
    (C) Both (a) and (b)
    (D) Allow you to entry data in all the forms

9. The logical data structure with a one-to-many relationship is a:
    (A) Network
    (B) Tree
    (C) Chain
    (D) Relational

10. Administrate supervision of database activities is the responsibility of the
    (A) Database administrator
    (B) DP Manager
    (C) DB Manager
    (D) DP administration

11. A scheme describes
    (A) Data elements
    (B) Records and files
    (C) Record relationships
    (D) All of the above

12. Data security threats include
    (A) Hardware failure
    (B) Privacy invasion
    (C) Fraudulent manipulation of data
    (D) All of the above

13. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
    (A) DASD
    (B) FMS
    (C) EMMS
    (D) DBMS

14. The database administration function includes
    (A) Application programming
    (B) Computer operations management
    (C) Database access planning
    (D) All of the above

15. In SQL, which command is used to add a column/integrity constraint to a table

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: