FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Databases Database Basics

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

 A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.​ 

A)  ​relational 
B)  ​operational 
C)  ​analytical 
D)  ​non relational

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

 In the context of database security, user ______ management allows access to data on an as-needed basis.​

Correct Answer

verified

rights, pe...

View Answer

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

 ​Which SQL keyword is used to search for records? 

 One of the ways that databases are classified is by their structure.​ 

 The relationship between record types can be depicted graphically with a(n) _________.​ 

 Modern database tools support ________________, which entails separating data from the programs that manipulate data.​ 

 SQL keywords must be entered in all uppercase letters because they are case-sensitive.​ 

 The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

 ​An efficiently designed database uses computed fields whenever possible because they do not require manual data entry. 

 _________ refers to the number of associations that can exist between two record types.​

 A database ____________ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.​

 A lookup routine validates an entry by checking data in an in-house or third-party database.​ 

 Rather than deleting old data, it can be moved to a data __________.​

 The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.​

 In the context of database security, database ______ identifies sensitive data and database vulnerabilities in order to secure them.​

 One of the most common database operations is to query for a particular record or group of records by using the ________ command.​

 A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.​​ 

 Which of the following is not considered to be type of database client?​ 

 A(n) _______________  is a field that contains data unique to a record.​ 

 A hierarchical database allows one-to-many relationships but not one-to-one relationships.​