Computer Science: Database Systems

BlamelessJuniper avatar
BlamelessJuniper
·
·
Download

Start Quiz

Study Flashcards

36 Questions

Why would an application need a database for persistent data storage?

To save a customer's order information

Which of the following scenarios does not require a database for persistent data storage?

A student creates and saves a graphic image

What type of permission should Alex, a system administrator, grant to a user to allow them to view and change files but not change permissions?

Modify permission

Which of the following is an example of a scenario where a database would not be necessary for data storage?

A student creates and saves a graphic image

What is a common use case for a database in an application or utility?

Storing customer information for an online order

Which of the following statements is true about compiled languages?

They execute faster than interpreted languages

What type of software is designed to increase efficiency and organization?

Productivity software

What type of database feature provides a formatted, easy-to-read listing of the results of a query?

Form

Which of the following is a primary concern when it comes to sensitive information on a device?

Data security

What is the primary purpose of using a form in a database?

To present data

What is the best way to improve the security of sensitive information on a device if it is lost or stolen?

Encrypting the data

What type of software is designed to facilitate communication and collaboration between teams?

Collaboration software

What type of wiring is commonly used in a Local Area Network (LAN)?

Copper wiring

What is a critical component of a computer that connects to a LAN?

Network interface (adapter)

Which of the following digital communication media does not rely on the Internet?

SMS

What is a common application of Near Field Communications (NFC)?

Mobile payment

What is a network protocol used for in a LAN?

To facilitate communication between devices

What should be covered in a company's internet usage policy?

Appropriate use of company resources

What is a benefit of using Fiber optics in a LAN?

It offers higher bandwidth and faster data transfer rates

What is a characteristic of a Local Area Network (LAN)?

It is a private network that connects devices in a limited area

What is the primary concern when it comes to sensitive information on a device?

data protection

Which type of chip is responsible for processing audio input from a microphone and converting it into data?

DSP

What is the term used to describe computer systems that are interconnected to share information with each other?

Network clients

What is the primary purpose of a DSP chip?

To process audio input

What is the main benefit of using security controls?

To protect sensitive information

What is the primary function of a DLP chip?

To control access to sensitive information

What is the main benefit of using secure transactions?

To protect sensitive information during data transfer

What is the term used to describe the process of converting audio input into data?

Digital signal processing

When troubleshooting an issue, what is the MOST likely first step that should be taken?

Uninstall the last application or system update that was installed

What is an advantage of DisplayPort 1.4 over HDMI 2.0?

DisplayPort has a greater maximum bandwidth than HDMI

What data type is BEST suited for a software developer creating a variable to hold whole numbers and perform numeric operations?

Integer

What is the primary reason to uninstall the last application or system update that was installed when troubleshooting?

To revert to a known good state

Why is DisplayPort 1.4 a better choice for high-resolution displays?

It has a greater maximum bandwidth than HDMI 2.0

What is the primary benefit of checking the voltage levels on the DC side of the power supply when troubleshooting?

To verify proper power supply function

What is the best course of action when a software developer encounters an error when running their application?

Uninstall the last application or system update that was installed

What is the primary advantage of using an Integer data type in software development?

It is used for whole numbers

Study Notes

Database and Persistence

  • A database is needed for persistent data storage in scenarios where data needs to be retained even after the application or utility is closed, such as when a customer fills out an online form to order a product.

File Permissions

  • To grant a user permission to view and change files but not change permissions, the NTFS permission "Modify" should be used.

Database Features

  • A "report" is a database feature that provides a formatted, easy-to-read listing of the results of a query.

Security

  • To improve the security of sensitive information on a device if it is lost or stolen, encryption should be used.

Digital Communication Media

  • SMS (Short Message Service) is a digital communication media that does not require a connection to the internet.

Employee Internet Usage

  • An employee handbook should cover topics such as internet usage, including policies on acceptable use, data protection, and security.

Troubleshooting

  • The first step in troubleshooting an issue should be to identify the problem and then take steps to resolve it, such as uninstalling the last application or system update that was installed.

DisplayPort

  • DisplayPort 1.4 has a greater maximum bandwidth than HDMI 2.0.

Data Types

  • The best data type for a variable that will hold whole numbers and perform numeric operations is an integer.

Audio Processing

  • The DSP (Digital Signal Processing) chip is responsible for processing audio input from a microphone and converting it into data.

Computer Systems

  • Computer systems that are interconnected to share information with each other are called network clients.

This quiz assesses knowledge of database systems, including scenarios that require persistent data storage. It covers concepts related to compiled languages and interpreted languages.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Get started for free

More Quizzes Like This

Use Quizgecko on...
Browser
Browser