Filters
Question type

Study Flashcards

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.​


A) Scalability
B) Compatibility
C) Cardinality
D) Functionality

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

The basic elements of logical storage are alphabetic or numeric characters, such as the letter A or the number 9.

A) True
B) False

Correct Answer

verifed

verified

Briefly describe the seven coding methods used by companies with examples.​

Correct Answer

verifed

verified

• Sequence codes are numbers or letters ...

View Answer

A _____ specifies the fields and identifies the primary key in a particular file.


A) frame design
B) table design
C) viewport
D) window

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A person, place, thing, or event for which data is collected and maintained


A) ​Unified Modeling Language (UML)
B) ​Cardinality
C) ​Foreign key
D) ​Data mining
E) ​​Referential integrity
F) Subschema
G) ​Extended Binary Coded Decimal Interchange Code (EBCDIC)
H) Entity
I) Logical record
J) Logical storage

K) H) and I)
L) B) and H)

Correct Answer

verifed

verified

A table design that contains a repeating group is called _____.


A) normalized
B) unnormalized
C) unsynchronized
D) synchronized

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

  -In the accompanying figure, a _____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables. A)  secondary key B)  candidate key C)  combination key D)  foreign key -In the accompanying figure, a _____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.


A) secondary key
B) candidate key
C) combination key
D) foreign key

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

Binary digits have only _____ possible value(s) .


A) one
B) two
C) three
D) four

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

A) True
B) False

Correct Answer

verifed

verified

  -If a primary key combines two or more fields, then it is called a _____. A)  foreign key B)  composite key C)  dedicated key D)  candidate key -If a primary key combines two or more fields, then it is called a _____.


A) foreign key
B) composite key
C) dedicated key
D) candidate key

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

A _____ is a set of letters or numbers that represents a data item.


A) business glossary
B) data dictionary
C) mnemonic
D) code

E) B) and D)
F) A) and C)

Correct Answer

verifed

verified

In a table or file, each column represents a record and each row represents a field.

A) True
B) False

Correct Answer

verifed

verified

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A coding method used on mainframe computers and high-capacity servers


A) ​Unified Modeling Language (UML)
B) ​Cardinality
C) ​Foreign key
D) ​Data mining
E) ​​Referential integrity
F) Subschema
G) ​Extended Binary Coded Decimal Interchange Code (EBCDIC)
H) Entity
I) Logical record
J) Logical storage

K) A) and D)
L) B) and F)

Correct Answer

verifed

verified

Web-based systems are popular because they offer ease of access, cost-effectiveness, and worldwide connectivity.

A) True
B) False

Correct Answer

verifed

verified

To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs.

A) True
B) False

Correct Answer

verifed

verified

To bridge the gap between a database and the Internet, it is necessary to use a _____, which is software that integrates different applications and allows them to exchange data.


A) middleware
B) stack
C) server
D) firmware

E) A) and C)
F) B) and D)

Correct Answer

verifed

verified

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A technique used by analysts to define relationships in more detail, after drawing an initial entity-relationship diagram


A) ​Unified Modeling Language (UML)
B) ​Cardinality
C) ​Foreign key
D) ​Data mining
E) ​​Referential integrity
F) Subschema
G) ​Extended Binary Coded Decimal Interchange Code (EBCDIC)
H) Entity
I) Logical record
J) Logical storage

K) B) and C)
L) E) and G)

Correct Answer

verifed

verified

Matching ​Identify the letters of the choices that best match the phrases or definitions. -Defines only those portions of the database that a particular system or user needs or is allowed to access


A) ​Unified Modeling Language (UML)
B) ​Cardinality
C) ​Foreign key
D) ​Data mining
E) ​​Referential integrity
F) Subschema
G) ​Extended Binary Coded Decimal Interchange Code (EBCDIC)
H) Entity
I) Logical record
J) Logical storage

K) All of the above
L) A) and C)

Correct Answer

verifed

verified

_____ is strictly hardware-related because it involves the process of reading and writing binary data to physical media, such as a hard drive, CD/DVD, or network-based storage device.


A) Logical storage
B) Virtual storage
C) Simulated storage
D) Physical storage

E) A) and C)
F) C) and D)

Correct Answer

verifed

verified

Typically, a database management system is managed by a person called _____, who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.


A) database administrator
B) business intelligence analyst
C) database consumer
D) big data analyst

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Showing 41 - 60 of 86

Related Exams

Show Answer