In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

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 (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

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

Engineering Electromagnetics

8th EditionJohn Buck, William Hayt

483 solutions

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

Introduction to the Theory of Computation

3rd EditionMichael Sipser

389 solutions

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

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

5th EditionDavid A. Patterson, John L. Hennessy

220 solutions

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

Introduction to Algorithms

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

720 solutions

Sets with similar terms

Computer 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 folder

Final 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 creator

INSY 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 questions

COMPUTER 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 sets

Biology 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 questions

QUESTION

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

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.

Which database data type is used for fields that contain whole numbers?

The integer data type is used for fields that contain whole numbers—quantities, repetitions, rankings, and so on. Database designers use the integer data type unless the data requires decimal places because real numbers require more storage space.

Which of the following is an example of an operating system that is used by smart phones?

Android Operating System Android is an open-source mobile OS developed by Google and launched in 2008 [8].

Which Access 2016 View contains commands used to manage access files and options?

The Backstage view. The Backstage view occupies the File tab on the ribbon and contains many commands. The Backstage view also contains other commands that apply to an entire database file. When you open Access but do not open a database (e.g., you open Access from the Windows Start menu), you see the Backstage view.