MIS Chapter 4,5 Exam 2

question

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

administering the database
question

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

are usually open to the public
question

The purpose of a database is to ________.
answer

store lists of data involving multiple themes
question

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

Key
question

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

database management system (DBMS)
question

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

database application
question

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

relational
question

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

It was never a natural fit with business documents
question

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

storing data types such as images, audio, and videos in organizations
question

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

file
question

SQL stands for ________.
answer

Structured Query Language
question

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

reports
question

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

NoSQL DBMS
question

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

It is a character of data.
question

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

VisualBasic
question

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

record
question

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

metadata
question

In a database, columns are also called ________.
answer

fields
question

Which of the following is a function of the DBMS?
answer

processing a database by inserting or modifying data
question

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

administrative function
question

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

False
question

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

True
question

Most organizations develop their own database management systems.
answer

False
question

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

False
question

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

true
question

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

true
question

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

true
question

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

true
question

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

True
question

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

False
question

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

true
question

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

true
question

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

False
question

A DBMS is also referred to as a database.
answer

false
question

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

False
question

An Organization that hires cloud services________?
answer

Can limit the response time of its web pages
question

Which of the following services provides hardware, an operating system, and a database management system (DBMS) on a cloud-based offering?
answer

Platform as a service (PaaS)
question

Phobas Inc offers an online service which stores notes made by customers on the cloud. When a customer enters on one device, it gets updated in all the devices he/she owns. Which of the following cloud-based offerings is being provided to the customers?
answer

Software as a service (SaaS)
question

Which of the following statements is true about cloud computing?
answer

The elastic leasing of pooled computer resources over the Internet is called the cloud.
question

Which of the following is an advantage of using a private cloud over a virtual private cloud (VPC)?
answer

Unlike a VPC, a private cloud does not require permission from regulating bodies to host sensitive data.
question

Which of the following statements is true of content delivery networks (CDNs)?
answer

They reduce users’ access costs by delivering data faster.
question

Which of the following statements is true about cloud services?
answer

Financial institutions are not likely to hire cloud services from a vendor.
question

Cloud resources are pooled because many different organizations use the same physical hardware.
answer

true
question

Which of the following statements is true of private clouds?
answer

Idle servers in a private cloud cannot re-allocated to other organizations.
question

A tunnel is a virtual, private pathway over a public or shared network from the VPN (virtual private network) client to the VPN server
answer

True
question

Which of the following statements is true about the increase in popularity of cloud hosting?
answer

Virtualization allows instantaneous creation of new virtual machines.
question

An organization that hires cloud services ________.
answer

can limit the response time of its web pages
question

Which of the following is a reason why an internal information system (private internet) that uses Web services is not considered a cloud?
answer

The number of servers is fixed in a private internet and is not made elastic.
question

A VPC allows organizations to gain the advantages of cloud storage for the portion of data that need not be physically controlled.
answer

true
question

Using https instead of http ________.
answer

allows a packet sniffer to see only the site visited and nothing further detects the presence of packet sniffers in the vicinity
question

As standard practice, customers are regularly updated by cloud vendors about the location and number of copies made of their data
answer

false
question

Cloud computing is likely to lead to an increase in the number of technology-based startups.
answer

true
question

If software licensed from others is to be installed on the cloud, licenses for replication of software must be purchased
answer

true
question

A ________ is a system of hardware and software that stores user data in many different geographical locations and makes that data available on demand
answer

content delivery network
question

Which of the following statements is true of a virtual private cloud (VPC)?
answer

A VPC can be built on public cloud infrastructure.
question

Sireus Corp. is availing a cloud-based service. It plans to install a software package that will offer cloud services to its users. If it would like to avoid installing an operating system on the server, which of the following services should it choose?
answer

platform as a service (PaaS)
question

Which of the following is likely to be a consequence of cloud computing in the future?
answer

The cost of obtaining elastic resources will decrease.
question

An online service allows users to integrate their phonebook with their social media profiles and stores it on the cloud. The phonebook is updated with pictures of contacts when they are uploaded on social media sites. Which of the following cloud-based offerings is being provided to the users?
answer

software as a service (SaaS)
question

A routing server determines which CDN server should respond to a request in real-time
answer

true
question

Which of the following is true of a VPN (virtual private network)?
answer

A VPN communication is secure even though it is transmitted over the public Internet.
question

A content delivery network (CDN) provides a specialized type of PaaS.
answer

true
question

An elastic load balancer is a feature available in a private cloud that is not available in a private internet.
answer

true
question

Cloud-based hosting is preferred by organizations that are required by law to have physical control over their data.
answer

false

Get instant access to
all materials

Become a Member