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
