Question 1

Database software primarily deals with the physical aspects of file use,while accounting application software deals with the logical aspect of file use.

Accepted Answer

A) True 
 B)False

Question 2

What defines an entire database being loaded into computer-internal high-speed random access memory or other high-speed electronic storage device?

Accepted Answer

A)  Internal database 
B)  In-resident database 
C)  RAM database 
D)  In-memory database 
A)  Internal database 
B)  In-resident database 
C)  RAM database 
D)  In-memory database

Question 3

DBMS is a user-friendly computer language or interface that allows the user to request information from the database.

Accepted Answer

A) True 
 B)False

Question 4

Object-oriented modeling can be ________ easily into object-oriented program code.

Accepted Answer

A)  moved 
B)  translated 
C)  uploaded 
D)  transformed 
A)  moved 
B)  translated 
C)  uploaded 
D)  transformed

Question 5

In the E-R conceptual model,the term ________ is used instead of segment,and the term ________ is used to refer to individual fields or data items.

Accepted Answer

The answer of In the E-R conceptual model,the term ________...

Question 6

Sequential-access files are often referred to as ISAM files.

Accepted Answer

A) True 
 B)False

Question 7

Response time is affected by

Accepted Answer

A)  disk access time. 
B)  how data records are physically distributed on the disk. 
C)  the database management system but not the operating system. 
D)  disk access time and how data records are physically distributed on the disk. 
A)  disk access time. 
B)  how data records are physically distributed on the disk. 
C)  the database management system but not the operating system. 
D)  disk access time and how data records are physically distributed on the disk.

Question 8

The tree database structure corresponds to the data structure supported by COBOL and other widely used programming languages.

Accepted Answer

A) True 
 B)False

Question 9

A major advantage of DBMS is its ability to construct special database files quickly and efficiently.

Accepted Answer

A) True 
 B)False

Question 10

The command used in an SQL query to combine fields from several tables is

Accepted Answer

A)  GROUP BY. 
B)  ORDER BY. 
C)  WHERE INSTR. 
D)  INNER JOIN. 
A)  GROUP BY. 
B)  ORDER BY. 
C)  WHERE INSTR. 
D)  INNER JOIN.

Question 11

A database contains the following data:
Student Schedule (Student#,Student_name,Major,Course#1,ClassTime1,Location1,Course#2,ClassTime2,Location2,Course#3,ClassTime3,Location3)
Required: Normalize this relation through the third normal form.

Accepted Answer

Student Schedule (Student#,Cou

Question 12

The move to object-oriented design is due to the fact that OO databases outperform relational databases in a wide range of common tasks that are typically performed in a business environment.

Accepted Answer

A) True 
 B)False

Question 13

In the object-oriented modeling technique,an object class has the following structure: PAPER_INVENTORY (SUPPLIER_NO,DISCOUNT)
What is the structure of the subclass COPY having the unique attributes QUANTITY and TYPE?

Accepted Answer

A)  COPY (QUANTITY, TYP
E)  
B)  COPY (SUPPLIER_NO, QUANTITY, TYP
E)  
C)  COPY (SUPPLIER_NO, DISCOUNT, QUANTITY, TYP
E)  
D)  COPY (PAPER_INVENTORY, QUANTITY, TYP
E)  
A)  COPY (QUANTITY, TYP
E)  
B)  COPY (SUPPLIER_NO, QUANTITY, TYP
E)  
C)  COPY (SUPPLIER_NO, DISCOUNT, QUANTITY, TYP
E)  
D)  COPY (PAPER_INVENTORY, QUANTITY, TYP
E)

Question 14

________ connect(s)the business application to the database management system.

Accepted Answer

A)  Database driver 
B)  Database agnosticity 
C)  CASEwise 
D)  Database objects 
A)  Database driver 
B)  Database agnosticity 
C)  CASEwise 
D)  Database objects

Question 15

In SQL,WHERE must be used to determine which records from the tables listed in the FROM clause will appear in the results of the SELECT statement.

Accepted Answer

A) True 
 B)False

Question 16

________ fields cross-link segments in tree and network database structures.

Accepted Answer

The answer of ________ fields cross-link segments in tree and...

Question 17

SQL is a non-procedural programming language.

Accepted Answer

A) True 
 B)False

Question 18

Database dictionaries are used both alone and with DBMSs to ________ the use of data within an organization

Accepted Answer

A)  centralize and document 
B)  centralize and control 
C)  centralize, document, control, and coordinate 
D)  centralize, document, and coordinate 
A)  centralize and document 
B)  centralize and control 
C)  centralize, document, control, and coordinate 
D)  centralize, document, and coordinate

Question 19

Describe the index,prime area,and overflow area in an ISAM file structure.

