Advantages of using a DMBS approach

What are the problems this example pose to the business operations?

1 pts

volume_mute

In a university, the course registration personnel and the accounting office are processing the students details in two separate excel sheets. Each group has its own version of the students. The accounting office keeps data on registration and related billing information, whereas the registration office keeps track of student courses and grades. Other groups may further duplicate some or all of the same data in their own files.

Increased network traffic

Duplication of effort, wasted storage, and potential data inconsistency

Slower processor speed

Incompatibility with object-oriented programming languages

note_alt Add notes

flag Flag

Correct Answer

Explanation

In the ideal database approach, data normalization means every logical data item is stored in exactly one place in the database.

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

Correct Answer

Explanation

Redundancy control

1 pts

The practice of intentionally introducing redundancy to improve query performance is called (1). The DBMS must then have mechanism to (2) this redundancy to prevent inconsistencies.

Please drag and drop the selected option in the right place or type it instead

control

denormalization

note_alt Add notes

flag Flag

Correct Answer

Explanation

Identify the inconsistency between the two tables

1 pts

volume_mute

These two tables have been purposely kept redundant to improve query peformance. However, the DBMS controls were not effective. Can you identify which attribute is inconsistent?

STUDENT TABLE

number	name	class	major
17	Smith	1	CS
8	Brown	2	CS

GRADE REPORT TABLE

number	name	identifier	course	grade
17	Brown	112	MATH2410	B

The student number is 17

The student name is 'Brown'

The Grade is 'B'

The course number is 'MATH2410'

note_alt Add notes

flag Flag

Correct Answer

Explanation

Classify the following tasks as either the responsibility of the DBA or a function of the DBMS

1 pts

drag and drop the selected option to the right place

note_alt Add notes

flag Flag

Correct Answer

Explanation

What is the main advantage of object-oriented database systems (OODBMS) in terms of program data?

1 pts

volume_mute

They are always faster than relational databases

They automatically perform conversions between complex program objects and a storable format

They eliminate the need for a database administrator (DBA)

They only work with the Java programming language

note_alt Add notes

flag Flag

Correct Answer

Explanation

The "impedance mismatch" problem refers to the incompatibility between the data structures of a programming language and those provided by a traditional DBMS

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

Correct Answer

Explanation

Speeding up storage search

1 pts

To speed up disk searches, the DBMS uses auxiliary files called (1), which are often based on tree or (2) data structures. The (3) module is responsible for maintaining parts of the database in main memory buffers.

Please drag and drop the selected option in the right place or type it instead

buffering or caching

indexes

hash

note_alt Add notes

flag Flag

Correct Answer

Explanation

Who is primarily responsible for choosing which indexes to create and maintain as part of physical database design?

1 pts

volume_mute

The Application Programmers

The Operating System

The End-Users

The Database Administrator (DBA) staff

note_alt Add notes

flag Flag

Correct Answer

Explanation

The backup and recovery subsystem ensures that if a computer system fails during a transaction, the database is restored to the state it was in after the transaction partially completed

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

Correct Answer

Explanation

Match the type of user with the most appropriate interface provided by a DBMS

1 pts

To complete the line match

Click on an item in the first group
Click on the match in the second group

To delete a match, double click on a line

User Type

Application Programmer

Casual User

Parametric User

Standalone User

DBMS Interface

Forms and Command Codes

Programming Language Interfaces

Menu-driven or Natural Language Interfaces

Query Languages

note_alt Add notes

flag Flag

Correct Answer

Explanation

What is the relationship type?

1 pts

volume_mute

A key capability of a DBMS is to easily represent and retrieve data based on complex relationships. In a UNIVERSITY database, a single STUDENT record is related to multiple GRADE_REPORT records.

This is an example of what kind of relationship?

A one-to-one relationship

A redundant relationship

A one-to-many relationship

A many-to-many relationship

note_alt Add notes

flag Flag

Correct Answer

Explanation

Which of the following are types of integrity constraints a DBMS can enforce?

1 pts

volume_mute

Specifying that a `Class` data item must be an integer between 1 and 5

Ensuring that every `SECTION` record must be related to a `COURSE` record (referential integrity)

Rejecting a grade of 'Z' because it is not a valid letter grade

Automatically detecting that a entered grade of 'C' was a mistake and should have been an 'A'

note_alt Add notes

flag Flag

Correct Answer

Explanation

Constraints and Rules

1 pts

Constraints that are derived from the meaning of the data and its environment are often called (1). Rules that are fundamental to a specific data model, like a relationship involving two entities, are called (2) rules of the data model.

Please drag and drop the selected option in the right place or type it instead

inherent

business rules

note_alt Add notes

flag Flag

Correct Answer

Explanation

What is a key advantage of using declarative rules in a deductive database system over writing procedural code?

1 pts

volume_mute

Declarative rules execute much faster

It is easier to change the rules if the requirements of the miniworld change

Declarative rules do not require a DBMS to function

They are only useful for financial data

note_alt Add notes

flag Flag

Correct Answer

Explanation

A trigger is a procedure that is automatically executed by the DBMS in response to specified events, such as updates to a table

1 pts

volume_mute

True

False

note_alt Add notes

flag Flag

Correct Answer

Explanation

Which of the following are listed as additional advantages of the database approach?

1 pts

volume_mute

Reduced Application Development Time

Increased Hardware Costs for individual departments

Availability of Up-to-Date Information

Potential for Enforcing Standards

Decreased Flexibility for changes

note_alt Add notes

flag Flag

Correct Answer

Explanation

The "Economies of Scale" advantage suggests that the database approach leads to

1 pts

volume_mute

Each department buying its own specialized, high-cost equipment

Consolidation that reduces wasteful overlap and allows the organization to invest in more powerful, centralized resources

A need for less technical knowledge among database users

The requirement for all data to be stored redundantly

note_alt Add notes

flag Flag

What are the problems this example pose to the business operations?

Correct Answer

Explanation

In the ideal database approach, data normalization means every logical data item is stored in exactly one place in the database.

Correct Answer

Explanation

Redundancy control

Correct Answer

Explanation

Identify the inconsistency between the two tables

Correct Answer

Explanation

Classify the following tasks as either the responsibility of the DBA or a function of the DBMS

drag and drop the selected option to the right place

Correct Answer

Explanation

What is the main advantage of object-oriented database systems (OODBMS) in terms of program data?

Correct Answer

Explanation

The "impedance mismatch" problem refers to the incompatibility between the data structures of a programming language and those provided by a traditional DBMS

Correct Answer

Explanation

Speeding up storage search

Correct Answer

Explanation

Who is primarily responsible for choosing which indexes to create and maintain as part of physical database design?

Correct Answer

Explanation

The backup and recovery subsystem ensures that if a computer system fails during a transaction, the database is restored to the state it was in after the transaction partially completed

Correct Answer

Explanation

Match the type of user with the most appropriate interface provided by a DBMS

User Type

DBMS Interface

Correct Answer

Explanation

What is the relationship type?

Correct Answer

Explanation

Which of the following are types of integrity constraints a DBMS can enforce?

Correct Answer

Explanation

Constraints and Rules

Correct Answer

Explanation

What is a key advantage of using declarative rules in a deductive database system over writing procedural code?

Correct Answer

Explanation

A trigger is a procedure that is automatically executed by the DBMS in response to specified events, such as updates to a table

Correct Answer

Explanation

Which of the following are listed as additional advantages of the database approach?

Correct Answer

Explanation

The "Economies of Scale" advantage suggests that the database approach leads to

Correct Answer

Explanation

Quran Recitation

Query Dictionary

Select a result: