Operating Systems Overview

What is the primary function of a DBMS?

To provide security and data consistency
To process and administer the database (correct)
To define the data model
To create forms and reports

What type of language is used to process a database?

Java
Structured Query Language (SQL) (correct)
Python
C++

What is the purpose of a database application?

To create the data model for the database
To serve as an intermediary between users and database data (correct)
To provide a direct connection between users and the database
To administer the database and perform backups

What is the purpose of the entity-relationship data model?

To represent the logical structure of the database data and relationships (D) Signup and view all the answers

What is the role of user involvement in database development?

Users define the data model and design of the database (C) Signup and view all the answers

What is the purpose of locking in multi-user database processing?

To prevent the lost-update problem (B) Signup and view all the answers

What is the main purpose of a database?

To keep track of things (C) Signup and view all the answers

Which of the following statements about primary keys is correct?

A primary key is a column or group of columns that uniquely identifies a row in a table. (B) Signup and view all the answers

What is the purpose of a foreign key in a database?

To create relationships between tables in a database (D) Signup and view all the answers

Which of the following best describes metadata in the context of databases?

Metadata is data that describes the data stored in a database. (C) Signup and view all the answers

What is the primary function of a Database Management System (DBMS)?

To create, process, and administer a database (C) Signup and view all the answers

Which of the following statements about a database is correct?

A database is a self-describing collection of integrated records. (A) Signup and view all the answers

What is the primary role of an operating system?

To act as an intermediary between hardware and user (A) Signup and view all the answers

Which of the following is NOT a major category of operating systems?

Network OS (B) Signup and view all the answers

Which of the following is an example of a Nonmobile Client Operating System?

Linux (B) Signup and view all the answers

What is a software constraint for operating systems?

An operating system can only run on specific hardware (B) Signup and view all the answers

What is the difference between a native application and a web application?

Native applications are installed on the device, while web applications run in a browser (D) Signup and view all the answers

What is virtualization in the context of operating systems?

The process of running multiple operating systems on a single physical computer (D) Signup and view all the answers

What is a primary key in a database?

A field that identifies a unique row in a table (D) Signup and view all the answers

Which of the following is an example of a bad primary key?

Name field (D) Signup and view all the answers

What is a foreign key in a database?

A field used to connect to a field in another table (B) Signup and view all the answers

Why are currency fields considered bad primary keys?

Because currency values tend to change frequently (A) Signup and view all the answers

In a relational database, what is used to link tables together?

Foreign keys (C) Signup and view all the answers

What is the purpose of Business Process Model and Notation (BPMN)?

To represent business processes visually (D) Signup and view all the answers

What is the main difference between Server Virtualization and PC Virtualization?

Server Virtualization allows multiple virtual servers to run on a single physical server, while PC Virtualization allows a PC to host different operating systems. (A) Signup and view all the answers

What is the purpose of Desktop Virtualization?

To allow users to access their desktops remotely using any device with an internet connection. (B) Signup and view all the answers

What does a Site License authorize a company to do?

Install the product on all computers within the company or at a specific location. (B) Signup and view all the answers

What is the main characteristic of Application Software?

It is designed for specific tasks or functions, such as word processing or web browsing. (B) Signup and view all the answers

In what way does PC Virtualization differ from Desktop Virtualization?

PC Virtualization allows a PC to host different operating systems, while Desktop Virtualization separates a desktop environment remotely. (B) Signup and view all the answers