Module 2-4:: Part 1 of 2

What type of flat file contains plain text with delimiters to set apart the columns?

• Comma Separated Values (CSV)

• A relational table

• A spreadsheet

• A bitmap file (BMP)

• A leather glove (ALG)

Which of the following statements best describes data persistence?

• Data in memory is lost once the processing is completed. Data in a database is stored persistently and securely so that it can be used again in the future.

• Persistent data in a database consists of that group of rows in a table that is viewed and updated most frequently.

• Data in a database is protected by a password and persistently checked against intrusion.

• Data persistence refers to the length of time an item of data is stored after it is no longer of value to the user.

• Data ran a marathon yesterday and didnt stop for water a single time.

Microsoft SQL Server is an example of what?

• RDBMS

• Relational database

• Database server

• Query/report builder

• Absolute power

A manager needs to view last month’s sales figures. Which of the following functionalities can be done with a query statement?

• Specifying criteria to match values in one or more fields

• Formatting the output to look better for a management meeting

• Summarizing the data to provide statistics and totals

• Eliminating rows from the table that aren't included in last month’s figures

• Can make a delicious coffee to be consumed prior to more database activity.

Which would be the LEAST desirable architecture option for a database that requires a high degree of scalability?

• one-tier

• two-tier

• three-tier

• N-tier

In which order are the rows typically stored in a relational table?

• The order in which they were entered into the database

• Ascending alphabetical order

• Ascending numeric order

• Random order

What is the relationship between queries and reports?

• A query selects and retrieves the correct data, whereas a report formats and summarizes the output.

• A query produces output on the screen and a report produces output on the printer.

• A report filters the data values to provide only the needed data and a query retrieves it.

• “Report” and “query” are really two terms for the same thing.

• They are besties. They even borrow one another's clothes and finish one another's sentences.

Which is the BEST example of importing data to populate a database?

• Data records that are already stored in a digital format can be loaded directly into a database.

• Data can be read from a form and, using a keyboard as an input device, keyed into a similar form on a computer.

• Data can be loaded via voice recognition using a microphone as the input device.

• Data can be scanned from a paper document using character recognition software and hardware.

• Impregnating a database with data from another database using a rubber glove and a large dropper.

Why is the level of data integrity greater in a database than in a flat file?

• A database can enforce data types for each column in a table, and can validate data as it is entered into those columns.

• Users are more careful when they enter data into a database.

• A database is backed up so that data cannot be lost, while a flat file is never backed up.

• The items/fields of data in a flat file are added randomly to each row/record, so there isn't a way to know where a specific piece of data is in a given row.

When processing large numbers of transactions, how does processing speed compare between databases and flat file systems?

• Database processing speeds are much faster than flat file speeds.

• Flat files’ processing speeds are much faster than database processing speeds.

• The speed of processing transactions is the same whether the data is stored in a flat file or a database.

• Flat file processing speeds are faster than database processing speeds if the computer’s processor is slower than average.