Database security MCQs – Solved Questions Answers

25
Score: 0
Attempted: 0/25

1. When we update any tuple in the relation, which authorization on a relation allows a user to?
(A) Select authorization
(B) Update authorization
(C) Grant authorization
(D) Define authorization

2. Grants privileges on SQL authorization mechanism apply to:
(A) Entire relation
(B) Specified tuples
(C) Specified attributes
(D) Both A and B

3. Implicitly granted privileges to all users are called:
(A) Unnatural
(B) Private
(C) Natural
(D) Public

4. Which statement is used to revoke an authorization?
(A) Revoke
(B) Modify
(C) Alter
(D) Define

5. The SQL authorization mechanism doesn’t include:
(A) Specified attributes
(B) Specified tuples
(C) Entire relation
(D) None of the above

6. True dependencies generated in reflexive rule (IR1) are classified as:
(A) Nontrivial
(B) Inferential
(C) Functional
(D) Trivial

7. Rule stating that attributes determine any of its subsets is classified as:
(A) Closure rule
(B) Referential rule
(C) Reflexive rule
(D) Inferential rule

8. To represent both data and relationships among tables, the data model used is:
(A) Object-based Data model
(B) Entity-relationship model
(C) Relational model
(D) Semi-structured data model

9. Database structured record-based models are named so because of:
(A) Fixed format records
(B) Variable-format records
(C) Random-format records
(D) None of the above

10. In database design, the most widely used data model is:
(A) Semi-structured data model
(B) Object-based Data model
(C) Relational model
(D) Entity-relationship model

11. The entity-relationship model is mainly used in:
(A) Database implementation
(B) Database design
(C) Database direction
(D) Database processing

12. The record that contains all data regarding tuples is called:
(A) Environment record
(B) Statement record
(C) Connection record
(D) Description record

13. To list types of attributes in a query result, which type of iterator is used?
(A) Non-positioned iterator
(B) Positional iterator
(C) Named iterator
(D) Unnamed iterator

14. COBOL and ADA are programming languages classified as:
(A) Referential language
(B) Server language
(C) Client language
(D) Host language

15. PMS in procedures stands for:
(A) Prepared Storage Module
(B) Permanent Storage Module
(C) Persistent Storage Module
(D) Prepared Statement Module

16. The identification of a procedure name is used as:
(A) Initialization
(B) Arguments
(C) Attributes
(D) Values

17. Syntax like formatted and repeat statements are supported by:
(A) SQL:2003
(B) SQL:2000
(C) SQL:2001
(D) SQL:1999

18. The full form of CLR is:
(A) Computing Language Runtime
(B) Communication Language Runtime
(C) Common Language Runtime
(D) Conditional Language Runtime

19. A non-dense index is:
(A) Primary index
(B) Ternary index
(C) Secondary index
(D) Clustering index

20. The first record of any block in a data file is called:
(A) Non-dense record
(B) Anchor record
(C) Dense record
(D) None of the above

21. A row in a relational table is known as a:
(A) Tuple
(B) Relation
(C) Attribute
(D) Entity field

22. A relation instance in a relational model refers to a specific:
(A) Relation attribute
(B) Relation instance
(C) Relation entity
(D) Relation tuple

23. The primary data model used in commercial database systems today is the:
(A) Data program application
(B) Data management applications
(C) Data storage applications
(D) Data processing applications

24. Low-level data models are also called:
(A) Triggered data models
(B) Logical data models
(C) Conceptual data models
(D) Physical data models

25. In an E-R diagram, a specialization is represented by a:
(A) Dashed arrow-head
(B) Double arrow-head
(C) Hollow arrow-head
(D) Solid arrow-head

Database security MCQs – Solved Questions Answers
By: Prof. Dr. Fazal Rehman | Last updated: April 15, 2025

Related Posts:

Leave a Comment