WorksheetsQuiz 4: Database Management
Total questions: 20
Worksheet time: 7mins
An "entity" in databases means something that can store information.
true
false
In databases, characteristics that describe an entity are called:
record
file
attribute
tuple
Which one about the traditional environment of database management is NOT true?
poor security
lack of flexibility
lack of data sharing
higher cost
Database management systems can help solve data issues of traditional environment, NOT including:
reduce data redundancy
eliminate data inconsistency
improve data security
reduce data cost
Which is NOT true about relational database management systems?
data shown in two dimensions
data shown in rows and columns
data shown in tables
data only shown in fields
The field/attribute that uniquely identities a record is called:
key attribute
unique field
identifying record
primary key
Primary key used in a second table as look-up field to identify records from the original table is ____.
look up key
second key
foreign key
original key
Three basic operations of relational DBMS do not include:
select
relate
join
project
In database management, SQL stands for:
successful quality logic
sequential query logic
structured query logic
structured query language
In database management, ____ refers to streamlining complex data to minimize redundant elements and awkward relationships.
data streamlining
data redundancy
data relationships
normalization
Rules used by RDBMS to ensure relationships between tables remain consistent are ____.
DBMS rules
DBMS relationships
referential integrity
referential property
An ____ diagram helps visualize normalization.
entity normalized
visualized relationship
normalized relationship
entity relationship
Benefits of non-relational databases do not include:
data flexibility
data distribution
handling different data
handling processing speed
Which is least true?
cloud databases are convenient
cloud databases might appeal to small businesses
distributed databases are more efficient than cloud
distributed databases are good for data security
Which is NOT true about blockchain?
Highly distributed
Highly encrypted
Highly transparent
Highly insecure
Which is NOT true about big data?
Huge volume of data
High velocity of data
Great variety of data
Great cost of data
The need for big data analytics is driven by all but:
Growing cost of data
IoT data
Social media data
Online/mobile data
In database management, OLAP refers to:
opportune logic application processor
online logic application processor
online analytical processing
online logic application processing
Which is NOT true?
data mining seeks meaning in data
text mining seeks numerical analysis
web mining seeks useful online information
OLAP enables faster decision making
Policies and procedures through which data can be managed and assured are about:
data cleansing
data governance
data audit
data mining
