 |
1 | |
The most important function of the DBMS is to: |
| | A) | Define and normalize the data relationships. |
| | B) | Maintain multiple data files. |
| | C) | Define and store the data so authorized users can find everything they need. |
| | D) | Store report formats for future use and modification. |
|
|
2 | |
Each table in a data file has a name and: |
| | A) | A record key composed of a numeric designator. |
| | B) | A specific place to fill in the hierarchical structure of the database. |
| | C) | A series of related applications to apply to the data stored therein. |
| | D) | Represents objects or relationships in the data. |
|
|
3 | |
Data independence assures that the database: |
| | A) | Will work as designed. |
| | B) | Will be small enough to manipulate. |
| | C) | Will not need to be updated as often. |
| | D) | Is more likely to be accurate and there will be less data duplication. |
|
|
4 | |
When using the pattern command LIKE, V* stands for: |
| | A) | Any column in the data file that begins with V. |
| | B) | Any row in the data file that begins with V. |
| | C) | Any characters including and following the letter V in the subject column. |
| | D) | One single character after the letter V in the subject column. |
|
|
5 | |
The GROUP BY clause is: |
| | A) | Available only in SQL. |
| | B) | Available only in QBE. |
| | C) | Available in both SQL and QBE. |
| | D) | Called by a different name in QBE. |
|
|
6 | |
Every table must have: |
| | A) | More than one row of data. |
| | B) | A primary key. |
| | C) | At least two columns. |
| | D) | The ability to change keys. |
|
|
7 | |
It is easier to use a database if all input screens: |
| | A) | Are designed with the clerical input personnel in mind. |
| | B) | Fall within normalization parameters. |
| | C) | Are available to everyone in the firm. |
| | D) | Have similar, standardized characteristics. |
|
|
8 | |
While the rest of the aviation industry has languished, what is the one major airline that has flourished recently-even becoming the first airline to resume its full flight schedule immediately after Sept. 11? |
| | A) | United |
| | B) | Southwest |
| | C) | TWA |
| | D) | American |
|
|
9 | |
The database approach begins with the premise that the most important aspect of a computer is: |
| | A) | Speed. |
| | B) | Its look. |
| | C) | The data it stores. |
| | D) | Network compatibility |
|
|
10 | |
A terabyte is: |
| | A) | A million bytes. |
| | B) | A trillion bytes. |
| | C) | A quadrillion bytes. |
| | D) | Three bytes. |
|
|
11 | |
In a relational DBMS, all data is stored in tables, which consist of: |
| | A) | Legs and a tabletop. |
| | B) | Bar charts. |
| | C) | Pie charts. |
| | D) | Columns and rows. |
|
|
12 | |
In a database, what is a set of one or more columns that uniquely identifies each row? |
| | A) | Primary key. |
| | B) | Composite key. |
| | C) | Data independence. |
| | D) | A table. |
|
|
13 | |
The main advantage of data independence is: |
| | A) | That reports never have to be modified. |
| | B) | The ability to change the data without having to change the program. |
| | C) | That whenever data is changed, all other related programs must be updated as well. |
| | D) | That tables and entire columns may be deleted at will. |
|
|
14 | |
An international standard method for retrieving data from database management systems is called: |
| | A) | SQL |
| | B) | QBE |
| | C) | QB |
| | D) | COBOL |
|
|
15 | |
Which is NOT a basic question to create a query? |
| | A) | How are the tables joined together? |
| | B) | What output do you want to see? |
| | C) | At what time was the query inputted? |
| | D) | What tables are involved? |
|
|
16 | |
Missing data is represented by what value in relational databases? |
| | A) | SQL |
| | B) | BETWEEN |
| | C) | LIKE |
| | D) | NULL |
|
|
17 | |
What is the standard command for retrieving data in SQL? |
| | A) | LIKE |
| | B) | BETWEEN |
| | C) | CHOOSE * FROM |
| | D) | SELECT |
|
|
18 | |
With regard to databases, what is a CID? |
| | A) | Customer intelligence directive |
| | B) | Customer number |
| | C) | Console in demand |
| | D) | Combined interest duality |
|
|
19 | |
The ability to have a "one-to-many" relationship is a chief advantage of using: |
| | A) | A single table |
| | B) | Multiple tables |
| | C) | SID |
| | D) | SQR |
|
|
20 | |
If you have a complex query that you have to run every week, you can save it as: |
| | A) | Text |
| | B) | RTF |
| | C) | SQR |
| | D) | A view |
|
|
21 | |
When each non-key column in a table depends on the entire key, we say that the table is in: |
| | A) | First normal form |
| | B) | First run |
| | C) | Second normal form |
| | D) | Second run |
|
|
22 | |
When a table contains no repeating sections, we say that it is in: |
| | A) | First normal form |
| | B) | First run |
| | C) | Second normal form |
| | D) | Second run |
|
|
23 | |
What types of information can be placed on an input screen? |
| | A) | Data retrieved from the database, simple text or input blanks |
| | B) | Simple text or input blanks |
| | C) | Input blanks only |
| | D) | Simple text only |
|
|
24 | |
A value that is automatically displayed by the computer is known as a/an: |
| | A) | Deferred value |
| | B) | Adjunct value |
| | C) | Default value |
| | D) | Scrolling value |
|
|
25 | |
Most reports can be broken into categories. For example, there might be report titles that appear only at the front of the report (such as cover pages). Other information, such as the report title, date, and column labels, will be repeated at the top of each page; these items are called: |
| | A) | Breaks |
| | B) | Page headers |
| | C) | Primary headers |
| | D) | Page footers |
|
|
26 | |
Tools that enable you to combine the various features into a single application are called: |
| | A) | Application blenders |
| | B) | Application synthesizers |
| | C) | Application generators |
| | D) | Application recombitants |
|
|
27 | |
The most important responsibility of the Database Administrator is: |
| | A) | Establishment of security safeguards. |
| | B) | Determine which data needs to be protected |
| | C) | Monitor database activity |
| | D) | Log all page requests by visitors. |
|
|
28 | |
What are the two leading systems being used for building Web-based applications? |
| | A) | Sun and J2EE |
| | B) | Java and Sun |
| | C) | J2EE and the .NET platform |
| | D) | J2EE and Java |
|
|
29 | |
What are some of the advantages of running a database on a separate server? |
| | A) | Reduced load on the Web server and makes it easier to handle backups and other database maintenance chores. |
| | B) | Increased compatibility across platforms |
| | C) | Increased security |
| | D) | Limited compatibility across platforms. |
|
2003 McGraw-Hill Higher Education