Fundamentals of Database System

UGRD-ITE6100B Fundamentals of Database System
(Prelim Q1, Q2, PreLim)

This course introduces the basic concepts needed for designing, implementing, and using database applications and database systems. It focuses on the fundamentals of database modeling and design, models and languages of database management system and techniques on how to implement database system.

Question text

We call the database and DBMS software together as a .

Question text

Physical data models is a concept that shows how the data is stored on the computer.

Select one:
 

Question text

It is between high-level and low-level data models.

Question text

Database System automatically takes care of backup and recovery.

Select one:
 

Question text

There’s no difference between the description of database and the database itself.

Select one:

Question text

People whose jobs require access to the database for querying, updating, and generating reports.

Question text

Data Manipulation Language is use for manipulating data in a database.


Select one:
 

Question text

Data model is a collection of concepts that is used to describe the structure of a database.

Select one:
 

Question text

Controlling Redundancy is used to improve the performance of queries.


Select one:
 

Question text

Data abstraction is the data type, relationships and constraints that apply to the data.

Select one:

Question text

Internal Level describes the physical storage structure of the database.

Select one:
 

Question text

A displayed schema is called Schema figure.


Select one:

Question text

Who is responsible in administering the primary and secondary resource in the database?

DBM/Database Administrators (Incorrect)

Question text

It is a collection of related data.

Question text

A computerized system that permits users to create and maintain a database.

Question text

Facts that can be recorded and that have implicit meaning.

Question text

It is a question or an inquiry, sometimes loosely used for all types of interactions with databases.

Question text

Attribute is a name for a set of similar things that you can list.  Like objects, events, people.


Select one:

Question text

Describes how entities are related.

Question text

They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data.

Question text

Entity Instance is an instance of a particular entity.


Select one:
 

Question text

Logical Design – transforming the ERD into relational model.


Select one:
 

Question text

Composite attribute can be divided into more attributes.


Select one:
 

Question text

For each entity instance the value of the identifier attribute is Unique.


Select one:
 

Question text

Matching Type Test

Used to performed or rollback the changes that we made in the database using DML commands.

 

Like Web search engines (engine like Google), which the user can specify a string or any keywords and expect to get a relevant result.

 

Used to manage data within the object schema.


 

Used to give or control privilege in a database.


 

Used for creating tables, schema etc. in database.


 

Display a form to be fill out by the user.

 

The interface allows users to access their data through their mobile phone or mobile device.

 

The interface presents a menu that lead to a user through request.


 

Feedback

Question text

Entity Relationship Diagram (ERD) was proposed by .

Question text

Level of database design use to create database. 

Question text

Composite Attribute can be calculated from other attributes.


Select one:

Question text

A thing that shares a common attribute.

Question text

Is an instance of a particular entity.


Question text

Attribute describes an entity class.


Select one:
 

Question text

An attribute that has a multiple value.


Question text

It describes how entities are related to each other.

Question text

It is a collection of related data.

Question text

Controlling Redundancy is used to improve the performance of queries.


Select one:
 

Question text

Is an instance of a particular entity.


Question text

An attribute that has a multiple value.


Question text

Entity Instance is an instance of a particular entity.


Select one:
 

Question text

Database System automatically takes care of backup and recovery.

Select one:
 

Question text

It describes how entities are related to each other.

Question text

Internal Level describes the physical storage structure of the database.

Select one:
 

Question text

There’s no difference between the description of database and the database itself.

Select one:

Question text

A thing that shares a common attribute.

Question text

Attribute describes an entity class.


Select one:
 

Question text

Composite attribute can be divided into more attributes.


Select one:
 

Question text

We call the database and DBMS software together as a .

Question text

Data model is a collection of concepts that is used to describe the structure of a database.

Select one:
 

Question text

It is a question or an inquiry, sometimes loosely used for all types of interactions with databases.

Question text

Level of database design use to create database. 

Question text

Matching Type Test

The interface presents a menu that lead to a user through request.


 

Used to performed or rollback the changes that we made in the database using DML commands.

 

Display a form to be fill out by the user.

 

Used to give or control privilege in a database.


 

The interface allows users to access their data through their mobile phone or mobile device.

 

Used for creating tables, schema etc. in database.


 

Used to manage data within the object schema.


 

Like Web search engines (engine like Google), which the user can specify a string or any keywords and expect to get a relevant result.

 

Feedback


Question text

A computerized system that permits users to create and maintain a database.

Question text

Data Manipulation Language is use for manipulating data in a database.


Select one:
 

Question text

It is between high-level and low-level data models.

Question text

Data abstraction is the data type, relationships and constraints that apply to the data.

Select one:

Question text

Entity Relationship Diagram (ERD) was proposed by .

Question text

Who is responsible in administering the primary and secondary resource in the database?

Question text

For each entity instance the value of the identifier attribute is Unique.


Select one:
 

Question text

People whose jobs require access to the database for querying, updating, and generating reports.

Question text

Logical Design – transforming the ERD into relational model.


Select one:
 

Question text

A displayed schema is called Schema figure.


Select one:

Question text

Describes how entities are related.

Question text

They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data.

Question text

Facts that can be recorded and that have implicit meaning.

Question text

Attribute is a name for a set of similar things that you can list.  Like objects, events, people.


Select one:

Question text

Composite Attribute can be calculated from other attributes.


Select one:

Question text

Physical data models is a concept that shows how the data is stored on the computer.

Select one: