MIS Chapter 4,5 Exam 2

one of the important functions of a DBMS is to provide the necessary tools for ________.
administering the database
Browser-based database applications differ from traditional applications in that they ________.
are usually open to the public
The purpose of a database is to ________.
store lists of data involving multiple themes
in a database, a ________ is a column or group of columns that identifies a unique row in a table
Key
A(n) ________ is a program that is used to create, process, and administer a collection of self-describing integrated records.
database management system (DBMS)
A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data
database application
Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.
relational
Which of the following is a drawback of the relational database processing model?
It was never a natural fit with business documents
One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________.
storing data types such as images, audio, and videos in organizations
In a database, a table, which is a group of similar rows, is also called a ________.
file
SQL stands for ________.
Structured Query Language
Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations?
reports
________ refers to software systems that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud
NoSQL DBMS
Which of the following best describes a byte in a database?
It is a character of data.
Traditional database application programs are written in object-oriented languages like ________.
VisualBasic
In a database, the collection of data for all columns is called a ________
record
Special data that describe the data contained in a database are called ________.
metadata
In a database, columns are also called ________.
fields
Which of the following is a function of the DBMS?
processing a database by inserting or modifying data
Monitoring the performance of a database after providing solutions for improving its performance is a(n) ________ of the DBMS
administrative function
Reports in database applications provide security, data consistency, and special-purpose processing.
False
A database application serves as an intermediary between users and database data.
True
Most organizations develop their own database management systems.
False
Security requirements are more stringent for traditional applications than for browser-based ones.
False
In a database, a key is a column or group of columns that identifies a unique row in a table.
true
The format of the metadata in a database depends on the software product that is processing the database.
true
Databases are required to keep track of lists with multiple themes.
true
In single-user databases, the application, the DBMS, and the database all reside on a user’s computer
true
DBMS administrative functions include adding structures to improve the performance of database applications.
True
In a database, the collection of data for all columns is called a file.
False
SQL statements can be issued directly to the DBMS by an application program.
true
Browser database application forms, reports, and queries are displayed and processed using html.
true
MySQL DBMS refers to software systems that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.
False
A DBMS is also referred to as a database.
false
Bytes, which are characters of data, are grouped into rows in a database.
False
An Organization that hires cloud services________?
Can limit the response time of its web pages
Which of the following services provides hardware, an operating system, and a database management system (DBMS) on a cloud-based offering?
Platform as a service (PaaS)
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?
Software as a service (SaaS)
Which of the following statements is true about cloud computing?
The elastic leasing of pooled computer resources over the Internet is called the cloud.
Which of the following is an advantage of using a private cloud over a virtual private cloud (VPC)?
Unlike a VPC, a private cloud does not require permission from regulating bodies to host sensitive data.
Which of the following statements is true of content delivery networks (CDNs)?
They reduce users’ access costs by delivering data faster.
Which of the following statements is true about cloud services?
Financial institutions are not likely to hire cloud services from a vendor.
Cloud resources are pooled because many different organizations use the same physical hardware.
true
Which of the following statements is true of private clouds?
Idle servers in a private cloud cannot re-allocated to other organizations.
A tunnel is a virtual, private pathway over a public or shared network from the VPN (virtual private network) client to the VPN server
True
Which of the following statements is true about the increase in popularity of cloud hosting?
Virtualization allows instantaneous creation of new virtual machines.
An organization that hires cloud services ________.
can limit the response time of its web pages
Which of the following is a reason why an internal information system (private internet) that uses Web services is not considered a cloud?
The number of servers is fixed in a private internet and is not made elastic.
A VPC allows organizations to gain the advantages of cloud storage for the portion of data that need not be physically controlled.
true
Using https instead of http ________.
allows a packet sniffer to see only the site visited and nothing further
detects the presence of packet sniffers in the vicinity
As standard practice, customers are regularly updated by cloud vendors about the location and number of copies made of their data
false
Cloud computing is likely to lead to an increase in the number of technology-based startups.
true
If software licensed from others is to be installed on the cloud, licenses for replication of software must be purchased
true
A ________ is a system of hardware and software that stores user data in many different geographical locations and makes that data available on demand
content delivery network
Which of the following statements is true of a virtual private cloud (VPC)?
A VPC can be built on public cloud infrastructure.
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?
platform as a service (PaaS)
Which of the following is likely to be a consequence of cloud computing in the future?
The cost of obtaining elastic resources will decrease.
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?
software as a service (SaaS)
A routing server determines which CDN server should respond to a request in real-time
true
Which of the following is true of a VPN (virtual private network)?
A VPN communication is secure even though it is transmitted over the public Internet.
A content delivery network (CDN) provides a specialized type of PaaS.
true
An elastic load balancer is a feature available in a private cloud that is not available in a private internet.
true
Cloud-based hosting is preferred by organizations that are required by law to have physical control over their data.
false