Domain 5

Which of the following are the fundamental types of relational methods associated with Structured Query Language (SQL)? (Select two.) Correct Answer: Define the database structure Correct Answer: Upgrade the database software Correct Answer: Manage information in the database Correct Answer: Back up the data in a database Correct Answer: Increase the storage space for the database

Define the database structure Manage information in the database

As a database administrator, you want to make sure that the Phone field in a record is not left blank by an employee filling in personal information. Which of the following could you apply to the field to keep it populated? Correct Answer: Schema Correct Answer: Primary key Correct Answer: Constraint Correct Answer: Form

Constraint

A database administrator is using the direct database access method to run several Structured Query Language (SQL) commands on a relational database. Which of the following SQL commands helps the administrator manage permissions in the database? (Select two.) Correct Answer: SELECT Correct Answer: DELETE Correct Answer: UPDATE Correct Answer: GRANT Correct Answer: REVOKE

Correct Answer: GRANT Correct Answer: REVOKE

In a relational database table, columns are better known as ________________. Correct Answer: Records Correct Answer: Fields Correct Answer: Categories Correct Answer: Instances

Fields

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? Correct Answer: SELECT Correct Answer: INSERT Correct Answer: ALTER TABLE Correct Answer: UPDATE

SELECT

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"? Correct Answer: UPDATE Movies SET movie_title = "Educating Rita" WHERE id=124 Correct Answer: UPDATE Movies OLD movie_title = "The Education of Rita" NEW "Educating Rita" WHERE id=124 Correct Answer: UPDATE Movies FROM movie_title = "The Education of Rita" TO "Educating Rita" WHERE id=124 Correct Answer: UPDATE movie_title = "Educating Rita" IN Movies WHERE id=124

UPDATE Movies SET movie_title = "Educating Rita" WHERE id=124

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? Correct Answer: UPDATE Correct Answer: SELECT Correct Answer: ALTER TABLE Correct Answer: BACKUP

Correct Answer: BACKUP

Which of the following are basic architectural components of a relational database? (Select three.) Correct Answer: Records Correct Answer: Fields Correct Answer: Tables Correct Answer: Primary keys Correct Answer: Constraints Correct Answer: XML

Correct Answer: Records Correct Answer: Fields Correct Answer: Tables

April is a database manager who wants to insert some new records (rows) into the company's customer contact database. Instead of using a database client to insert the records, she wants to use a command. Which of the following languages provides a command for inserting records into a database? Correct Answer: HTML (HyperText Markup Language) Correct Answer: DCL (Data Control Language) Correct Answer: DDL (Data Definition Language) Correct Answer: DML (Data Manipulation Language)

DML (Data Manipulation Language)

Which of the following is an advantage of using a database over a flat file system? Correct Answer: CSV files Correct Answer: Imports and exports Correct Answer: Software upgrades Correct Answer: Processing speed

Processing speed

A relational database has become corrupted, and now the database administrator needs to import the most recent database backup to fix the issue. Which SQL command can the administrator use to perform this task? Correct Answer: INSERT INTO Correct Answer: DROP TABLE Correct Answer: UPDATE Correct Answer: RESTORE

Correct Answer: RESTORE

Which type of data have elements in common but do not fit into rigid rows and columns in a table? Correct Answer: Non-relational Correct Answer: Structured Correct Answer: Semi-structured Correct Answer: Non-structured

Semi-structured

A database can store a variety of data in each table. Which of the following is the BEST example of a variety of data within a table? Correct Answer: A string field that allows for numbers, characters, and punctuation Correct Answer: A table with integer, float, and decimal fields Correct Answer: A table with a variety of string fields Correct Answer: A table with date, purchase amount, and customer name fields

A table with date, purchase amount, and customer name fields

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? Correct Answer: CREATE BACKUP database_name Correct Answer: CREATE BACKUP DATABASE database_name Correct Answer: BACKUP DATABASE database_name Correct Answer: BACKUP database_name