Accepted Answer

The index is a map that links the key

Question 20

Match between columns
                        Premises:  Logical data structure
 Key
 Node
 DQL
 Element
 Hypertext systems
 DML
 SELECT
 First normal form
 DDL

Accepted Answer

The Answer of Defines the logical structure of the database is...

Database software primarily deals with the physical aspects of file use,while accounting application software deals with the logical aspect of file use.

What defines an entire database being loaded into computer-internal high-speed random access memory or other high-speed electronic storage device?

DBMS is a user-friendly computer language or interface that allows the user to request information from the database.

Object-oriented modeling can be ________ easily into object-oriented program code.

In the E-R conceptual model,the term is used instead of segment,and the term is used to refer to individual fields or data items.

Sequential-access files are often referred to as ISAM files.

Response time is affected by

The tree database structure corresponds to the data structure supported by COBOL and other widely used programming languages.

A major advantage of DBMS is its ability to construct special database files quickly and efficiently.

The command used in an SQL query to combine fields from several tables is

A database contains the following data: Student Schedule (Student#,Student_name,Major,Course#1,ClassTime1,Location1,Course#2,ClassTime2,Location2,Course#3,ClassTime3,Location3) Required: Normalize this relation through the third normal form.

The move to object-oriented design is due to the fact that OO databases outperform relational databases in a wide range of common tasks that are typically performed in a business environment.

In the object-oriented modeling technique,an object class has the following structure: PAPER_INVENTORY (SUPPLIER_NO,DISCOUNT) What is the structure of the subclass COPY having the unique attributes QUANTITY and TYPE?

________ connect(s)the business application to the database management system.

In SQL,WHERE must be used to determine which records from the tables listed in the FROM clause will appear in the results of the SELECT statement.

________ fields cross-link segments in tree and network database structures.

SQL is a non-procedural programming language.

Database dictionaries are used both alone and with DBMSs to ________ the use of data within an organization

Describe the index,prime area,and overflow area in an ISAM file structure.

Accounting Information Systems: An Overview

Systems Techniques and Documentation

Ebusiness and Ecommerce

Transaction Processing and the Internal Control Process

Fraud Examination and Fraud Management

Information Systems Security

Electronic Data Processing Systems

Revenue Cycle Processes

Procurement and Human Resources Business Processes

The Production Business Process

Systems Planning, analysis, and Design

Systems Project Management, implementation, operation, control

Auditing Information Technology

Filters

Exam 13: Data Management Concepts

Database software primarily deals with the physical aspects of file use,while accounting application software deals with the logical aspect of file use.

What defines an entire database being loaded into computer-internal high-speed random access memory or other high-speed electronic storage device?

DBMS is a user-friendly computer language or interface that allows the user to request information from the database.

Object-oriented modeling can be ________ easily into object-oriented program code.

In the E-R conceptual model,the term ________ is used instead of segment,and the term ________ is used to refer to individual fields or data items.

Sequential-access files are often referred to as ISAM files.

Response time is affected by

The tree database structure corresponds to the data structure supported by COBOL and other widely used programming languages.

A major advantage of DBMS is its ability to construct special database files quickly and efficiently.

The command used in an SQL query to combine fields from several tables is

A database contains the following data: Student Schedule (Student#,Student_name,Major,Course#1,ClassTime1,Location1,Course#2,ClassTime2,Location2,Course#3,ClassTime3,Location3) Required: Normalize this relation through the third normal form.

The move to object-oriented design is due to the fact that OO databases outperform relational databases in a wide range of common tasks that are typically performed in a business environment.

In the object-oriented modeling technique,an object class has the following structure: PAPER_INVENTORY (SUPPLIER_NO,DISCOUNT) What is the structure of the subclass COPY having the unique attributes QUANTITY and TYPE?

________ connect(s)the business application to the database management system.

In SQL,WHERE must be used to determine which records from the tables listed in the FROM clause will appear in the results of the SELECT statement.

________ fields cross-link segments in tree and network database structures.

SQL is a non-procedural programming language.

Database dictionaries are used both alone and with DBMSs to ________ the use of data within an organization

Describe the index,prime area,and overflow area in an ISAM file structure.

Accounting Information Systems: An Overview

Systems Techniques and Documentation

Ebusiness and Ecommerce

Transaction Processing and the Internal Control Process

Fraud Examination and Fraud Management

Information Systems Security

Electronic Data Processing Systems

Revenue Cycle Processes

Procurement and Human Resources Business Processes

The Production Business Process

Systems Planning, analysis, and Design

Systems Project Management, implementation, operation, control

Auditing Information Technology

Filters

In the E-R conceptual model,the term is used instead of segment,and the term is used to refer to individual fields or data items.