MIS Chapter 4,5 Exam 2 – Flashcards
Unlock all answers in this set
Unlock answersquestion
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
