# Question 8 1 1 point identify the best data type to

• Test Prep
• thesherif90
• 107
• 80% (5) 4 out of 5 people found this document helpful

This preview shows page 45 - 51 out of 107 pages.

Question 8 1 / 1 point Identify the best data type to store an Algonquin's Student Number. The number should be exactly 9 digits in length. The length is unlikely to change for at least 15 years. There are no arithmetic calculations to be performed on the Student Number. All 9 elements of the student number are numerical. Question options: CLOB TEXT CHAR
INTEGER VARCHAR Attempt Score: 9 / 9 Overall Grade (highest attempt) : 9 / 9 Done skip to main content Quiz Submissions - Hybrid - VIEW Mohamed El Sherif (username: elsh0030) Attempt 3 Written: Feb 25, 2019 3:32 PM - Feb 25, 2019 3:33 PM Submission View Released: Jan 2, 2019 9:25 AM Question 1 1 / 1 point Which one the following view will use disk space for data .
Virtual Table Logical View Materalized View Question 2 1 / 1 point virtual table or logical view are other names for Question options:
Question 3 4 / 4 points Identify the advantages and characteristics of a Materialized View.
Question options: Less recent data is obtained with the advantage of saving CPU time. Materialized views do not need refreshing. Materialized views do not occupy hard disk space. The result from a Materialized view will always show the most updated result set, i.e. each time the table is updated the new data is shown in the Materialized view. Materialized view need refreshing each time an updated result is required. Queries that are CPU intensive can be run periodically instead of running them each time a report is needed. Materialized views occupy hard disk space. Question 4 1 / 1 point What will the following SQL statement do? CREATE VIEW Asia_V AS SELECT * FROM Country WHERE CONTINENT = 'Asia'; Question options:
create a dynamic view create a materalized view create a table called Asia_V Question 5 1 / 1 point A database administrator decides to DROP a dynamic view. The data in the original table will also be deleted because the tables will also be dropped. Question options:
Question 6 2 / 2 points Identify two advantages of dynamic views
It can override primary and foreign key constraints. It can replace a data administrator and database administrator. It can draw and ERD automatically without a diagramming tool.