Upgrade to remove ads
Only ₩37,125/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set (25)
DBMS
The acronym ____________ refers to software that manages data stored in a database.
False
In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.
OLAP
__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.
True
Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.
Browsers
__________ are the most commonly used database clients.
True
FileMaker Pro and Microsoft Access are DBMSs.
SELECT
Which of the following would not be considered a database data type?
providing an executive dashboard for decision makers
Which of the following is not one of the main activities associated with operational databases?
True
One of the ways that databases are classified is by their structure.
Spreadsheet software
Which database tool is best for simple flat files that involve calculations?
False
A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.
field
In a database, a(n) __________ contains the smallest unit of meaningful information
False
SQL keywords must be entered in all uppercase letters because they are case-sensitive.
True
A table's physical sort order is the order in which records are arranged on storage devices.
JOIN
The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.
False
SQL statements contain command words but do not contain data.
operational
A(n) _________ database is used to collect, modify, and maintain data on a daily basis.
Predictive analytics
__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.
BLOB
Which database data type is a collection of binary data stored in a single field of a database?
True
Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.
True
In a relational database, relationships are specified by joining common data stored in records from different tables.
True
The goal of normalization is to minimize data redundancy.
all of the above are types of database clients
Which of the following is not considered to be type of database client?
ERD
The relationship between record types can be depicted graphically with a(n) _________.
single-level, multi-level
A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field.
Recommended textbook solutions
Engineering Electromagnetics
8th EditionJohn Buck, William Hayt
483 solutions
Introduction to the Theory of Computation
3rd EditionMichael Sipser
389 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Introduction to Algorithms
3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
720 solutions
Sets with similar termsComputer applications Chapter 10
21 terms
markyd87
concepts 10
30 terms
banfillj
10
32 terms
Ariyle12345
Unit 10
77 terms
madharbs1
Sets found in the same folderFinal Review (Unit 10)
39 terms
sarah_rehman82PLUS
Final Review (Unit 11)
37 terms
sarah_rehman82PLUS
INSY Chapter 9-11
122 terms
Nieve16
Final Review (Unit 7)
54 terms
sarah_rehman82PLUS
Other sets by this creatorINSY 3303 Ch. 2
30 terms
aswinshaji
INSY 3303 Ch. 1
31 terms
aswinshaji
ACCT 2301 Ch. 13
36 terms
aswinshaji
ACCT 2301 Ch. 12
26 terms
aswinshaji
Verified questionsCOMPUTER SCIENCE
Show that if P=NP, then P=PH.
Verified answer
COMPUTER SCIENCE
Write pseudocode for HASH-DELETE as outlined in the text, and modify HASH-INSERT to handle the special value DELETED.
Verified answer
COMPUTER SCIENCE
Add a member function named maxNode to the NumberList class discussed in this chapter. The function should return the largest value stored in the list. Use recursion in the function to traverse the list. Demonstrate the function in a driver program.
Verified answer
COMPUTER SCIENCE
Write a function that accepts a string as an argument and returns true if the argument ends with the substring '.com'. Otherwise, the function should return false.
Verified answer
Other Quizlet setsBiology 2 - Exam 1
21 terms
Baxter_Brown8
Cardiology lecture 3- Disorders of the p…
33 terms
fabiana_garcia
ch 22 and 31
24 terms
mariafernandaa690
physical science first semester exam study guide
57 terms
shelandrum
Related questionsQUESTION
You can apply more than one grouping order to a report.
9 answers
QUESTION
The three major characteristics of today's society that are impacted by databases include...
15 answers
QUESTION
SOAP message syntax for sending a value?
3 answers
QUESTION
A class in UML is similar to...........
15 answers