Which database data type is used for fields that contain whole numbers quantities repetitions rankings and so on?

Upgrade to remove ads

Only ₩37,125/year

  1. Science
  2. Computer Science

  • Flashcards

  • Learn

  • Test

  • Match

  • Flashcards

  • Learn

  • Test

  • Match

Terms in this set (30)

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.

operational

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

analytical

Which of the following is not one of the main activities associated with operational databases?

providing an executive dashboard for decision makers

Data _________ refers to computer algorithms that analyze information to discover previously unknown and
useful information, including relationships and patterns.

mining

__________ 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

__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.

predictive analytics

In a database, a(n) __________ contains the smallest unit of meaningful information

field

A record that contains data is referred to as a record ________.

occurrence

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

ERD

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

data independence

Which database tool is best for simple flat files that involve calculations?

spreadsheet software

A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than
one field.

single level multi level

The acronym ____________ refers to software that manages data stored in a database.

DBMS

A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules.

serializability

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

local software
browsers
apps

_________ are the most commonly used database clients.

browsers

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

field

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

primary key

A(n) ____________ is a template that adds the correct formatting as data is entered. If someone attempts to
enter data in the wrong format, the database can be set up to reject that entry or correct it

field format

A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular
field.

field validation rule

Which of the following would not be considered a database data type?

SELECT

Which database data type is used for fields that contain whole numbers—quantities, repetitions, rankings, and so on?

integer

Which database data type is a collection of binary data stored in a single field of a database?

BLOB

A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.

sort key

A(n) ________________ is a software tool for specifying the content and format for a database report.

report generator

Which of the following is not a SQL keyword?

remove

which SQL keyword is used to search for records?

SELECT

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 __________ solution for data storage adds resources to a single device, while a __________ solution adds
more devices to a system.

scale up, scale out

In a __________ database, processing logic for the query is performed on the device that holds each database
shard and if necessary, results are consolidated by the DBMS.

NoSQL

Recommended textbook solutions

Which database data type is used for fields that contain whole numbers quantities repetitions rankings and so on?

Engineering Electromagnetics

8th EditionJohn Buck, William Hayt

483 solutions

Which database data type is used for fields that contain whole numbers quantities repetitions rankings and so on?

Introduction to Algorithms

3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen

720 solutions

Which database data type is used for fields that contain whole numbers quantities repetitions rankings and so on?

Computer Organization and Design MIPS Edition: The Hardware/Software Interface

5th EditionDavid A. Patterson, John L. Hennessy

220 solutions

Which database data type is used for fields that contain whole numbers quantities repetitions rankings and so on?

Introduction to the Theory of Computation

3rd EditionMichael Sipser

389 solutions

Sets with similar terms

10

32 terms

Ariyle12345

Computer Concepts Unit 10

31 terms

vickilush

Computer applications Chapter 10

21 terms

markyd87

Unit 10

77 terms

madharbs1

Sets found in the same folder

Final Review (Unit 10)

39 terms

sarah_rehman82PLUS

Databases

15 terms

annaparedes25

concepts 9

28 terms

banfillj

CI-119 Final

149 terms

struggleisreal

Other sets by this creator

quiz 1 intro to internet

20 terms

banfillj

quiz 3 intro to the internet

30 terms

banfillj

quiz 2 intro to internet

20 terms

banfillj

quiz 1 intro to internet

20 terms

banfillj

Other Quizlet sets

Exam 1

16 terms

aesicard

Lab 1: Vertebrae

20 terms

tjcrutch2PLUS

Gender and Sexuality Studies

43 terms

sarahmccaffrey1717

Exam 4

42 terms

elenigiannulis

Related questions

QUESTION

When a value exceeds it assigned data type, a(n) "_" occurs.

2 answers

QUESTION

Number 21. Are used to ensure that a value in one column has to match the value in another column (usually a column in a different table, but not always).

2 answers

QUESTION

What is the purpose of the Form Layout Tools Arrange tab?

5 answers

QUESTION

You want to schedule a job to rebuild a table's indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to accomplish this?

2 answers

Which database data type is a collection of binary data stored in a single field of a database?

A binary large object (BLOB or blob) is a collection of binary data stored as a single entity.

What datatype stores binary values quizlet?

Integers are whole numbers represented as binary values. Most programming languages provide a data type called 'integer', often called 'int' for short. You just studied 15 terms!
SQL Server. SQL Server database developed by Microsoft is one of the most popular databases in the world. Initially launched in 1989 and written in C, C++, SQL Server is now widely used among major companies.
The relational database is the most common type of database today. Relational databases organize data into two-dimensional tables (called relations) with columns and rows.