Deck 5: Database Processing

Question 1

Which of the following is an international standard language for querying databases?

A) C++
B) SQL
C) Python
D) Visual Basic

Answer 1

B

Question 2

Which of the following best describes a byte in a database?

A) It is a character of data.
B) It is a group of rows.
C) It is a collection of data.
D) It is a group of columns.

Answer 2

A

Question 3

Howie is a business analyst who is given access to the database of a product prior to its launch. He needs to understand the data presented and take appropriate action. Which of the following is Howie most likely to do?

A) send the database back to the source to interpret the data
B) use the data present in the database in its raw format
C) encrypt the data to secure the product's authenticity
D) use SQL or graphical tools to query the database

Answer 3

D

Question 4

In a database, a table is formally referred to as a ________.

A) matrix
B) field
C) record
D) relation

Question 5

In a database, a table is also called a ________.

A) record
B) matrix
C) file
D) field

Question 6

Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.

A) hierarchical
B) network
C) relational
D) object

Question 7

Bytes are grouped into rows in a database.

Question 8

In a database, a column or group of columns that identifies a unique row in a table is known as a ________.

A) field
B) record
C) file
D) key

Question 9

In a database, a group of similar rows is called a ________.

A) table
B) record
C) field
D) matrix

Question 10

The purpose of a database is to ________.

A) test and troubleshoot newly installed software
B) design the source code for computer programs
C) describe and build computer architectures
D) store lists of data involving multiple themes

Question 11

Which of the following best describes the metadata in a database?

A) programs used to create, process, and administer a database
B) special data that describes the structure of a database
C) data that is stored in a Web site
D) special data that is unique to a specific user

Question 12

A ________ is a self-describing collection of integrated records.

A) datasheet
B) dataflow
C) database
D) dataspace

Question 13

Google is a database that is used by Facebook and Twitter.

Question 14

In a database, bytes are grouped into ________.

A) tables
B) columns
C) rows
D) records

Question 15

Databases are static and it is only the information systems that change.

Question 16

In a database, columns are also called ________.

A) records
B) tables
C) files
D) fields

Question 17

In the context of data storage, explain the difference between a spreadsheet and a database.

Question 18

Databases are required to keep track of lists with multiple themes.

Question 19

In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys.

A) foreign
B) alternate
C) relational
D) candidate

Question 20

In a database, rows are also called ________.

A) records
B) fields
C) tables
D) files

Question 21

Describe the merits of metadata.

Question 22

Describe the elements in a database.

Question 23

The format of the metadata in a database depends on the software product that is processing the database.

Question 24

In a database, a key is a column or group of columns that identifies a unique row in a table.

Question 25

Which of the following is a function of the database management system (DBMS)?

A) implementing lean systems in workstations
B) eliminating bottlenecks in business processes
C) automating workflows in the databases of companies
D) processing a database by inserting or modifying data

Question 26

________ is a popular enterprise database management system (DBMS) product from IBM.

A) DB2
B) Access
C) SQL Server
D) MySQL

Question 27

To find out what a database contains, one can look at the metadata inside the database.

Question 28

SQL stands for ________.

A) Standard Query Language
B) Secondary Query Language
C) Structured Query Language
D) Simplified Query Language

Question 29

A(n) ________ is a program that is used to create, process, and administer a collection of self-describing integrated records.

A) decision support system (DSS)
B) knowledge management system (KMS)
C) database management system (DBMS)
D) enterprise planning system (EPS)

Question 30

In a database, the collection of data for all columns is called a file.

Question 31

Access and SQL Server are popular ________ DBMS products.

A) open source
B) IBM
C) Oracle Corporation
D) Microsoft

Question 32

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.

A) encrypting emails
B) encapsulating data objects
C) administering the database
D) testing program codes

Question 33

Which of the following is a database management system (DBMS) product from Microsoft?

A) MySQL
B) SQL Server
C) DB2
D) Sybase ASE

Question 34

The database management system (DBMS) provides applications for processing operations such as ________.

A) sending and receiving emails
B) generating software codes
C) inserting or deleting information
D) automating business processes

Question 35

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

Question 36

In a database, columns are also called records.

Question 37

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.

A) processing
B) administration
C) creation
D) modification

Question 38

Which of the following is considered an administrative function of the database management system (DBMS)?

A) adding structures to improve the performance of database applications
B) testing program codes in the system for errors
C) creating tables, relationships, and other structures in databases
D) using international standard languages for processing database applications