BACKUP DATABASE database_name

A restaurant chain maintains a Suppliers relational database that lists all suppliers for the restaurant. Recently, the restaurant ended a contract with CafeFresh in favor of another supplier of organic produce. The database manager wants to use a SQL command to remove CafeFresh from the database. Which of the following commands would remove all CafeFresh records? Correct Answer: DELETE * FROM Suppliers WHERE supplier_name = 'CafeFresh' Correct Answer: DELETE FROM TABLE Suppliers WHERE supplier_name = 'CafeFresh' Correct Answer: DELETE supplier_name = 'CafeFresh' FROM Suppliers Correct Answer: DELETE Suppliers WHERE supplier_name = 'CafeFresh'

DELETE * FROM Suppliers WHERE supplier_name = 'CafeFresh'

A database administrator wants to export the data in a product airline schedule database into a Microsoft Excel spreadsheet. Which of the following methods would allow the administrator to perform this task? Correct Answer: Export the database with the BACKUP DATABASE command; then import the database backup into the spreadsheet. Correct Answer: Export a database dump to a CSV file; then use the INSERT command to import the CSV file into the spreadsheet. Correct Answer: Export the database with the BACKUP DATABASE command and use the WHERE command to import the data into a spreadsheet. Correct Answer: Export a database dump to a CSV file; then import the CSV file into the spreadsheet.

Export a database dump to a CSV file; then import the CSV file into the spreadsheet.

Which of the following should not be used as a primary key in a table? Correct Answer: First name Correct Answer: Social Security number Correct Answer: Username Correct Answer: Employee ID

First name

Mark is a database administrator who's responsible for managing the records in a boat inventory relational database for a local chain of boat shops. Recently, the owners have decided to expand to several more stores. Mark has hired David, an assistant administrator, to help out. In order to get started, he wants to grant permission to the assistant to retrieve and view information in the database. Which of the following SQL commands can Mark use to grant this permission to David? Correct Answer: GRANT ALL ON boatinventory TO david Correct Answer: GRANT SELECT ON boatinventory TO david Correct Answer: GRANT SELECT TO david ON boatinventory Correct Answer: GRANT UPDATE ON boatinventory TO david

GRANT SELECT ON boatinventory TO david

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? Correct Answer: Structured Correct Answer: Non-structured Correct Answer: Semi-structured Correct Answer: Relational

Non-structured

Jeremy is building an application that needs access to read, write, update, and delete information in a database. Which of the following databases does Jeremy need? Correct Answer: User interface access Correct Answer: Query builder Correct Answer: Programmatic access Correct Answer: Direct access

Programmatic access

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? Collaboration software DBMS (database management system) Query builder User interface access

Query builder

Information in a relational database is stored in tables. Which of the following are the primary architectural components of a table for storing database information? (Select two.) Correct Answer: Forms Correct Answer: Records Correct Answer: Strings Correct Answer: Variables Correct Answer: Fields

Records Fields

An application developer needs to store configuration data that can be retrieved each time the application is launched. The data must be in a format that could be easily viewed outside of the application and edited using any editor. Which of the following would be the BEST choice? Correct Answer: Database Management System Correct Answer: Text-based flat file Correct Answer: Relational database Correct Answer: Binary flat file

Text-based flat file

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? Correct Answer: The object's creator can deny permissions to the object for other user accounts. Correct Answer: The object's creator is limited to permissions given by the GRANT command. Correct Answer: The object's creator has complete control over that object. Correct Answer: The object's creator has all permissions for the object, except those limited by the DENY command.

The object's creator has complete control over that object.

A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank. Correct Answer: schema Correct Answer: query builder Correct Answer: constraint Correct Answer: scalability

constraint

Which of the following BEST describes a foreign key in a relational database? Correct Answer: A record (row) in a table that is designated as a unique identifier Correct Answer: A record (row) in a table that is imported from another table in the database Correct Answer: A second primary key in a table that can be referenced from other tables Correct Answer: A primary key referenced by one table from a record in another table

