Filters
Question type

Study Flashcards

Which of the following is true about the database development process?


A) The easiest time to change the database structure is during the data modeling stage.
B) Changing a relationship from 1:N to N:M in an existing database is simply a matter of changing notations.
C) User review of the data model is avoided as it is not helpful in data modeling.
D) A database is a model of how the developers view their business world.

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

Which of the following is a nonrelational data store developed by Google?


A) Cassandra
B) Dynamo
C) SharePoint
D) Bigtable

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

Correct Answer

verifed

verified

A user does not need user account credentials to access and process a database.

A) True
B) False

Correct Answer

verifed

verified

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.


A) Administrators
B) Developers
C) Users
D) Designers

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

Correct Answer

verifed

verified

Which of the following data elements is placed higher than records in the database hierarchy?


A) file
B) field
C) character
D) byte

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

Correct Answer

verifed

verified

A(n) ________ is a program used to create,process,and administer a database.


A) operating system
B) DBMS
C) information system
D) data mart

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

Identify the open source DBMS product among the following.


A) MySQL
B) DB2
C) Access
D) Oracle Database

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

Correct Answer

verifed

verified

A database management system (DBMS)is a program used to create,process,and administer a database.

A) True
B) False

Correct Answer

verifed

verified

Which of the following is a nonrelational data store developed by Amazon?


A) Cassandra
B) Dynamo
C) SharePoint
D) Bigtable

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

Correct Answer

verifed

verified

Describe a database and its various elements.

Correct Answer

verifed

verified

A database is a self-describing collecti...

View Answer

How does normalization resolve the data integrity problem?

Correct Answer

verifed

verified

Normalization is the process of converti...

View Answer

The purpose of a database is to keep track of things that involve a single theme.

A) True
B) False

Correct Answer

verifed

verified

The columns in a database are called ________.


A) records
B) tables
C) files
D) fields

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

Correct Answer

verifed

verified

A(n) ________ is a request for data from a database.


A) form
B) report
C) query
D) application

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

Correct Answer

verifed

verified

When you modify or delete data present in a database,you are ________.


A) creating a new database
B) forming a data model
C) simplifying the data structure
D) processing the database

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

Correct Answer

verifed

verified

Columns that are keys to different tables than the ones in which they reside are called ________.


A) attributes
B) foreign keys
C) primary keys
D) internal records

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

Correct Answer

verifed

verified

A key is a column or group of columns that identifies a unique row in a table.

A) True
B) False

Correct Answer

verifed

verified

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

A) True
B) False

Correct Answer

verifed

verified

A data model describes data and relationships that will be stored in the database.

A) True
B) False

Correct Answer

verifed

verified

________ is the process of converting a data model into tables,relationships,and data constraints.


A) Database design
B) Database querying
C) Data mining
D) Database aggregation

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

Correct Answer

verifed

verified

Showing 21 - 40 of 110

Related Exams

Show Answer