logo image

BIS Practice Problems 5

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
D) keep track of things that involve more than one thing
2) A ________ is a self-describing collection of integrated records.
A) datasheet
B) metadata
C) database
D) data record
C) database
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
A) a character of data
4) Characters of data are grouped into ________.
A) bytes
B) columns
C) rows
D) records
B) columns
5) Bytes are grouped into columns, which are also called ________.
A) records
B) rows
C) files
D) fields
D) fields
6) Columns are grouped into ________, which are also called ________.
A) rows; records
B) fields; tables
C) tables; files
D) files; rows
A) rows; records
7) A collection of fields is called a ________.
A) record
B) column
C) file
D) table
A) record
8) A group of similar rows or records is called a ________.
A) table
B) record
C) row
D) column
A) table
9) A table is also called a ________.
A) record
B) row
C) file
D) column
C) file
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
B) special data that describes the structure of a database
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
D) key
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
A) foreign
13) Databases that carry their data in the form of tables are called ________ databases.
A) foreign
B) meta
C) relational
D) tabular
C) relational
14) A more formal name for a table is ________.
A) metadata
B) field
C) record
D) relation
D) relation
15) Data type and description are examples of ________.
A) metadata
B) a column
C) rows
D) database
A) metadata
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
C) metadata
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
D) database application system
18) ________ software programs assist in creating and maintaining databases.
A) Metadata
B) Knowledge management
C) DBMS
D) Database application system
C) DBMS
19) Which of the following is a DBMS product from Microsoft?
A) MySQL
B) SQL Server
C) DB2
D) Sybase ASE
B) SQL Server
20) ________ is a popular enterprise DBMS from IBM.
A) DB2
B) Access
C) dBase
D) FoxPro
A) DB2
21) Database developers use the ________ to create relationships in the database.
A) DBMS
B) metadata
C) rows
D) columns
A) DBMS
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
D) processing the database
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
C) modify data
24) ________ is an international standard language for processing a database.
A) Hypertext Markup Language
B) Dynamic HTML
C) Structured Query Language
D) Sybase
C) Structured Query Language
25) SQL stands for ________.
A) Standard Query Language
B) Standard Question Language
C) Structured Query Language
D) Simplified Query Language
C) Structured Query Language
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
C) administering the database
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
A) database application
28) ________ are used to read, insert, modify, and delete data.
A) Markup language codes
B) DBMS applications
C) Data entry forms
D) Application programs
C) Data entry forms
29) In a typical database application, a(n) ________ shows data in a structured context.
A) application
B) entry form
C) query
D) report
D) report
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
B) query form
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.
C) Application programs process logic that is specific to a given business need.
32) The ________ problem is unique to a multiuser database processing.
A) data integrity
B) redundancy
C) lost-update
D) scrambled report
C) lost-update
33) ________ process(es) large organizational and workgroup databases.
A) FoxPro
B) Personal DBMS
C) Enterprise DBMS
D) Paradox
C) Enterprise DBMS
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
D) for smaller, simpler database applications
35) Which of the following is an example of enterprise DBMS?
A) Paradox
B) dBase
C) R:base
D) MySQL
D) MySQL
36) ________ is an example of personal DBMS.
A) DB2
B) FoxPro
C) Oracle
D) MySQL
B) FoxPro
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.
B) Enterprise DBMS products support many (perhaps thousands) of users and many different database applications
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.
A) Personal DBMS products are designed for simple database applications.
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
A) MS Access
40) ________ is both a DBMS and an application development product.
A) FoxPro
B) Access
C) Oracle
D) MySQL
B) Access
Databases are required to keep track of things that involve multiple themes.
True
A database is a self-describing collection of integrated records.
True
Bytes, which are characters of data, are grouped into rows, which are also called tables.
False
Columns are also called fields.
True
A field is a column or group of columns that identifies a unique row in a table.
False
A more formal name for a table is grid.
False
Relational databases have almost disappeared from use.
False
The format of metadata depends on the software product that is processing the database.
True
Databases are self-describing because they contain not only data, but also data about the data in the database.
True
To find out what a database contains, we just look at the metadata inside the database.
True
Pure database data in raw form are most pertinent and useful.
False
Each of the elements of the database application system calls on the database management system (DBMS) to process the database tables.
True
Most organizations develop their own DBMS.
False
SQL Server is an open source DBMS product that is free for most applications.
False
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.
True
SQL statements can be issued directly to the DBMS by an application program.
True
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.
True
A database cannot have more than one application running on it.
False
The DBMS uses a keyword form to locate records or items in the database.
False
Application programs process logic that is specific to a given business need.
True
One of the uses of the application program is that the application program serves as an intermediary between the Web server and the database.
True
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.
True
Enterprise DBMS products are designed for smaller, simpler database applications.
False
The bulk of databases in the personal DBMS category have multiple users.
False
Today, the only remaining personal DBMS of significance is Microsoft SQL Server.
False

Need essay sample on "BIS Practice Problems 5"? We will write a custom essay sample specifically for you for only .90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register
Signup & Access Essays

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy