(Solved): WPC300 QUIZ 7 | Score for this attempt: 20 out of 20...

WPC300 QUIZ 7
Score for this attempt: 20 out of 20
Submitted Feb 27 at 10:41pm
This attempt took 2 minutes.

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

• ORDER BY
• INNER JOIN 
• GROUP BY
• COUNT

 
Question 2
Which of the following is a cloud service provider?

• iCloud   
• VMWare  
• Dropbox
• Gmail

 
Question 3
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?

• Address
• Airport code   
• State
• City

 
 
Question 4
Which of the following is true focus of Information Architecture?

• Deliver information to the client where there is a misunderstanding
• Making all information easy to find
• Make only irrelevant information easy to find
• Make the information hard to find

  
Question 5
Which of the following is not a traditional data architectural process?

• Visual
• Logical
• Physical
• Conceptual

  
Question 6
Which of the following is not a component of relational database?

•  Metadata
• CPU of Database Server
• Relationship among rows in tables
• Tables

  
Question 7
Which of the following is an important task of a database management system?

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

  
Question 8
When are asked to design a database for airline ticket reservation system, based on an Entity Relationship Data model, which of the following could be an example of "entity"?

• Flight Number
• Traveler
• Arrival time
• Destination city

  
Question 9
Which of the following tools help in periodic managerial decision-making?

•  Database
• Servers
• OLTP
• OLAP

 
Question 10
The SQL code to extract only departure time information for all records of the following "Flight" table is:

• SELECT * FROM Flight WHERE To = "LGA (New York City)";
• SELECT Flight # FROM Departs;
• SELECT Departs FROM Flight;
• SELECT * FROM Flight;