NEW
Font size
WorksheetsTestOut CompTIA ITF Databases 20 Questions
Total questions: 20
Worksheet time: 10mins
Which of the following is a Structured Query Language (SQL) command that lets you view information stored in a database?
GRANT
RETRIEVE
SELECT
CREATE VIEW
A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database?
The data can be stored as unstructured data.
The data is stored as a single file for quick retrieval.
The data can be organized into separate tables that are related to each other.
The data can be saved as a flat file.
Which of the following is a feature that provides for the security and integrity of the data in a database?
Data encryption
Anti-malware protection
Device passwords
User privilege levels
There are several processes related to database usage. Which of the following involves the information stored in a database, where the database is hosted, and how clients can access the data?
Reports
Queries
Creation
Storage
Marty, a database administrator, needs to build a database query that will return the results from the start of January through the end March. Which of the following commands would be used?
INSERT
ALTER TABLE
UPDATE
SELECT
A database administrator wants to export a table as a backup before changes are made to the table structure. Which of the following commands should be executed?
SELECT
ALTER TABLE
UPDATE
BACKUP
A database administrator wants to create a copy of an entire database. Which of the following SQL (Structured Query Language) commands can the administrator use to create the copy?
CREATE BACKUP DATABASE database_name
BACKUP database_name
BACKUP DATABASE database_name
CREATE BACKUP database_name
Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?
For one database to reference another database.
To provide a way to distinguish records within a table.
For one table to reference records in another table.
To allow the storage of unstructured data.
An IT administrator wants to provide a graphical interface tool for company sales representatives to quickly find product information and pricing in a relational database (without using SQL commands).
Which of the following would provide the type of access the sales representatives need?
DBMS (database management system)
Query builder
User interface access
Collaboration software
Which of the following BEST describes the permissions a user has for a database object after creating the object while logged into their user account?
The object's creator can deny permissions to the object for other user accounts.
The object's creator is limited to permissions given by the GRANT command.
The object's creator has complete control over that object.
The object's creator has all permissions for the object, except those limited by the DENY command.
Cindy wants to use a database to store and retrieve information for a research project. She has gathered photos, newspaper articles, interviews, and notes. The information does not appear to have a clear pattern. Which of the following types of data does Cindy want to store?
Relational
Structured
Non-structured
Semi-structured
A medical supply company is using a spreadsheet to keep track of inventory. The company is rapidly expanding, and several employees now need to access the spreadsheet securely at the same time (concurrent use). However, each time one employee opens the spreadsheet, it's locked for use by any other employees.
Which of the following provides the BEST solution to resolve this issue?
Purchase new spreadsheet software that allows multiple users to access the spreadsheet at the same time.
Switch to a database that allows for concurrent users and can support thousands of users accessing the data at the same time.
Keep the current spreadsheet, but upgrade to a version that allows for multiple users to access the spreadsheet at the same time with the proper authorization.
Switch to a cloud-based spreadsheet solution that allows multiple users to access the spreadsheet at the same time.
Which of the following SQL commands would change the title of a movie in a Movies relational database from "The Education of Rita" to "Educating Rita"?
UPDATE movie_title = "Educating Rita" IN Movies WHERE id=124
UPDATE Movies OLD movie_title = "The Education of Rita" NEW "Educating Rita" WHERE id=124
UPDATE Movies SET movie_title = "Educating Rita" WHERE id=124
UPDATE Movies FROM movie_title = "The Education of Rita" TO "Educating Rita" WHERE id=124
In a relational database table, columns are better known as ________________.
Records
Categories
Fields
Instances
Which of the following terms describes the set of SQL commands that change the structure or schema of a database, such as the DROP command?
Data Manipulation Language (DML)
Data Definition Language (DDL)
Direct Access
Data Mining
Which of the following is a SQL statement?
if len(sys.argv) != 2: print usage sys.exit(0)
SELECT * FROM Orders WHERE OrderID=5
=IF(C3>=65,"Pass","Fail")
var rollDie = (Math.floor(Math.random() * 6) +1
Which of the following SQL (Structured Query Language) CREATE commands only requires one parameter?
CREATE INDEX
CREATE VIEW
CREATE DATABASE
CREATE TABLE
Which database object is essentially questions that we can ask the database?
Reports
Tables
Forms
Queries
Which of the following is an advantage of using a database over a flat file system?
Imports and exports
Processing speed
CSV files
Software upgrades
A database administrator wants to export all the data in a database to a comma separated value file (.CSV) where it can be opened by spreadsheet software. Which of the following would be the EASIEST way to create the exported file?
Database form
Transact SQL
SQL query
Database dump
