ITF Domain 5 review

What would a logically organized collection of data be called?

• Datasheet

• Database

• Record

• Field

Which of the following is most similar to what a database looks like? Select the best answer.

• Word document

• PowerPoint presentation

• An email application like Outlook

• Excel spreadsheet

When a database is required to keep track of more data than a flat file has the capacity for, a second table is employed in order to keep the data separate while storing more information. What is a database with multiple linked tables called?

• Relational

• Interactive

• Relative

• Tangent

Excel workbooks cannot be used by more than one user at a time because Excel will lock a file that is opened by a user. The file cannot be accessed by another user until the original user has saved the file and closed it. What feature in a database allows more than one user to access the data at the same time?

• Multi-user

• Multiple Simultaneous Users

• Multiple Concurrent Users

• Synchronized User Access

What is the default number of concurrent connections Microsoft SQL Server allows?

• 16,492

• 83,412

• 32,768

• 44,000

A new Microsoft SQL Server is being installed in your office. You had the opportunity to view the server configuration and you noticed that it has a Terabyte of RAM, dual processors, and an SSD (Solid State Drive). Which of the following database features do you think this configuration will help the most? Select the best answer.

• Multiple concurrent connections

• Speed

• Scalability

• Variety of Data

Designing databases that store numbers and text is common, however designing databases to store images or other types of media files is also important. Which database feature should be considered when storing additional files types?

• variety of data

• Number of Records

• Speed

• Scalability

What does each column represent in a database?

• Field

• Record

• Table

• Datasheet

What is each row called in a database?

• Table

• Record

• Datasheet

• Catalog

What defines the rules and structure of a database?

• Flowchart

• Diagram

• Schema

• Representation