compTIA TEST FRIDAY 10.28.22

What is a flat file? A compressed file that only displays the footer A file that stores data in simple text form A compressed file that only displays the header A file saved on a floppy disk

A file that stores data in simple text form

Which is true regarding flat files and databases? Both can only be opened by one user at a time Both can be opened by multiple users at once A database can only be opened by one user at a time A flat file can only be opened by one user at a time

A flat file can only be opened by one user at a time

Which of the following acronyms describes the traditional way to make sure data stays consistent across the entire database? CRUD SQL DBA ACID

ACID

Which command is used to add, change, or remove fields on an existing table? INSERT INTO ALTER TABLE CREATE TABLE DROP TABLE

ALTER TABLE

Which of the following is an example of a database? Netflix's videos Google's search queries All of the other choices Amazon's products

All of the other choices

Which of the following is an example of non-structured data? JSON All of the other choices XML Excel spreadsheet

All of the other choices

Which data type uses historical data to make decisions in the present? Analytical Logical Conceptual Operational

Analytical

Vast amounts of data are collected and stored online based on internet searches, social media posts, customer transactions, military surveillance, medical tests, and weather sensors. What is this known as? Big Data Data extraction Data analytics Data mining

Big Data

The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as ________________. Business Data Metadata Big Data Omni Data

Big data

Which of the following is NOT a database structure? Non-structured Structured Semi-structured Bistructured

Bistructured

If we want to make a database, which command do we use? TABLE CREATE ADD NEW

CREATE

What is another term used to refer to a field? Foreign key Database Column Row

Column

What does CSV stand for? Cipher-secret values Clear standard values Comma-separated values Compressed segment values

Comma-separated values

Which data model focuses on high-level concepts? Conceptual Operational Logical Physical

Conceptual

Which of the following are the four general tasks a user needs to perform for a database to function properly? Create, Read, Unleash, Deny Create, Reuse, Unleash, Delete Create, Read, Update, Delete Configure, Read, Update, Deny

Create, Read, Update, Delete

What is the general term for software that creates and manages databases? MySQL Tables Microsoft Access DBMS

DBMS

Which of the following commands is the process of getting rid of an entire table altogether? DROP DELETE REVERT CLEAR

DROP

What is asking specific questions to interpret Big Data called? Data analytics Data mining Data ethics Data extraction

Data analytics

The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept? Data mining Data analytics Data ethics Data extraction

Data ethics

Which of the following needs to be done before Big Data can be analyzed and interpreted? Data extraction Data analytics Securing data Data mining

Data extraction

Which of the following is a way for programmers and others to make sense of complex business flows? Primary keys Database management system Data modeling Microsoft Access

Data modeling

What is the technology that aggregates structured data from one or more sources called? Relational Big Data Non-relational Data warehousing

Data warehousing

A ______ is a structured, organized storage and retrieval system for data. Info-management system Data report Data collection Database

Database

Which of the following options is best for a large set of data? Either a flat file or database Database Flat file Neither a flat file or database

Database

Once a database is exported, it is known as a(n) ______. All of the other choices Clone Database dump Image

Database dump

Which process exports a database into a format that can be read by another program like a spreadsheet? Database backup CRUD Database dump CSV

Database dump

What is the first step when a user wants to move a database? Import Copy Dump Export

Export

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

Fields

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

First name

Other than a database, how can data be stored long-term? Flat file Index Query Persistence

Flat file

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

For one table to reference records in another table.

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

Foreign Key

What is a unique identifier that joins related data tables? Primary key Subjugated key Master key Foreign key

Foreign key

Which of the following makes it easier for users to enter data into their tables? Reports Tables Queries Forms

Forms

Which SQL command is used to give a user permission to a specific database object? GRANT REVOKE VALUES UPDATE

GRANT

What does GUI stand for? General Utility Interface Graphic Utility Interface Graphical User Interface Generic Utility Interface

Graphical User Interface

If we want to add a row to a table, which command do we use? NEW ADD COPY INSERT

INSERT

What is it called once the database has been moved to a different location? Upload Import Export Mimic

Import

What is true regarding schema? It is only the file type It is both the data and the structure It is only the data It is only the structure

It is only the structure

