Upgrade to remove ads
Only ₩37,125/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set (39)
Which of the following would not be considered a database data type?
SELECT
Which database data type is a collection of binary data stored in a single field of a database?
BLOB
One of the ways that databases are classified is by their structure.
True
The entire Internet contains about a zettabyte of data.
False
__________ are the most commonly used database clients.
Browsers
__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.
Predictive analytics
An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.
True
It is not possible to extract analytical data from operational databases.
False
In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.
False
A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.
Field validation rule
FileMaker Pro and Microsoft Access are DBMSs.
True
SQL statements contain command words but do not contain data.
False
A(n) ________________ is a software tool for specifying the content and format for a database report.
Report generator
Which of the
following is not considered to be type of database client?
a. Local software
b. Browsers
c. Apps
d. all of the above
all of the above
Spreadsheet software offers database capabilities for establishing relationships between different record types.
False
In a relational database, relationships are specified by joining common data stored in records from different tables.
True
Which of the following is not one of the main activities associated with operational databases?
a. providing an executive dashboard for decision makers
b. Update and find data
c. organizing and distributing data
d. Collect, store, and view data
providing an executive dashboard for decision makers
A __________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system.
scale up, scale out
The relationship between record types can be depicted graphically with a(n) _________.
ERD
Which database tool is best for simple flat files that involve calculations?
Spreadsheet software
A(n) _________ database is used to collect, modify, and maintain data on a daily basis.
operational
Modern database tools support ________________, which entails separating data from the programs that manipulate data.
data independence
The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.
JOIN
The acronym ____________ refers to software that manages data stored in a database.
DBMS
The goal of normalization is to minimize data redundancy.
True
An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.
The 3rd platform
A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.
sort key
In a database, a(n) __________ contains the smallest unit of meaningful information
field
A table's physical sort order is the order in which records are arranged on storage devices.
True
Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.
True
A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules.
Serializability
__________ 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.
OLAP
SQL keywords must be entered in all uppercase letters because they are case-sensitive.
False
A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field.
single-level, multi-level
A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.
False
A lookup routine validates an entry by checking data in an in-house or third-party database.
True
Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.
True
In a key-value database, each data item has a key that is a unique identifier similar to a relational database key
True
Programmers insert documentation called facts into the program code.
False
Recommended textbook solutionsIntroduction to Algorithms
3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
720 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Introduction to the Theory of Computation
3rd EditionMichael Sipser
389 solutions
Engineering Electromagnetics
8th EditionJohn Buck, William Hayt
483 solutions
Sets with similar termsComputer applications Chapter 10
21 terms
markyd87
10
32 terms
Ariyle12345
concepts 10
30 terms
banfillj
Computer Concepts Unit 10
31 terms
vickilush
Sets found in the same folderComputer Concepts for End Users: Unit 11
120 terms
taylor_ann_rebidoux
Computer Concept for End Users: Unit 9
121 terms
taylor_ann_rebidoux
Final Review (Unit 8)
30 terms
sarah_rehman82PLUS
Final Review (Unit 11)
37 terms
sarah_rehman82PLUS
Other sets by this creatorMucosal Exam
41 terms
sarah_rehman82PLUS
Ethical Issues
5 terms
sarah_rehman82PLUS
Local Anesthetic
8 terms
sarah_rehman82PLUS
Perm Teeth Calcification and Root Completion
51 terms
sarah_rehman82PLUS
Verified questions
COMPUTER SCIENCE
Can we use the tail-call optimization in this function? If no, explain why not. If yes, what is the diff erence in the number of executed instructions in f with and without the optimization?
Verified answer
COMPUTER SCIENCE
Let CFG G be the following grammar. $S \rightarrow a S b|b Y| Y a$, $Y \rightarrow \mathrm{b} Y|\mathrm{a} Y| \varepsilon$. Give a simple description of L(G) in English. Use that description to give a CFG for $\overline{L(G)}$, the complement of L(G).
Verified answer
COMPUTER SCIENCE
For the set of {1, 4, 5, 10, 16, 17, 21} of keys, draw binary search trees of heights 2, 3, 4, 5, and 6.
Verified answer
COMPUTER SCIENCE
Suppose that a dynamic set S is represented by a direct-address table T of length m. Describe a procedure that finds the maximum element of S. What is the worst-case performance of your procedure?
Verified answer
Other Quizlet setsUnit 5 Civil war
20 terms
JackieB730
Exams 1, 2 , and 3
96 terms
richardson_mary1
American Political Controversies Final #3
30 terms
kiararayls
History
40 terms
cayleynicole93PLUS
Related questionsQUESTION
An explicit cursor must return two or more rows. (T/F)
3 answers
QUESTION
Which XML method is used to determine if the query returns a nonempty result?
4 answers
QUESTION
When creating a new Generic Object, you want to add a field that references a Legal Entity object. How do you configure this?
2 answers
QUESTION
6.2 What is the relationship between entities and tables? Between attributes and columns?
6 answers