(Solved): WPC 300: Quiz 8: Architecture | Started: Oct ...
Quiz 8: Architecture
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
Question 3 1 pts
_______ ensures that related data exist in parent table before allowing an entry into a child table.
- Data redundancy
- Data Integrity
- Referential integrity
Question 4 1 pts
Which of the following is not a component of the relational database?
- Relationship among rows in tables
Question 5 1 pts
“Google Doc” is an example of _______ in a could computing environment.
Question 6 1 pts
Which of the following tools help in periodic managerial decision-making?
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
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
Question 10 1 pts
Which of the following is a cloud service provider?