A primary key referenced by one table from a record in another table

Which of the following SQL (Structured Query Language) CREATE commands only requires one parameter? Correct Answer: CREATE TABLE Correct Answer: CREATE VIEW Correct Answer: CREATE DATABASE Correct Answer: CREATE INDEX

CREATE DATABASE

Which of the following lets you store unstructured data? Correct Answer: Non-relational database Correct Answer: DBMS Correct Answer: Flat file database Correct Answer: Relational database

Non-relational database

Michael is a web developer who has created a simple website form to survey visitors about their favorite hobbies. What is the MOST likely purpose for which he created the form? Correct Answer: To create a flat file for each person who fills out the survey. Correct Answer: To directly input the survey data into a database. Correct Answer: To create a database to store the survey data. Correct Answer: To transfer the survey data from one database to another.

To directly input the survey data into a database.

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? Correct Answer: Switch to a cloud-based spreadsheet solution that allows multiple users to access the spreadsheet at the same time. Correct Answer: Switch to a database that allows for concurrent users and can support thousands of users accessing the data at the same time. Correct Answer: 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. Correct Answer: 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.

Which of the following BEST describes the use of a database by the application? Correct Answer: Database input Correct Answer: Data persistence Correct Answer: Database query Correct Answer: Data backup

Data persistence

A database administrator for a graphics design firm wants to create a database for storing several kinds of files, including photographs, videos, audio files, design documents, and contracts. Which of the following database types is designed for storing these types of files? SQL database Document database Key/pair value database Relational database

Document database

Becca is working on a program that will store data. The program will need quick access to data and data persistence is not important. Where should the data be stored? Correct Answer: In a database Correct Answer: In a flat file Correct Answer: In memory Correct Answer: In flash memory

In memory

Dana, an IT manager, is part of a transition team determining whether to keep the company's Excel flat file system for storing customer data or to switch to a database (such as PostgreSQL). Which of the following would be a significant advantage of switching from Excel to a database for storing customer data? Correct Answer: A database is useful for transferring information between systems. Correct Answer: A database is useful for tracking simple data, such as customer addresses. Correct Answer: A database is difficult to secure with different users having different privilege levels. Correct Answer: A database makes analyzing a million records just as easy as analyzing a few hundred.

A database makes analyzing a million records just as easy as analyzing a few hundred.

As a database administrator, you want to speed up query retrieval time in your relational database. Which of the following SQL commands could you use to accelerate retrieving data with a query? Correct Answer: CREATE VIEW Correct Answer: CREATE TABLE Correct Answer: ALTER TABLE Correct Answer: CREATE INDEX

CREATE INDEX

Which of the following SQL commands would you use to delete an entire table and all of its data? Correct Answer: DROP Correct Answer: DELETE Correct Answer: ALTER TABLE Correct Answer: UPDATE

DROP

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? Correct Answer: Data Manipulation Language (DML) Correct Answer: Direct Access Correct Answer: Data Mining Correct Answer: Data Definition Language (DDL)

Data Definition Language (DDL)

Peter is a regional sales manager for an online clothing retail company. He would like information on all the customers in his region and the purchases made by each of them during the last quarter. Which of the following database elements can BEST provide the information Peter needs? Form Query Table Report

Report

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? Correct Answer: To allow the storage of unstructured data. Correct Answer: For one database to reference another database. Correct Answer: For one table to reference records in another table. Correct Answer: To provide a way to distinguish records within a table.

For one table to reference records in another table.

Which of the following database features would provide a formatted, easy-to-read listing of the results of a query? Correct Answer: SQL command Correct Answer: Record Correct Answer: Form Correct Answer: Report

Report

