WorksheetsDatabase Concept
Total questions: 10
Worksheet time: 5mins
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
