TECH 540: 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. Answer questions (25%)

1. Who is a DBA? What are the responsibilities of a DBA? (7%)

2. What is a data model? List the types of data model used. (7%)

3. Please compare Data warehouse from Data Lake.(4%)

4. Please compare SQL from NoSQL database management system? (7%)

Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Liberty University
New Hampshire University
Strayer University
University Of Phoenix
Walden University
Home
Homework Answers
Blog
Archive
Tags
Reviews
Contact
twitterfacebook
Copyright © 2022 SweetStudy.comSWEETSTUDY.COM – YOUR HOMEWORK ANSWERS
chat0
Home.Literature.
Help.
Log in / Sign up
Final (Database Management)
profile
Cooper123

FinalExam_TECH540_2021.docx
Home>Computer Science homework help>Final (Database Management)
University of North America

Final Exam: TECH 540 – Database Management Systems – Fall 2021
Student name:

Part 1: Selection and Yes/No questions (75%, 3 points for each question)

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. Answer questions (25%)

1. Who is a DBA? What are the responsibilities of a DBA? (7%)

2. What is a data model? List the types of data model used. (7%)

3. Please compare Data warehouse from Data Lake.(4%)

4. Please compare SQL from NoSQL database management system? (7%)

Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Liberty University
New Hampshire University
Strayer University
University Of Phoenix
Walden University
Home
Homework Answers
Blog
Archive
Tags
Reviews
Contact
twitterfacebook
Copyright © 2022 SweetStudy.com