Deck 5: Database Processing

Question 1

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

A)foreign
B)discrete
C)continuous
D)relational

Answer 1

D

Question 2

Bytes,which are characters of data,are grouped into rows in a database.

Answer 2

False

Question 3

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

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

Answer 3

D

Question 4

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

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

Question 5

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

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

Question 6

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

Question 7

Special data that describe the data contained in a database are called ________.

A)metadata
B)primary data
C)closed matrices
D)open matrices

Question 8

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

A)special data that describes the structure of a database
B)special data that is unique to a specific user
C)data that cannot be used as an information resource
D)data that describes a Web page

Question 9

In a database,bytes are grouped into ________.

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

Question 10

What are the differences between a spreadsheet and a database?

Question 11

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

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

Question 12

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

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

Question 13

The purpose of a database is to ________.

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

Question 14

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

Question 15

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

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

Question 16

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

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

Question 17

In a database,columns are also called ________.

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

Question 18

In a database,rows are also called ________.

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

Question 19

In a database,columns are also called records.

Question 20

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)discrete
C)continuous
D)relational

Question 21

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

Question 22

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

Question 23

Monitoring the performance of a database after providing solutions for improving its performance is a(n)________ of the DBMS.

A)processing operation
B)modification function
C)administrative function
D)creation function

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 considered an administrative function of the DBMS?

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

Question 26

Which of the following is a function of the DBMS?

A)eliminating bottlenecks in business processes
B)analysing business data to predict future performance
C)processing a database by inserting or modifying data
D)automating workflows in companies

Question 27

What are relational databases? What has led to the development of new nonrelational styles of database processing?

Question 28

In a database,a group of similar rows or records is called a table.

Question 29

Describe the contents of a database.

Question 30

Describe the usefulness of metadata.

Question 31

________ is an international standard language that is used for processing a database.

A)Structured Query Language
B)Sybase Language
C)Dynamic HTML
D)Hypertext Markup Language

Question 32

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

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

Question 33

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

Question 34

One of the important functions of a DBMS is to provide the necessary tools for ________.

A)encapsulating data objects
B)testing program codes
C)administering the database
D)encrypting e-mails

Question 35

Which of the following is a DBMS product from Microsoft?

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

Question 36

The DBMS provides applications for processing operations such as ________.

A)automating business processes
B)inserting or deleting data
C)sending and receiving emails
D)writing software programs

Question 37

________ is a popular enterprise DBMS product from IBM.

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

Question 38

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

Question 39

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n)________ of the DBMS.

A)administrative function
B)creation function
C)processing operation
D)modification function

Question 40

SQL stands for ________.

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

Question 41

DBMS administrative functions include adding structures to improve the performance of database applications.

Question 42

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

Question 43

Explain database management systems (DBMS).

Question 44

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

Question 45

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

A)highly recommended because any technology-tolerant business professional can use NoSQL
B)unnecessary in cases where relational databases meet the needs of organisations
C)very cost-effective,but can be enormously disruptive
D)highly efficient and is being practiced by many organisations

Question 46

Define SQL.

Question 47

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

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

Question 48

DB2 is a popular DBMS product that is licensed from Microsoft.

Question 49

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

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

Question 50

The administrative functions of a DBMS include backing up database data.

Question 51

Describe the functions of a database management system.

Question 52

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

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

Question 53

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

Question 54

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

Question 55

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

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

Question 56

How does one create a database and its structures?

Question 57

SQL statements can be issued directly to the DBMS by an application program.

Question 58

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

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

Question 59

Most organisations develop their own database management systems.

Question 60

A DBMS is also referred to as a database.

Question 61

Which of the following is a major problem posed by multi-user processing of a database?

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

Question 62

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

Question 63

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

A)dimension table
B)database administrator
C)knowledge management system
D)database application

Question 64

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)queries
C)application programs
D)forms

Question 65

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

Question 66

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

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

Question 67

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

A)VisualBasic
B)Structured Query Language
C)Datalog
D)Information Systems Base Language

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

All traditional databases require the Internet to transmit traffic between a user's computer and a DBMS server computer.

Question 73

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

Question 74

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

A)fail to support graphical queries
B)have no security requirements
C)mostly run within a corporate network that is protected from the Internet
D)are usually open to the public

Question 75

What is a NoSQL DBMS?

Question 76

What is a database application?

Question 77

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

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

Question 78

Browser database application forms,reports,and queries are displayed and processed using html.

Question 79

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

Question 80

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

A)They use C++ as the standard language for user-side processing.
B)The application,DBMS,and the database all reside on the user's computer.
C)They are written in object-oriented languages like Structured Query Language.
D)They are thin-client applications that need not be pre-installed on a user's computer.