(Solved): WPC 300: Quiz 8: Architecture | Started: Oct ...

WPC 300

Quiz 8: Architecture
Started: Oct 

Quiz Instructions
Note: this is a timed quiz. You may check the remaining time you have at any point while taking the quiz by pressing the keyboard combination SHIFT, ALT, and T... Again: SHIFT, ALT, and T...
 
Question 1                               1 pts
The SQL code to extract only first_name information for all records of the “Actor” table below is:

• SELECT * FROM Actor;
• SELECT Actor FROM first_name;
• SELECT first_name FROM Actor;
• SELECT * FROM Actor WHERE first_name = "NICK”;

Question 2                    1 pts
When you are asked to design a database for the airline ticket reservation system, based on an Entity-Relationship Data model, which of the following could be an example of “entity”?

• Flight Number
• Destination city
• Arrival time
• Traveler

Question 3                    1 pts
_______ ensures that related data exist in parent table before allowing an entry into a child table.

• Data redundancy
• SQL
• Data Integrity
• Referential integrity

 
Question 4                          1 pts
Which of the following is not a component of the relational database?

• Analysis
• Relationship among rows in tables
• Tables
• Metadata

Question 5                     1 pts
“Google Doc” is an example of _______ in a could computing environment.

• SaaS
• IaaS
• PaaS
• Virtualization

Question 6                     1 pts
Which of the following tools help in periodic managerial decision-making?

• OLTP
• Servers
• OLAP
• Database

Question 7                       1 pts
When you access information from two different tables connected by an identifier key, the SQL keyword you should use is _______.

• INNER JOIN
• GROUP BY
• ORDER BY
• COUNT

Question 8                   1 pts
Which of the following is an important task of a database management system?

• Provides support such as performing maintenance and routine backups.
• Helps create rules for data analysis
• Provides unauthorized access to data when authentication fails
• Helps collect data from vendors

 
Question 9                1 pts
You are creating a database to store temperature and wind data from various airport. Which of the following fields is the most likely candidate to use as the basis for a Primary Key in the Airport Table?

• Airport Code
• Address
• City
• State

 
Question 10                  1 pts
Which of the following is a cloud service provider?

• VMWare
• Gmail
• Dropbox
• iCloud