NEW
Font size
WorksheetsISPFL6 - Midterm Exam
Total questions: 55
Worksheet time: 28mins
Collection of data organized in a manner that allows access, retrieval, and use of that data
Database
Data
Information
Character
Collection of unprocessed items Text, Numbers, Images, Audio and Video.
Database
Data
Information
Character
Processed data Organized, Meaningful and Useful.
Database
Data
Information
Character
Create a computerized database. Add, modify, and delete data. Sort and retrieve data. Create forms and reports from the data.
Database
Data
Information
DBMS
Create a computerized database. Add, modify, and delete data. Sort and retrieve data. Create forms and reports from the data.
Database
Data
Information
DBMS
Which of the following uniquely identifies each record in a database?
Foreign key
Character key
Primary key
Secondary key
What is a data file?
A single piece of data
A collection of related records
A type of database
A computer program
What is the purpose of file maintenance?
To delete files from the system
To create files in the system
To keep data current
To corrupt data intentionally
What does validation do?
Deletes all data
Copies data to a new location
Compares data with a set of rules or values
Creates new data files
Which of the following is a benefit of the database approach?
Increased data redundancy
Reduced data integrity
Improved data integrity
Isolated data
What is the purpose of a form in a database?
To summarize data in a graphical format
To conduct performance benchmarks
To provide areas for entering or modifying data
To export data to another format
What does a data dictionary contain?
Passwords for database access
Data about each file and field in the database
A list of all queries made to the database
The history of database access by users
What is SQL used for?
To create viruses
To play video games
To manage, update, and retrieve data
To encrypt data
What is the goal of project management during system development?
To ensure the project is not completed
To make the system less efficient
To plan, schedule, and control activities
To increase project costs
What is project management in the context of system development?
The process of playing, scheduling, and controlling activities
A technique for marketing analysis
A tool for database administration
A method for software piracy prevention
What is the role of a systems analyst?
To perform data entry tasks
To design and develop an information system
To manage the company's finances
To provide technical support to users
What is the main goal of system development?
To decrease the efficiency of information processing
To build an information system
To sell software products
To conduct market research
What is an information system composed of?
Only hardware and software
Only data and procedures
Hardware, software, data, people, and procedures
Only people and operations
A record is a single character in a database.
True
False
A primary key can sometimes duplicate across records.
True
False
File processing systems encourage data redundancy.
True
False
The database approach isolates data between departments.
True
False
A query allows users to request specific data from the database.
True
False
SQL is used for designing graphical interfaces.
True
False
A form is used for entering or modifying data in a database.
True
False
The design phase includes developing the details of the new system.
True
False
Parallel conversion involves using the old and new systems simultaneously.
True
False
Economic feasibility focuses on the technical aspects of a project.
True
False
A data dictionary only contains information about users of the database.
True
False
A query cannot modify data in the database.
True
False
SQL is only used for creating databases, not managing them.
True
False
Forms in a database are exclusively used for data entry, not data modification.
True
False
Report writers can only display data, not print it.
True
False
An information system includes both hardware and people as components
True
False
The system development life cycle (SDLC) does not include a planning phase.
True
False
True or False: SQL stands for Structured Query Language, and it is used for managing and manipulating databases.
True
False
True or False: The SELECT DISTINCT statement is used to return only distinct (different) values within a table.
True
False
True or False: The WHERE SQL clause is used to filter records that do not fulfill a specified condition.
True
False
True or False: The ORDER BY keyword is used to sort the result-set in ascending order by default.
True
False
True or False: The SQL AND, OR, and NOT operators are used to filter records based on more than one condition.
True
False
True or False: The INSERT INTO statement is used to update existing records in a table.
True
False
True or False: SQL NULL values represent missing unknown data and are treated as zero in arithmetic operations.
True
False
True or False: The DELETE statement is used to delete existing records in a table.
True
False
True or False: The SQL SELECT TOP clause is used to specify the number of records to return from the top of the table.
True
False
True or False: The AVG() function returns the minimum value of a selected column.
True
False
What does SQL stand for?
Simple Query Language
Structured Query Language
Sequential Query Language
Standard Query Language
Which SQL statement is used to extract data from a database?
GET
SELECT
EXTRACT
PULL
Which clause is used to filter rows returned by the SELECT statement?
ORDER BY
GROUP BY
HAVING
WHERE
How can you sort the result set returned from a SQL query in descending order?
Use the DESC keyword after the column name in the ORDER BY clause.
Use the ASC keyword after the column name in the ORDER BY clause.
Use the SORT BY clause and specify DESC.
Sorting in descending order is not possible in SQL.
Which SQL keyword is used to return only different values?
UNIQUE
DISTINCT
DIFFERENT
SINGLE
Which SQL keyword is used to return only different values?
UNIQUE
DISTINCT
DIFFERENT
SINGLE
What does the INSERT INTO statement do?
Deletes data from a database
Updates data in a database
Inserts new data into a database
Inserts duplicate rows into a database
Which function is used to count the number of rows in a SQL query?
COUNT()
SUM()
AVG()
TOTAL()
How can you select all the columns from a table named "Customers"?
SELECT * FROM Customers
SELECT [all] FROM Customers
SELECT Customers
EXTRACT * FROM Customers
What is the correct SQL statement to insert a new record into the "Users" table?
INSERT INTO Users VALUES ('Anne', 'Smith')
ADD INTO Users ('Anne', 'Smith')
INSERT NEW ('Anne', 'Smith') INTO Users
CREATE INTO Users ('Anne', 'Smith')
