CH14 Assessment Flashcards
What consists of columns and rows of numerical or text data?
Relational Database
Your database has grown over time, you need to improve query performance. What should you do? (Choose Two)
A. Perform a Database Dump
B. Create a Foreign Key
C. Create an Index for Queried Data
D. Remove Infrequently Accessed Data
C. Create an Index for Queried Data
D. Remove Infrequently Accessed Data
Greg needs to remove a customer’s information completely from a table. Which command should he use?
DELETE (Data)
Which of the following descriptions best describes the type of structure that stores values as blobs?
A. Key/Value Database
B. Rational Database
C. Document Database
D. Non-Relational Database
A. Key/Value Database
Which unit of measurement relates to disk throughput?
IOPS
What statement regarding NoSQL database is Correct? (Choose Two)
A. Each row can store different types of Data.
B. They are less scalable than relational databases.
C. Each row must store the same type of data.
D. They are more scalable than Relational Databases.
A. Each row can store different types of data.
D. They are more scalable than relational databases.
You have configured a database in the headquarters office located in Houston, Texas. Users in Eastern Canada complain about slow query access to the database, while Texas users enjoy fast performance. What should you do?
A. Create an Index
B. Create a Foreign Key
C. Place a Read Replica in Eastern Canada
D. Place a Writable Replica in Eastern Canada
C. Place a Read Replica in Eastern Canada
Peter is accessing a database using JDBC connection. Which of the following terms best describes that type of access he is using?
A. User Interface/Utility Access
B. Query/Report Builder
C. Direct/Manual Access
D. Programmatic Access
C. Direct/Manual Access
You have created a Relational Database. Which of the following elements uniquely identifies a record in the database?
A. Schema
B. Primary Key
C. Field
D. Foreign Key
B. Primary Key
An employee at your office just got married and changed their last name. Which command do you use to change their last name in the employee database?
UPDATE (Data)
Which type of Database does NOT use a Rigid Schema?
NoSQL
Which of the following statements most accurately describes what a Primary Key refers to?
A. Field in a Table
B. Table in a Schema
C. Schema in a Database
D. Record in a Table
A. Field in a Table
You have increased the amount of RAM available for your cloud-based database instance. Which term describes this action?
Scaling UP
You have increased the number of compute nodes for your cloud-based database instance. Which term describes this action?
Scaling OUT
A school has a database with four TABLES, but it needs a fifth table. Which command is used to accomplish this task?
CREATE (Tables)
Laura, your manager, instructs you to remove a TABLE from a database permanently. Which command should you use?
DROP (Table)
Michael, an administrator, needs to add a column to an existing table. Which command should he use?
ALTER (Table)
Joe creates a database. What does he need to do next to make it Usable?
Import Data
A medical office needs to create a solution to manage patient records. They have about 10,000 patients and 8 staff, they want to include notes from medical professionals, emails to and from patients, and images such as x-rays. What should they create?
A. Spreadsheet
B. Relational Database
C. NON-Relational Database
D. Primary Key
C. NON-Relational Database
Henry wants to understand which of his customers has purchased part number BC8. Which command should he use?
SELECT (Data)
What is another term used to refer to a Field?
A. Row
B. Foreign Key
C. Column
D. Collection
C. Column
A user, Ann, is granted permissions to access a database. What is this an example of?
A. Direct/Manual Access
B. Data Collection
C. Data Manipulation
D. Data Definition
D. Data Definition
A database developer is working on generating queries. If the developer needs to ensure that the output of the query has data persistence, to where should the data be written?
A. CPU
B. Cache
C. SSD
D. RAM
C. SSD
Rachel, a database administrator, has created a database for her website. It contains pictures of vacations that people have uploaded. In the database, pictures have associated information about who uploaded them and the date. What is this an example of?
A. Semi-Structured Data
B. Structured Data
C. Schema Definition
D. Non-Structured Data
A. Semi-Structured Data
You have an address book for a small business with contact info for about 100 clients. The address book is used by 2 people. Which solution should you use to store the data?
A. Relational Database
B. Non-Relational Database
C. Word Processing Software
D. Spreadsheet
D. Spreadsheet