question

1) The purpose of a database is to ________. A) use special technology to monitor a single theme B) design, write, test, troubleshoot, and maintain the source code of computer programs C) use a logical data model of information to describe and build architectures D) keep track of things that involve more than one thing

answer

D) keep track of things that involve more than one thing

question

2) A ________ is a self-describing collection of integrated records. A) datasheet B) metadata C) database D) data record

answer

C) database

question

3) Which of the following describes a byte? A) a character of data B) group of rows C) collection of data D) group of columns

answer

A) a character of data

question

4) Characters of data are grouped into ________. A) bytes B) columns C) rows D) records

answer

B) columns

question

5) Bytes are grouped into columns, which are also called ________. A) records B) rows C) files D) fields

answer

D) fields

question

6) Columns are grouped into ________, which are also called ________. A) rows; records B) fields; tables C) tables; files D) files; rows

answer

A) rows; records

question

7) A collection of fields is called a ________. A) record B) column C) file D) table

answer

A) record

question

8) A group of similar rows or records is called a ________. A) table B) record C) row D) column

answer

A) table

question

9) A table is also called a ________. A) record B) row C) file D) column

answer

C) file

question

10) What is metadata? A) data that can be used to get a clear idea of the content of a Web page B) special data that describes the structure of a database C) data that describes a Web page D) some aspect of an information resource

answer

B) special data that describes the structure of a database

question

11) A ________ is a column or group of columns that identifies a unique row in a table. A) field B) byte C) file D) key

answer

D) key

question

12) Columns that are keys of a different table than the one in which they reside are known as ________ keys. A) foreign B) aspect C) relational D) variable

answer

A) foreign

question

13) Databases that carry their data in the form of tables are called ________ databases. A) foreign B) meta C) relational D) tabular

answer

C) relational

question

14) A more formal name for a table is ________. A) metadata B) field C) record D) relation

answer

D) relation

question

15) Data type and description are examples of ________. A) metadata B) a column C) rows D) database

answer

A) metadata

question

16) The name of the field, the data type, and the number of characters allowed would be an example of ________. A) character B) key C) metadata D) byte

answer

C) metadata

question

17) A(n) ________ is an assembly of forms, reports, queries, and application programs that process a database. A) SQL server B) metadata C) database management system D) database application system

answer

D) database application system

question

18) ________ software programs assist in creating and maintaining databases. A) Metadata B) Knowledge management C) DBMS D) Database application system

answer

C) DBMS

question

19) Which of the following is a DBMS product from Microsoft? A) MySQL B) SQL Server C) DB2 D) Sybase ASE

answer

B) SQL Server

question

20) ________ is a popular enterprise DBMS from IBM. A) DB2 B) Access C) dBase D) FoxPro

answer

A) DB2

question

21) Database developers use the ________ to create relationships in the database. A) DBMS B) metadata C) rows D) columns

answer

A) DBMS

question

22) Which of the following is a function of the DBMS? A) considering multiuser processing B) mastering database application programs C) preparing reports D) processing the database

answer

D) processing the database

question

23) For which of the following operations do applications use DBMS? A) send e-mails B) write a software program C) modify data D) track simple data

answer

C) modify data

question

24) ________ is an international standard language for processing a database. A) Hypertext Markup Language B) Dynamic HTML C) Structured Query Language D) Sybase

answer

C) Structured Query Language

question

25) SQL stands for ________. A) Standard Query Language B) Standard Question Language C) Structured Query Language D) Simplified Query Language

answer

C) Structured Query Language

question

26) During which of the following functions of a database are tools provided for assistance? A) creating the database B) querying at Flextime C) administering the database D) processing the database

answer

C) administering the database

question

27) A ________ is a collection of reports, forms, and queries that process a database. A) database application B) SQL query C) DBMS D) database structure

answer

A) database application

question

28) ________ are used to read, insert, modify, and delete data. A) Markup language codes B) DBMS applications C) Data entry forms D) Application programs

answer

C) Data entry forms

question

29) In a typical database application, a(n) ________ shows data in a structured context. A) application B) entry form C) query D) report

answer

D) report

question

30) To locate something in the database, one must type in the keyword into the ________ of the application. A) report B) query form C) data entry form D) data column

