Practice Questions - DB Management

What is the required speed of processor for installing Microsoft SQL Server 2017?

1.4 GHz

Approximately how many potential web application users are there on the planet as of 2020?

4.6 billion

Which of the following are characteristics of web applications?

All of the answers are correct.

Which of the following is a characteristic of .NET?

All of these answers are correct

What tools does a data warehouse use?

All of these answers are correct.

What would be an example of a violation of the principle of confidentiality?

An employee accessing a payroll database to find out how much others are paid

You are planning a vacation to Europe next summer after saving money over several years. You go online and select an airline flight to take you there on your desired travel date and time. You select your preferred seat and complete the transaction. The airline later sends you a confirmation message but the booking includes a different flight and time. What problem most likely occurred during transaction processing?

An error was made during the data collection phase booking you on a different flight.

Which of the following is NOT a feature of .NET?

An inconsistent look and approach

Which of these is the best example of data mining?

Baseball statistics

The .NET framework consists mostly of what?

Classes (objects)

Which of the following statements about cloud computing is INCORRECT?

Cloud computing gives you unlimited storage capacity

What is the primary advantage of using a distributed database?

Data access and processing are much faster.

Which of the following is NOT a typical activity of a Transaction Processing System?

Data analysis

What type of information is generally referred to as big data?

Digital data

For deep, incredibly complex data sets, the _____ database is an applicable solution.

Document-based

Which of the following is NOT a factor in the number of storage devices available?

Features

Which of the following categories is concerned exclusively with electronics-based storage?

Flash

What is TRUE about flash memory?

Flash memory is portable and can retain data without power

Which of the following is not a benefit of cloud computing?

Improved security due to centralized data storage

_____ refers to the process of making sure only those who are entitled to information can access it?

Information security

What is the main distinguishing feature of a batch processing system?

It accumulates one or more transactions over a period of time before processing them at a later scheduled time.

Which of the following is true of a class diagram?

It can be used as a blueprint to build a system

Which BEST describes the state of analysis of big data?

It is a rough idea, but getting better every day.

Which of the following is NOT true of a data warehouse?

It is one large database that is stored in a large building.

In T-SQL what does the size option, that is used when creating a database, allow you to do?

Lets you decide how big your database will be when initially created.

Which of these does not support security encryption?

MS Access

What device was the first electronic data storage device?

Manchester Mark I Williams-Kilburn tube

What type of hard disk formatting is recommended for Microsoft SQL Server 2017 installation?

NTFS or ReFS

Which of the following is a category of dynamic storage?

None of these

NoSQL can be referred to as:

Not Only SQL

Which one of the following database software options uses an object-relational model?

Oracle

SQL was released by _____ and created by _____.

Oracle, IBM

The _____ ensures that people only have access to the information they need to do their jobs.

Principle of least privilege

Which of the following is NOT a use for an SQL trigger?

Storing Information

What is big data?

The area of science and technology that deals with information sets that are too large to be handled by traditional means.

What is the reason why web applications have a significant effect on BIS?

The large number of people worldwide with Internet access

.NET is meant to save a developer _____ on the mundane things.

Time and energy

What is the minimum operating system requirement for installing Microsoft SQL Server 2017 Developer edition?

Windows 8 Enterprise

We use the keyword '_____' to signify that there is more than one instruction in the trigger to be executed.

atomic

Which of the following uses platters and heads?

hard drives

methods can be

in a UML. methodname()

Database triggers are most commonly applied to _____.

tables