WorksheetsDATABASE DESIGN REVISION (1-5)
Total questions: 15
Worksheet time: 9mins
Select the CORRECT software used for Database Management System.
RDBUS
ORACLE
DBUSE
REDHAT
Identify the activity that can be done in requirement analysis
Design Database
Conduct Survey
Developing database
Implementing database
Choose the level in the three-schema architecture that describe the structures and constraints for the whole database to the user
Internal level
External level
Conceptual level
Database level
Express the meaning of the following relational algebra in Figure given :
Compute the intersection between the STUDENT and COURSE relations
Compute the difference between the STUDENT and COURSE relations
Compute the natural join between the STUDENT and COURSE relations
Compute the union between the STUDENT and COURSE relations
Identify the type of key to represent the relationship between table
Secondary key
Candidate key
Primary key
Foreign key
Express the relational algebra operator to display StudID and StudName from Table below :
Identify the characteristic of data that is in First Normal Form (1NF).
There is data redundancy
Contains one or more repeating groups
A column contains a value that is of a different type
Each attribute contains one and only one atomic value
Identify the symbol for relationship in E-R Diagram
Oval
Triangle
Diamond
Rectangle
Figure below shows the relationship of entity PROFESSOR and SECTION. Choose the BEST suited answer for the relationship.
A professor can teach many section and a professor not teaching any section.
One section can only e taught by one professor and many professor can teach many section
A professor does not need to teach a section at all and many professor can teach many section
One section of a course can be taught by many professor and a professor teaching any section
Identify the CORRECT answer for Data Definition Language (DDL).
Create and modify the structure of objects in database
Manipulation of data inside the database
Manage changes made by DML statement
Control the user access to the database, table, views, procedure, function and package
Identify a command in SQL to ELIMINATE a table from database
REMOVE Table Customer
DELETE Table Customer
UPDATE Table Customer
DROP Table Customer
Choose the SQL equal statement as of shown in below statement.
SELECT subject_name FROM Subject WHERE credit_hour = 4;
SELECT subject_name IN Subject WHERE credit_hour = 4;
SELECT subject_name IN Subject FROM credit_hour = 4;
SELECT subject_name FROM Subject WHERE credit_hour IN ('4');
SELECT subject_name FROM Subject IN credit_hour('4');
Identify which of the following is a property of database transactions.
Atomicity, complexity, isolation and durability
Atomicity, consistency, isolation and durability
Atomicity, complexity, isolation and durability
Atomicity, consistency, isolation and efficiency
Choose the CORRECT phase in two-phase lock protocol where a transaction obtains locks
Initial phase
Running phase
Shrinking phase
Expanding phase
Based on statement given, choose the suitable properties of database transaction related.
The process of managing simultaneous operations on a database without having them interfere with another one
Concurrency control
Recoverability
Transaction Management
Serialization