answer

B) query form

question

31) Which of the following is true of database application? A) A database can have only one application, and each application may have one user. B) It is a language that processes information in a database management system. C) Application programs process logic that is specific to a given business need. D) It uses hypertext markup language to process information in a database.

answer

C) Application programs process logic that is specific to a given business need.

question

32) The ________ problem is unique to a multiuser database processing. A) data integrity B) redundancy C) lost-update D) scrambled report

answer

C) lost-update

question

33) ________ process(es) large organizational and workgroup databases. A) FoxPro B) Personal DBMS C) Enterprise DBMS D) Paradox

answer

C) Enterprise DBMS

question

34) Personal DBMS products are designed ________. A) to process large organizational and workgroup databases B) to span dozens of different magnetic disks with hundreds of gigabytes or more of data C) to support many users and many different database applications D) for smaller, simpler database applications

answer

D) for smaller, simpler database applications

question

35) Which of the following is an example of enterprise DBMS? A) Paradox B) dBase C) R:base D) MySQL

answer

D) MySQL

question

36) ________ is an example of personal DBMS. A) DB2 B) FoxPro C) Oracle D) MySQL

answer

B) FoxPro

question

37) Which of the following stands true for enterprise DBMS products? A) Enterprise DBMS products are designed for small and simple database applications. B) Enterprise DBMS products support many (perhaps thousands) of users and many different database applications. C) Paradox is an example of an enterprise DBMS product. D) Most of the enterprise DBMS products are out of business today.

answer

B) Enterprise DBMS products support many (perhaps thousands) of users and many different database applications

question

38) Which of the following stands true for personal DBMS products? A) Personal DBMS products are designed for simple database applications. B) Personal DBMS products support many users. C) Personal DBMS products can manage databases that span dozens of different magnetic disks. D) MySQL is an example of a personal DBMS product.

answer

A) Personal DBMS products are designed for simple database applications.

question

39) Which of the following is the most significant personal DBMS product available in the market today? A) MS Access B) FoxPro C) dBase D) Paradox

answer

A) MS Access

question

40) ________ is both a DBMS and an application development product. A) FoxPro B) Access C) Oracle D) MySQL

answer

B) Access

question

Databases are required to keep track of things that involve multiple themes.

answer

True

question

A database is a self-describing collection of integrated records.

answer

True

question

Bytes, which are characters of data, are grouped into rows, which are also called tables.

answer

False

question

Columns are also called fields.

answer

True

question

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

answer

False

question

A more formal name for a table is grid.

answer

False

question

Relational databases have almost disappeared from use.

answer

False

question

The format of metadata depends on the software product that is processing the database.

answer

True

question

Databases are self-describing because they contain not only data, but also data about the data in the database.

answer

True

question

To find out what a database contains, we just look at the metadata inside the database.

answer

True

question

Pure database data in raw form are most pertinent and useful.

answer

False

question

Each of the elements of the database application system calls on the database management system (DBMS) to process the database tables.

answer

True

question

Most organizations develop their own DBMS.

answer

False

question

SQL Server is an open source DBMS product that is free for most applications.

answer

False

question

To modify an existing table - for example, to add a new column - the developer opens the metadata form for that table and adds a new row of metadata.

answer

True

question

SQL statements can be issued directly to the DBMS by an application program.

answer

True

question

DBMS administrative functions include backing up database data, adding structures to improve the performance of database applications, removing data that are no longer wanted or needed, and similar tasks.

answer

True

question

A database cannot have more than one application running on it.

answer

False

question

The DBMS uses a keyword form to locate records or items in the database.

answer

False

question

Application programs process logic that is specific to a given business need.

answer

True

question

One of the uses of the application program is that the application program serves as an intermediary between the Web server and the database.

answer

True

question

The lost-update problem can be prevented by a type of locking which must be used to coordinate the activities of users who know nothing about one another.

answer

True

question

Enterprise DBMS products are designed for smaller, simpler database applications.

answer

False

question

The bulk of databases in the personal DBMS category have multiple users.

answer

False

question

Today, the only remaining personal DBMS of significance is Microsoft SQL Server.

answer

False

BIS Practice Problems 5 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards