Font size
WorksheetsInfoman -Final Examination
Total questions: 50
Worksheet time: 9mins
It refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.
File System
Database Management System
Database design
What is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system?
Relationa Database
Attributes
Database
Entity Relation Diagram
What is a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server?
SQL Database
MariaDB
phpMyAdmin
MySQL
It provides pre-defined standardized code that contains the instructions that a database can understand to generate appropriate results in response to a user's query.
QUERY DATABASE
SQL
DATABASE
QUERY
It usually refers to a request for information to be extracted from a database.
SQL
ENTITY
QUERY
TABLE
What is a question or a request for information expressed in a formal manner?
SQL
ENTITY
STATEMENT
QUERY
To retrieve entire table of a customer's database, what wild card parameter you need to use?
PERIOD
UNDERSCORE
ASTERISK
DASHLINE
Together with the SELECT command, it is used to filter records and
used to extract only those records that fulfill a specified condition.
DISTINCT
WHERE
LIKE
SELECT
It is an SQL statement operator that allows you to specify multiple values in a WHERE clause.
DISTINCT
IN
LIKE
SELECT
It is an SQL statement operator used in a WHERE clause to search for a specified pattern in a column.
DISTINCT
IN
LIKE
SELECT
What is an special character used to represents zero, one, or multiple characters?
PERCENT
UNDERSCORE
DASHLINE
BRACKET
What is LIKE operator used to represents one, or single characters?
PERCENT
UNDERSCORE
DASHLINE
BRACKET
Every folder can contain sub-folder and each sub-folder can still hold more sub-folders
Computers
Network
Hierarchical
Object-Oriented
To execute SQL statement using SELECT, what is a needed keyword to dispaly only different values of a records?
DISTINCT
WHERE
LIKE
SELECT
Defines the numerical attributes of the relationship between two entities or entity sets.
Cardinality
Attribute
Entity
Database
What is a collection of data items organized as a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables?
Database Systems
Database Model
Relational Database Management System
Database Management System
It occurs when not all of the required changes in the redundant data are made successfully.
Data anomaly
Data redundancy
Data dependence
What is a computerized system whose overall purpose is to maintain information and make that information available on demand?
Database Systems
Database Model
Relational Database Management System
Database Management System
What are raw facts, unprocessed inputs, and useless because it has no context unless processed?
Data
Hardware
Information
Procedures
It refers to a computer programming language that allows you to insert, delete, and update data in a database.
QUERY DATABASE
SQL
DML
QUERY
A database has five major parts: hardware, software, procedures, people and data
True
False
What data type accepts time values and no parameters are required when declaring this data type?
Time
Boolean
Date
Integer
It occurs when complex entries are made in several different files or recur frequently in one more files.
Data-entry error
Data inconsistency
Data integrity problems
Data anomaly
It enables you to design and set up your database and this is where you set up and configure your tables, forms and reports. What is it?
Design View
Database Design
Primary Key
Database
What is the process that involves developing and refining a database structure based on the requirements of your business?
Design View
Database Design
Primary Key
Database
Which of the coices below accepts character strings, and unicodeof a fixed length?
Boolean
Integer
Date
Character
What data type accepts numeric values with an implied scale of zero?
Boolean
Integer
Date
Character
What are basically describe people, places, or things you want to keep information about?
Conceptual Design
Primary Key
Entities and Attributes
Database Design
What is a wildcard operator used to returns a result if any of the characters inside that gets a match?
PERCENT
UNDERSCORE
DASHLINE
BRACKET
What type of database that collects different types of data sets that use tables, records, and columns and also used to create a well-defined relationship between database tables so that relational databases can be easily stored?
Relational database
MariaDB
Distributed database
SQL databse
What is the process that involves developing and refining a database structure based on the requirements of your business?
Logical Design
Database Design
Entities and Attributes
Conceptual Design
What is a situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table?
records
entity
relationships
data
Its purpose is to build conceptual model based upon the previously identified requirements, but closer to the final physical model.
Conceptual Design
Database Design
Primary Key
Design View
What is the process of deciding how to arrange the attributes of the entities in a given business environment into database structures?
Logical Design
Database Design
Entities and Attributes
Conceptual Design
It enables you to design and set up your database and this is where you set up and configure your tables, forms and reports. What is it?
Logical Design
Database Design
Design View
Conceptual Design
What database table that holds the primary key?
parent table
neighbor table
child table
database table
What is the process of deciding how to arrange the attributes of the entities in a given business environment into database structures?
Conceptual Design
Logical Design
Entities and Attributes
Database Design
What describes to increase the power of the database by allowing data to be stored separately, but managed and retrieved collectively?
primary data
records of files
data entity
table relationships
Unlocks the relationship potential of a table and creating a unique link between tables.
primary data
table relationships
primary key
data entity
The first table in entity relation must be assigned as primary key entity.
True
False
(a) is a cross-platform web server that is free and open-source and can run Apache, MySQL, PHP, and Perl.
Entity attributes is property or characteristic of an entity often shown as an oval or (a) .
The entity (a) act upon each other or how associated with each other.
The logical data type that can have only the values true or false is called (a) .
Attributed is calculated or otherwise (a) from another attribute, such as age from a birthdate. (answer must be past tense)
It is shared, integrated computer structure that houses a collection of end user data and metadata
data
file
database
information
It is a collection of programs that manages the database structure and controls access to the data stored in the database.
database
data
information
database management system
A type of database that supports data located at a single site.
centralized database
distributed database
cloud database
enterprise database
A type of database designed primarily to support a company's day-to-day operations.
Operational database
Workgroup database
Enterprise database
Desktop database
The first table in entity relation must be assigned as primary key entity.
True
False
