NEW
Font size
WorksheetsFirst QUIZ of Database - Edited by: Eng. Javier Daza 2023-1
Total questions: 40
Worksheet time: 20mins
Please read analytically and choose the correct answer…
………… is collection of related data and its metadata organized in a structured format
Register
Database Management System (DBMS)
Database
Database System
Please read analytically and choose the correct answer…
............ that define and regulate the collection, storage, management, and use of data within a database environment
Database
Register - Row
Database System
Database Management System (DBMS)
Please read analytically and choose the correct answer…
............ is a software that enables easy creation, access, and modification of databases
Database
Register - Row
Database System
Database Management System (DBMS)
Please read analytically and choose the correct answer…
............ is an integrated system of hardware, software, people, procedures, and data
Database
Register - Row
Database System
Database Management System (DBMS)
Please read analytically and choose the correct answer…
............ is for efficient and effective database management
Database
Register - Row
Database System
Database Management System (DBMS)
Please read analytically and choose the correct answer…
............ is for optimized information management
Database
Register - Row
Database System
Database Management System (DBMS)
Please read analytically and choose the correct answer…
............ manages interaction between end users and database
Database
Register - Row
Database System
Database Management System (DBMS)
Please read analytically and choose the correct answer…
............Hardware, Software (OS, DBMS, Applications), People, Procedures, Data, are....
Database
Database System Environment
Database System
Database Management System (DBMS)
Please read analytically and choose the correct answer…
....Optimizes data management and Transforms data into information are purposes of....
Database System
Database System Environment
Database
Database Management System (DBMS)
Please read analytically and choose the correct answer…
....–Avoid data redundancy & ensure data integrity are the importances of....
Database System
Database System Environment
Database Management System (DBMS)
Database Design
Please read analytically and choose the correct answer…
Stores data and related data entry forms, report definitions, etc., are functions of......
Database System
Database System Environment
Database
Database Design
Please read analytically and choose the correct answer…
......Planning & Analysis represents......
What
When
Why
How
Please read analytically and choose the correct answer…
......is an example of a Data Models....
SQL
Object-Oriented
MySQL
Access
Please read analytically and choose the correct answer…
Database: User-centered:
The user has the right to a system that performs exactly as promised, that is...
Perspective
Instruction
Compliance
Usability
Please read analytically and choose the correct answer
Database: User-centered:
The user is always right. If there is a problem with the use of the system, the system is the problem, not the user, that is...
Perspective
Instruction
Compliance
Usability
Please read analytically and choose the correct answer
Database: User-centered:
The user has the right to easy-to-use instructions (user guides, online or contextual help, error messages) for understanding and utilizing a system to achieve desired goals and recover efficiently and gracefully from problem situations, that is...
Perspective
Instruction
Compliance
Usability
Please read analytically and choose the correct answer
Database: User-centered:
The user should be the master of software and hardware technology, not vice-versa. Products should be natural and intuitive to use, that is...
Perspective
Instruction
Compliance
Usability
Please read analytically and choose the correct answer
Basic Building Blocks:
................ a characteristic of an entity
Constraint
Relationship
Attribute
Entity
Please read analytically and choose the correct answer
Basic Building Blocks:
................ restrictions placed on the data
Constraint
Relationship
Attribute
Entity
Please read analytically and choose the correct answer
Basic Building Blocks:
................ describes an association among entities
Constraint
Relationship
Attribute
Entity
Please read analytically and choose the correct answer
Basic Building Blocks:
................ thing about which data are to be collected and stored
Constraint
Relationship
Attribute
Entity
Please read analytically and choose the correct answer
Data prior to the 1950s......
they were stored in magnetic tapes
were stored in paper records.
they were stored on hard disks
They were stored in solid state memories
Please read analytically and choose the correct answer
Data between 1950s and early 1960s......
they were stored in magnetic tapes
were stored in paper records.
they were stored on hard disks
they were stored in solid state memories
Please read analytically and choose the correct answer
Data late 1960s and 1970s......
they were stored in magnetic tapes
were stored in paper records.
they were stored on hard disks
they were stored in solid state memories
Please read analytically and choose the correct answer
File based systems are adequate for......
large applications
huge applications
medium applications
small applications
Please read analytically and choose the correct answer
.......begin with a strictly defined tree of data nodes.
Object - Oriented model
Hierarchical model
Relational model
Network model
Please read analytically and choose the correct answer
.......Similar to Hierarchical Model.
Object - Oriented model
Hierarchical model
Relational model
Network model
Please read analytically and choose the correct answer
......unify the data and metadata in a single form of representation.
Object - Oriented model
Hierarchical model
Relational model
Network model
Please read analytically and choose the correct answer
E.F. Codd introduced the relational model in....
1950
1960
1970
1980
Please read analytically and choose the correct answer
…………… are large complex pieces of software designed specifically for the efficient management of data.
MS DOS
SQL
DDL and DML
DBMS
Please read analytically and choose the correct answer
The ………..….. relational database language was standardized between 1982 and 1986.
MS DOS
SQL
DDL and DML
DBMS
Please read analytically and choose the correct answer
The area in the red circle of the blue table represents ........
a database
a record (row)
a table
a field (column)
Please read analytically and choose the correct answer
The area in the red circle of the blue table represents ........
a database
a record (row)
a table
a field (column)
Please read analytically and choose the correct answer
An ................ is a business object that represents a group, or category of data.
relationship
record (row)
entity
field (column)
Please read analytically and choose the correct answer
A .................................. is a link that relates two entities that share one or more attributes
entity
record (row)
database
relationship
Please read analytically and choose the correct answer
In the entity-relation database model, the rhombus represents...
Entity
Weak Entity
Attribute
Relationship
Please read analytically and choose the correct answer
In the entity-relation database model, the rectangle represents...
Entity
Weak Entity
Attribute
Relationship
Please read analytically and choose the correct answer
In the entity-relation database model, the oval represents...
Entity
Weak Entity
Attribute
Relationship
Please read analytically and choose the correct answer
In the entity-relationship database model, the double rectangle represents...
Entity
Weak Entity
Attribute
Relationship
Please read analytically and choose the correct answer
Based on the entity relationship model scheme given, the primary key attribute is represented by ...
Price
Registration Number
Model Number
Color
Car
