Question 1

The columns in a database are called ________.

Accepted Answer

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

Question 2

Describe a database and its various elements.

Accepted Answer

A database is a self-describing collecti

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

________ 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.

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

How does normalization resolve the data integrity problem?

Accepted Answer

Normalization is the process of converti

Question 10

Identify the open source DBMS product among the following.

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

The columns in a database are called ________.

Describe a database and its various elements.

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

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

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

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

________ 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.

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

How does normalization resolve the data integrity problem?

Identify the open source DBMS product among the following.

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

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

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

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

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

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

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

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

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

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

The Importance of Mis

Business Processes, information Systems, and Information

Hardware, software, and Networks

Using Is to Improve Processes

Supporting Processes With Erp Systems

Supporting the Procurement Process With Sap

Supporting the Sales Process With Sap

Collaboration and Is

Social Media and Is

Business Intelligence and Is

Mis Management Processes: Process Management, systems Development, and Security

Filters

Exam 4: Database Processing

The columns in a database are called ________.

Describe a database and its various elements.

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

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

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

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

________ 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.

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

How does normalization resolve the data integrity problem?

Identify the open source DBMS product among the following.

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

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

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

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

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

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

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

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

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

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

The Importance of Mis

Business Processes, information Systems, and Information

Hardware, software, and Networks

Using Is to Improve Processes

Supporting Processes With Erp Systems

Supporting the Procurement Process With Sap

Supporting the Sales Process With Sap

Collaboration and Is

Social Media and Is

Business Intelligence and Is

Mis Management Processes: Process Management, systems Development, and Security

Filters