What is another name for direct access? Immediate access Straight access Manual access Firsthand access

Manual access

Which type of analytical data can help you make investment decisions? Transactional Machine Market Sensor

Market

Which of the following DBMS programs is open source? Microsoft Access Oracle Database MySQL SQL Server

MySQL

What are non-relational databases that deal with Big Data often referred to as? NoSQL RDBMS CRUD SQL

NoSQL

What type of database just carries data and not a structure? Structured Semi-structured Non-structured Bistructured

Non-structured

Which is true regarding flat files and databases? Only a flat file can store a vast array of types of data Both can store a vast array of types of data Only a database can store a vast array of types of data Neither can store a vast array of types of data

Only a database can store a vast array of types of data

What type of storage do databases provide? Non-volatile Volatile Persistent Non-persistent

Persistent

If users complain about a slow query in their area, what can speed up the process? Place a writeable replica in that area Create an index Remove an index Place a readable replica in that area

Place a readable replica in that area

A ______ is a unique value to differentiate records. Primary key Master key Subjugated key Foreign key

Primary key

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? Private key Foreign key Public key Primary key

Primary key

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

Primary key

______ access can be used in scripts and to automate processes and actions. Automation Coding Programmatic Crypto

Programmatic

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? User interface access Query builder Programmatic access Direct access

Programmatic access

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

Queries

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

Queries

A(n) ______ is a command to a database that requests records that match certain criteria. SQL Index Query Schema

Query

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? Table Form Query Report

Query

What term can be used to describe requesting information? Search Query Find Collect

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? Query builder User interface access Programmatic access Direct access

Query builder

Which of the following is NOT a data manipulation command? DROP INSERT DELETE RESET

RESET

A ______ is the collection of rows and columns which make up a database. Table Thonny Relation Flowchart

Relation

A ______ database is one that stores data in tables. Non-relational Non-Volatile Volatile Relational

Relational

What is a meaningful interpretation of data pulled from a database? Report Summary Hypothesis Conclusion

Report

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

Report

______ build reports about data from queries. Report builders Query compilers Mgmt Software None of the other choices

Report builders

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

Reports

What is another term used to refer to a record? Row Foreign key Column Database

Row

Mary needs to view all records from the Clients table. Which command should she use? SELECT * FROM Clients WHERE * FROM Clients WHERE ^ FROM Clients SELECT ^ FROM Clients

SELECT * FROM Clients

Mary needs to view the records from the Clients table that pertain to Travis. Which command should she use? SELECT * FROM Clients WHERE name = Travis SELECT Travis FROM Clients UPDATE * FROM Clients WHERE name = Travis SELECT ^ FROM Clients WHERE name = Travis

SELECT * FROM Clients WHERE name = Travis

What is the computer language that makes relational databases work? SQL Java Python C++

SQL

A databases ______ is the general structure of the tables contained within the database. Schema Query Field Record

Schema

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

Semi-structured

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? Database Management System Binary flat file Relational database Text-based flat file

Text-based flat file

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

What is the purpose of the database setting that controls multiple concurrent users? This controls what type of data can be stored in a database This controls how large a database can be and if it can become any larger or not This controls how fast the data can be accessed in a database This controls who has access and can be working in a database at the same time

This controls who has access and can be working in a database at the same time

A flat file can only store alphanumeric characters. True False

True

______ access allows users to access a database with a GUI. Utility Programmatic Direct Remote

Utility

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

constraint

Report store raw data in a database. retrieve information from the database. They can also add, edit, and remove data. user-friendly interfaces for working with a database. formatted summaries of information in a database.

formatted summaries of information in a database.

Query store raw data in a database. retrieve information from the database. They can also add, edit, and remove data. user-friendly interfaces for working with a database. formatted summaries of information in a database.

retrieve information from the database. They can also add, edit, and remove data.

Table store raw data in a database. retrieve information from the database. They can also add, edit, and remove data. user-friendly interfaces for working with a database. formatted summaries of information in a database.

store raw data in a database.

Form store raw data in a database. retrieve information from the database. They can also add, edit, and remove data. user-friendly interfaces for working with a database. formatted summaries of information in a database.

user-friendly interfaces for working with a database.