Database Concept

From the following, identify the example of an information.

• Subject code

• Credit hour for CSC2833 subject

• Student ID number in attendance record

• Number of DBIT student who got straight A’s in previous semester

Based on Table 1, what is the correct term for StudID, StudName, Program, and Semester column title?

• Entity

• Record

• Attribute

• Database

Which of the following statements best describe database management system (DBMS)?

• Software that can be regarded as computerized record-keeping system.

• Software that enables users to define, create and maintain the database.

• Software that performs services for the end users and each program manages its own data.

• Software that needs consideration of understanding about the need of the organizations.

The ability of a database to allow a transaction to execute as if there are no other concurrently running transactions refers to ______________.

• data isolation 

• data duplication 

• data dependence 

• compatible file format 

The component inside DBMS that can be used to delete records in the database table is ______________.

• Data dictionary

• Data procedure

• Data definition language (DDL)

• Data manipulation language (DML)

As a database developer, Anisa wants to create the framework of the database by specifying the database schema, including the creation and alteration of tables, files, indexes and columns within the database. From the following, which DBMS component should be used by Anisa?

• Data dictionary

• Data procedure

• Data definition language (DDL)

• Data manipulation language (DML)

“Many users can access data at the same time. DBMS provides a database with a function of multiuser access control. Therefore, from the single centralized database, multiple simultaneous access by users are easy to control.”

The statement refers to __________________.

• security function

• consistency function

• redundancy function

• concurrency function

“In DBMS, all data of an organization is integrated into a single database file. The data is recorded in only one place in the database. Therefore, data is not duplicated.”

The statement refers to the ability of DBMS to __________________.

• increase concurrency

• improve data security

• promote data sharing

• control data redundancy

From the following, find the correct statement of data consistency in the database.

• The risk of data inconsistencies can be increased by eliminating or controlling data concurrency.

• With the help of consistency rules in the database, users can leave a field on a web page form empty.

• For a database to be consistent, data written to the database must be valid according to all defined rules and constraints.

• Data consistency is increased when the system had unreliable data that let a user register a student for a class that isn't offered in that semester.

When a student's last name changes and the last name value has to be changed in multiple locations in the system, this is an example of _________________.

• Data sharing

• Data redundancy

• Data consistency

• Data concurrency