Data Types and the Power of Databases (Practice Test)

The fact that databases are usually now available over networks has led to what extra responsibility for database administrators? 1. ensuring proper security measures for the database 2. managing web servers 3. ensuring that network transmissions are encrypted 4. all of the above

1

What term is used to search the data in a relation or relations and return only the data that fit specific parameters? 1. a query 2. a crawl 3. a request 4. a restriction

1

Which of the following database categories is the most similar to a spreadsheet or MS Excel document? 1. Flat File 2. Isolated 3. Relational 4. Hierarchical

1

Within a table that represents all the data in a relation, the individual rows are known as _____. 1. records 2. attributes 3. fields

1

At what point should a database programmer determine the data requirements for a database? 1. before beginning construction of the database 2. before entering any data into the database 3. when an error in the database is detected and needs troubleshooting 4. when designing reports that will be used to present information from the database on a regular basis

1

In a flat file database structure, can the data be sorted based on one particular attribute of the data? 1. Yes, but there is no good way to isolate the specified data fields from the rest of the fields in each record. 2. No, because the data is not structured, it cannot be sorted according to an attribute. 3. No, if you try to sort one attribute of the data, the fields for that attribute lose their connections with the records to which they belong. 4. Yes, but that attribute is the only attribute that can be shown for the data; the data in the rest of the record cannot be shown with it.

1

Which of the following skills are needed to assist with application design and development? Select all that apply. 1. performance tuning 2. schema development 3. maintenance 4. data integration

1, 2

Which of the following statements about data organization are correct? Select all that apply. 1. Not all records need to contain data about every attribute. 2. You cannot perform mathematical functions on string data. 3. A relationship may exist between each individual record. 4. The information in each record must refer to a person.

1, 2, 3

Why is it essential to know what information will be needed from the database from the outset of development? Select all that apply. 1. The developer can determine which data types would help fulfill the purpose. 2. The purpose determines the structure of the database. 3. By knowing the purpose, the developer can determine how many fields are needed in the database. 4. The number of fields in the database determines the cost of that database, so if careful planning doesn't occur, money can be wasted.

1, 2, 3

Indicate which of the following statements about databases and data types are accurate. Select all that apply. 1. Once the database is designed, the user doesn't need to worry about determining data types. 2. Numbers can be entered as text or as numeric values 3. A customer's first name and last name must be entered as two separate fields. 4. Uniform data types can be searched and sorted.

1, 2, 4

Which of the following are operations used to alter the data within a relation of a database? Select all that apply. 1. update 2. insert 3. join 4. delete

1, 2, 4

Which of the following are the three main categories of databases? Select all that apply. 1. Flat File 2. Hierarchical 3. Isolated 4. Relational

1, 2, 4

Which of the following would be a field in a database? Select all that apply. 1. 63.2% 2. Gender 3. 19943-5568 4. Sales

1, 3

All records in a relation share the same _____. 1. data 2. attributes 3. fields

2

If numbers are entered in a field designated for string data, what cannot be done with the numbers? 1. They cannot be accepted by the database. 2. They cannot be used for calculations. 3. They cannot be sorted or ordered. 4. All of the above

2

Which type of database is the most common structure for databases? 1. hierarchical database 2. relational database 3. SQL database 4. flat file database

2

A certain database structure organizes all of a business's contact information. It starts by naming all of the contacts. It then provides associated data fields for the phone number, email address, and other contact information for each individual contact. Under each of these fields for contact information, other fields that document the recent history of the business's actual communication and interaction with the contact are listed. Each entry is only associated with the contact type (phone, email, etc.) through which the communication took place. What type of database structure is described here? 1. SQL database 2. relational database 3. hierarchical database 4. flat file database

3

In order for a relational database to work, at least one of the fields has to contain unique values. What is the name of this field? 1. Unique projection 2. Unique database 3. Unique identifier 4. Unique relation

3

What is the focus of the list of responsibilities for database administrators? 1. performance tuning and design development 2. proper security measures and design development 3. design development and DBMS support 4. DBMS support and proper security measures

3

Which of the following are forms of queries? Select all that apply. 1. insert 2. database 3. join 4. projection

3, 4

Which of the following examples best describes hierarchical databases? Select all that apply. 1. A spreadsheet 2. Amazon's customer database 3. Parent-child relationships 4. A tree-like structure

3, 4

Database administrators might be involved with the integration of data from where? 1. Newer to older systems 2. DBMS to new systems 3. Local area networks to other networks 4. Older systems to new

4

Paula is working with a large database relation of information about automobile characteristics. There is so much information in each record that she is finding it difficult to focus on the data she finds relevant. She decides to instruct the database to show only the following attributes of the data: model name, model year, and horsepower. What type of operation has she done? 1. a join 2. a modification 3. a restriction 4. a projection

4

Which data type could not contain "0" as a part? 1. string data 2. numeric data 3. Boolean/logical data 4. It could be a part of all of the above.

4

Which of the following is not a common task of database administrators? 1. installation 2. maintenance 3. troubleshooting 4. All of these are common tasks of database administrators.

4