Question 1

COGNITIVE ASSESSMENT What is a database that stores data in tables that consist of rows and columns?

Accepted Answer

A)  OODB 
B)  distributed database 
C)  multidimensional database 
D)  relational database

Question 2

Match between columns
                        Premises: What is done to a record so the DBMS will not process it again.

Accepted Answer

The Answer of systems test and validation and proof of is...

Question 3

One application that uses multidimensional databases is an object-oriented database.

Accepted Answer

A) True 
 B)False

Question 4

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is an advantage of a multidimensional database?

Accepted Answer

A)  There is a common query language. 
B)  The content of all dimensions is the same regardless of the subject. 
C)  It can store data in two dimensions. 
D)  All multidimensional databases have a dimension of time.

Question 6

What is a data type? List the data types commonly found in a database.

Accepted Answer

The answer of What is a data type? List the...

Question 7

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

Accepted Answer

A)  report 
B)  query 
C)  specification 
D)  inquiry

Question 8

Which of the following identifies the quality of data in a database?

Accepted Answer

A)  file resolution 
B)  authenticated access 
C)  information dimensionality 
D)  data integrity

Question 9

Which of the following does a back end interact with?

Accepted Answer

A)  DBNS 
B)  DBMS 
C)  BDNS 
D)  BDMS

Question 10

SQL stands for which of the following?

Accepted Answer

A)  Structured Query Language 
B)  Statement Query Language 
C)  Standard Query Language 
D)  Student Query Language

Question 11

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?

Accepted Answer

A)  range 
B)  numeric 
C)  completeness 
D)  consistency

Question 12

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

Accepted Answer

A)  viewing 
B)  writing 
C)  reading 
D)  access

Question 13

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

Accepted Answer

A)  front end 
B)  user environment 
C)  home page 
D)  data file

Question 14

A macro is a series of statements that instructs a program or app how to complete a task.

Accepted Answer

A) True 
 B)False

Question 15

____________________ unneeded records reduces the size of files, thereby freeing up storage space.

Accepted Answer

The answer of ____________________ unneeded records reduces the size of...

Question 16

Data redundancy decreases the chance of errors.

Accepted Answer

A) True 
 B)False

Question 17

In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?

Accepted Answer

A)  
A)  completeness check 
B)  range check 
C)  consistency check 
D)  check digit

Question 18

List the four tests that systems analysts and users develop.

Accepted Answer

The answer of List the four tests that systems analysts...

Question 19

Which of the following is a number(s)or character(s)that is appended to or inserted into a primary key field?

Accepted Answer

A)  check digit 
B)  index 
C)  insertion ordinal 
D)  integer

Exam 11: Building Solutions

COGNITIVE ASSESSMENT What is a database that stores data in tables that consist of rows and columns?

Identify the letter of the choice that best matches the phrase or definition.

One application that uses multidimensional databases is an object-oriented database.

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Which of the following is an advantage of a multidimensional database?

What is a data type? List the data types commonly found in a database.

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

Which of the following identifies the quality of data in a database?

Which of the following does a back end interact with?

SQL stands for which of the following?

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

A macro is a series of statements that instructs a program or app how to complete a task.

____________________ unneeded records reduces the size of files, thereby freeing up storage space.

Data redundancy decreases the chance of errors.

List the four tests that systems analysts and users develop.

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?