Reference no: EM133047492
Database Management Systems
Part 1: Selection and Yes/No questions
1. A collection of facts and figures is known to be as:
A. Data
B. Database
C. Sequenced data
D. Structured data
2. Logical structure of the database can be depicted through its
A. Domain
B. Data model
C. Architecture
D. Schemas
3. A database architecture that is considered highly modifiable is known as
A. ER database architecture
B. Object based architecture
C. 1 tier architecture
D. Multi-tier architecture
4. A tier in which the database resides along with the query processing languages is called
A. Application tier
B. Data tier
C. Presentation tier
D. Model tier
5. Type data abstraction which allows the conceptual representation of data in database management system is considered as
A. logical design model
B. data model
C. interface model
D. user friendly model
6. Identification, aggregation and instantiation are abstraction concepts used in
A. intension and extension models
B. classes and nodes models
C. concrete models
D. semantic data models
7. Process of abstraction in which the objects and classes are identified with some kind of identifier is classified as
A. classification
B. instantiation
C. identification
D. exception abstract
8. Application server in a three-tier architecture, communicates with a database system to access
A. Data
B. Query
C. Compiler
D. Retrieval
9. Business logic of the application says what actions to carry out under what conditions, is embedded in
A. Multiple servers
B. Multiple clients
C. Transaction server
D. Application server
10. Term that says what actions to carry out under what conditions, is known as the
A. Data logic
B. Business logic
C. Computing logic
D. File logic
11. Application resides at the client machine and invokes database system functionality at the server machine through query statement, is the type known as
A. One-tier architecture
B. Two-tier architecture
C. Three-tier architecture
D. NO-tier architecture
12. In the data model, the inherent constraints are classified as
A. flat constraints
B. parallel constraints
C. explicit constraints
D. implicit constraints
13. Type of constraint in which value of each attribute (X) must be an indivisible value from domain (X) is classified as
A. explicit constraint
B. implicit constraint
C. domain constraint
D. range constraint
14. In the data model schemas, the constraints that are expressed directly are classified as
A. explicit constraints
B. implicit constraints
C. flat constraints
D. parallel constraints
15. Constraint which is used to specify the consistency in two or more relations among tuples is classified as
A. primary integrity constraint
B. entity integrity constraint
C. referential integrity constraint
D. null integrity constraint
16. Database user assigns entities to a given entity set, in the type of generalization's constraints
A. Data-defined
B. User-defined
C. System-defined
D. Condition-defined
17. By default, the generalization type applied is
A. Dependent specialization
B. Partial specialization
C. Complete specialization
D. Total specialization
18. An abstraction through which relationships are treated as higher-level entities, is known as
A. Aggregation
B. Tabulation
C. Simulation
D. Patriotization
19. the user-defined constraints on generalization, the lower level entity sets can be of type
A. 2 types
B. 3 types
C. 4 types
D. 5 types
20. Like attribute inheritance, the inheritance that applies through all tiers of lower-level entity sets, is known to be
A. Participation inheritance
B. Execution inheritance
C. Existence inheritance
D. Dependency inheritance
21. In database management systems, the record which contains all the data regarding tuples of database is called
A. statement record
B. environment record
C. description record
D. connection record
22. Type of iterator which is used to list the types of attributes that are included in the query result is called
A. positional iterator
B. named iterator
C. unnamed iterator
D. non-positioned iterator
23. Variable in DBMS used to communicate error conditions between database management system and program are
A. SQLCODE
B. SQLSECTION
C. SQLSTATE
D. both b and c
24. In database management system, if the cursor is to be moved to next rows in queries result then the command is classified as
A. OPEN CURSOR command
B. FETCH command
C. UPDATE command
D. CLOSE CURSOR command
25. General purpose programming languages such as COBOL and ADA is classified as
A. server language
B. client language
C. host language
D. referential language
Part II.
1. Who is a DBA? What are the responsibilities of a DBA?
2. What is a data model? List the types of data model used.
3. Compare Data warehouse from Data Lake.
4. Compare SQL from NoSQL database management system?