Have a Question ?

Home / Answered Questions / WPC 300 / wpc300-quiz-7-score-for-this-attempt-20-out-of-20-q-382

(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;


We have an Answer from Expert View Expert Answer

Expert Answer


 

We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month