Question 39

Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________.

A) creation
B) modification
C) processing
D) administration

Question 40

What are relational databases? Discuss their drawbacks that led to the development of nonrelational style of database processing.

Question 41

Structured query language statements can be issued directly to the database management system (DBMS) by an application program.

Question 42

Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?

A) reports
B) application programs
C) queries
D) forms

Question 43

Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations?

A) queries
B) forms
C) reports
D) application programs

Question 44

Browser-based database applications differ from traditional applications in that they ________.

A) have no security requirements
B) are used only by corporates
C) are usually open to the public
D) fail to support graphical queries

Question 45

Discuss the creation of a database. Explain its working.

Question 46

Most organizations develop their own database management systems.

Question 47

What is a database management system (DBMS)? Explain with suitable examples.

Question 48

Describe the functions of a database management system (DBMS).

Question 49

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

A) database application
B) metadata table
C) database hierarchy
D) dimension table

Question 50

DB2 is a popular database management system product that is licensed from Microsoft.

Question 51

Database management system (DBMS) administrative functions include adding structures to improve the performance of database applications.

Question 52

A database management system is also referred to as a database.

Question 53

HyperText Markup Language is an international standard language for processing a database.

Question 54

Which of the following is TRUE of browser-based database applications?

A) They are written in object-oriented languages such as Structured Query Language.
B) The application, database management system (DBMS), and the database reside on the user's computer.
C) They are displayed and processed using html, html5, or css3.
D) They use C++ as the standard language for user-side processing.

Question 55

Which of the following is a major drawback of multi-user processing of a database?

A) lack of data integrity
B) software redundancy
C) lost-update problem
D) limited access to data

Question 56

Which of the following elements of a database application provides security, data consistency, and special-purpose processing?

A) query applications
B) application programs
C) reports
D) forms

Question 57

Define Structured Query Language (SQL).

Question 58

Traditional database application programs are written in object-oriented languages like ________.

A) Pascal
B) Visual Basic
C) Datalog
D) Unigraphics

Question 59

The database management system (DBMS) can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.

Question 60

The administrative functions of a database management system (DBMS) include backing up database data.

Question 61

All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS) server computer.

Question 62

In single-user databases, the application, the database management system (DBMS), and the database all reside on a user's computer.

Question 63

Browser database application forms, reports, and queries are displayed and processed using HyperText Markup Language (HTML).

Question 64

Which of the following is a drawback of the relational database processing model?

A) It utilized an extensive amount of storage space.
B) It required powerful processors to function.
C) It was never a natural fit with business documents.
D) It did not enable document piece-making via normalization.

Question 65

The conversion of the existing traditional databases in organizations to NoSQL databases is ________.

A) highly efficient and is being practiced by many organizations
B) highly recommended because it is user friendly
C) very cost-effective but can be enormously disruptive
D) unnecessary when relational databases meet the needs of organizations

Question 66

What is an in-memory database management system?

Question 67

Security requirements are more stringent for traditional applications than for browser-based ones.

Question 68

Reports in database applications provide security, data consistency, and special-purpose processing.

Question 69

What is a database application?

Question 70

Traditional database application programs are written in object-oriented languages such as C++.

Question 71

Which of the following is TRUE of the relational database processing model?

A) It supports very high transaction rates.
B) It can efficiently store files with large collections of bits.
C) It helps organizations store new data types such as images, audio, and videos.
D) It represents relationships with the help of foreign keys.

Question 72

Browser applications are thin-client applications that need not be preinstalled on the users' computers.

Question 73

________ refers to software products that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.

A) NoSQL DBMS
B) MySQL DBMS
C) Traditional DBMS
D) Relational DBMS

Question 74

Queries in database applications present data in a structured manner using operations such as sorting, grouping, and filtering.

Question 75

One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________.

A) storing data types such as images, audio, and videos in organizations
B) gaining faster performance by limiting the number of servers used
C) breaking up sales orders via normalization
D) limiting the use of open-source document-oriented DBMS

Question 76

A database application serves as an intermediary between users and database data.

Question 77

NoSQL database management system products are very technical and can be used only by those with a deep background in computer science.

Question 78

The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

Question 79

Which of the following is a nonrelational data store developed by Amazon.com?

A) Bigtable
B) Dynamo
C) Cassandra
D) MongoDB

Question 80

Which of the following is an open source document-oriented NoSQL DBMS product?

A) Access
B) MongoDB
C) SQL Server
D) DB2