Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-quiz-8-architecture-started-oct-q-238

(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


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