Alberto works in human resources and wants to move all personnel files to a system that would provide a user interface for adding, updating, and removing personnel records. He also wants to ensure the data cannot be viewed without correct permissions. Which of the following would be the BEST option to store and retrieve this data? Correct Answer: Cloud storage Correct Answer: Database Correct Answer: Text-based flat file Correct Answer: Network share

Database

SQL supports commands that give an object's creator the ability to grant rights for specific objects, tables, or columns and provide those rights to other users. Which of the following database concepts describes this ability to grant rights? Correct response: Programmatic access Correct Answer: Data Definition Language (DDL) Correct Answer: Direct access Correct Answer: Permissions

Permissions

Which database object is essentially questions that we can ask the database? Correct Answer: Forms Correct Answer: Reports Correct Answer: Queries Correct Answer: Tables

Queries

Which of the following is a SQL statement? Correct Answer: SELECT * FROM Orders WHERE OrderID=5 Correct Answer: var rollDie = (Math.floor(Math.random() * 6) +1 Correct Answer: if len(sys.argv) != 2: print usage sys.exit(0) Correct Answer: =IF(C3>=65,"Pass","Fail")

SELECT * FROM Orders WHERE OrderID=5

Which of the following scenarios is an example of why an application or utility would need a database for persistent data storage? Correct Answer: A system manager edits and saves a network device's configuration. Correct Answer: A customer fills out an online form to order a Bluetooth speaker. Correct Answer: A business manager edits and saves a PowerPoint presentation. Correct Answer: A student creates and saves a graphic image.

A customer fills out an online form to order a Bluetooth speaker.

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? Correct Answer: Transact SQL Correct Answer: SQL query Correct Answer: Database dump Correct Answer: Database form

Database dump

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? Correct Answer: The data can be stored as unstructured data. Correct Answer: The data can be saved as a flat file. Correct Answer: The data can be organized into separate tables that are related to each other. Correct Answer: 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.

Which of the following is a Structured Query Language (SQL) command that lets you view information stored in a database? Correct Answer: SELECT Correct Answer: CREATE VIEW Incorrect response: RETRIEVE Correct Answer: GRANT

SELECT

In a relational database table, rows are better known as ______________. Correct Answer: Categories Correct Answer: Records Correct Answer: Fields Correct Answer: Instances

Records

A database administrator is setting up a new table that will contain customer information. The fields include name, address, company, phone, email, and customer ID. The administrator is using the customer ID to uniquely identify each customer record. Which of the following BEST describes the customer ID field? Correct Answer: Public key Correct Answer: Primary key Correct Answer: Foreign key Correct Answer: Private key

Primary key

Which of the following is found in one or more columns of data and contains a unique identifier for the row? Correct Answer: Attribute Correct Answer: Foreign key Correct Answer: Relationship Correct Answer: Primary key

Primary key

A developer is working on an application that needs to be able to read, write, update, and delete database records. Which of the following database access methods should the developer use? Correct Answer: Query builder Correct Answer: Direct access Correct Answer: User interface access Correct Answer: Programmatic access

Programmatic access

Which of the following can be used to ask a database questions and receive the data we're looking for? Correct Answer: Reports Correct Answer: Forms Correct Answer: Tables Correct Answer: Queries

Queries

Patricia, a database system manager for a large hotel chain, is setting up a relational database to track customer hotel registrations for each hotel. The table in the database currently includes fields (columns) for First Name, Last Name, Phone, Email, License Plate #, and Check-in Date. What can Patricia do to make sure that each record (row) in the database is unique? Correct Answer: Designate the License Plate # field as the primary key. Correct Answer: Combine the Email field and the Phone field to use as the primary key. Correct Answer: Designate the Phone field as the primary key. Correct Answer: Create an additional Check-in ID field.

Create an additional Check-in ID field.

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? Correct Answer: Creation Correct Answer: Storage Correct Answer: Queries Correct Answer: Reports

Creation

What group of database commands is used to define and modify metadata? Data correlation Data control Data manipulation Data definition

Data definition

A small business wants to persistently store customer feedback and product feature requests. The business also wants to be able to index and sort the information by priority. Which of the following would be the BEST option to track this information? Correct Answer: SSD Correct Answer: Database Correct Answer: Flat file Correct Answer: Memory

Database

A value that's used to identify a record from a linked table is called a ________________. Correct Answer: Primary Key Correct Answer: Foreign Key Correct Answer: Linked Key Correct Answer: Borrowed Key

Foreign Key

A database administrator wants to insert a record (row) into a database's Movies table. Which of the following is the SQL command that the administrator can use to insert the record? Correct Answer: INSERT INTO Movies (id, title, year, director) VALUES (166, "The Guardian", 1945, "Hal Manchin") Correct Answer: INSERT Movies VALUES (166, "The Guardian", 1945, "Hal Manchin") FIELDS (id, title, year, director) Correct Answer: ALTER TABLE Movies (id, title, year, director) VALUES (166, "The Guardian", 1945, "Hal Manchin") Correct Answer: UPDATE TABLE Movies (id, title, year, director) VALUES (166, "The Guardian", 1945, "Hal Manchin")

INSERT INTO Movies (id, title, year, director) VALUES (166, "The Guardian", 1945, "Hal Manchin")

A system manager has created a database to store company employees' personal information. What is the next step that the system manager needs to do? Correct Answer: Import (input) data records into the database. Correct Answer: Generate a report to make sure the database is working properly. Correct Answer: Validate that the database has sufficient storage space. Correct Answer: Test the database by extracting information using a query.

Import (input) data records into the database.

David is running a Microsoft SQL Server database that provides an ODBC (Open Database Connectivity) driver that allows applications to access database management systems (DBMSs) using SQL commands. The database setup stores employees' personal information used by Human Resources and company managers. In addition to the database setup, David has provided an application that lets employees modify their personal information. The application utilizes the ODBC and SQL commands to make changes to the employee records in the database. Which combination of database access methods reflects the environment David has configured to store and manage employees' personal information? Programmatic access and direct access Query builder and programmatic access Programmatic access and user interface access Direct access and query builder

Programmatic access and user interface access

Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward then wants to save that information in a file format that will be used by another application. Which of the following database features would work BEST to accomplish this? Correct Answer: Table Correct Answer: Query Correct Answer: Report Correct Answer: Form

Query

Gina is a database user and her supervisor has asked her to generate a report from the structured database. Gina does not know how to write SQL commands and no forms have been created. Which of the following would be her BEST option to generate the report? Correct Answer: Direct access Correct Answer: User interface access Correct Answer: Query builder Correct Answer: Programmatic access

Query builder

Which of the following is an advantage of using a relational database over a key/value pair database? Correct Answer: Relational databases use SQL to retrieve data from the database. Correct Answer: Relational databases allow for unstructured data. Correct Answer: Relational databases do not require all fields to be associated with each data object. Correct Answer: Relational databases require much less storage space.

Relational databases use SQL to retrieve data from the database.

Which of the following database objects provides a summary of data? Correct Answer: Queries Correct Answer: Forms Correct Answer: Tables Correct Answer: Reports

Reports

Which of the following is a database concept that allows for storage and analysis for a few dozen to billions of data points? Correct Answer: Processing speed Correct Answer: Concurrent use Correct Answer: Scalability Correct Answer: Storage

Scalability

Which of the following are reasons you would use a database to manage your data? (Select two.) Correct Answer: Store data securely. Correct Answer: Provide a productivity software solution. Correct Answer: Edit media files. Correct Answer: Protect data against social engineering threats. Correct Answer: Generate data reports.

Store data securely. Generate data reports.

Which of the following is a feature that provides for the security and integrity of the data in a database? Correct Answer: Anti-malware protection Correct Answer: Data encryption Correct Answer: Device passwords Correct Answer: User privilege levels

User privilege levels