Conceptual level deals with the modeling of the whole database A logical unit of work that is guaranteed either to execute in its entirely (all of its operations execute) or not to execute at all CPS 510 Final Exam Actual Questions and Answers Latest Update 100% Correct Question 1 (1 point) Saved
In the three levels architecture:
Question 1 options:
Internal level models a user oriented description of the part of the database External level deals with the modeling of the whole database None of these options External level shows how data are stored inside the system Question 2 (1 point) Saved
A transaction is:
Question 2 options:
A logical unit of work that always terminates normally A logical unit of work that always terminates abnormally All of the above None of these options 1 / 4
Question 3 (1 point) 2 / 4
Saved
The tables STUDENT and TA are as the follows:
Which of the following tables is TA union
STUDENT ? Question 3 options:
There is no result because TA and STUDENT are not union compatible tables None of these options Questions 4 to 7 3 / 4
It finds the average GPA of all students by excluding the NULL values of GPA from the average computation (as if they didn't exist) The next 4 questions are related to the STUDENT table that has
been defined with the following SQL statement:
CREATE TABLE student ( StudentNo INTEGER NOT
NULL PRIMARY KEY,
StudentName VARCHAR(30) NOT NULL, DegreeVARCHAR(10),
GPA NUMERIC CHECK
Question 4 (1 point) (GPA BETWEEN 0 and 12)) Saved Which of the following statements describes the result of
following SQL query:
SELECT 'Average GPA is ', AVG(GPA) FROM student
Question 4 options:
It generates a wrong result for average if there are NULL values for GPA It finds the average GPA of all students by considering 0 instead of NULL values of GPA for the average computation According to the create statement if a NULL value entered for GPA, that NULL will be changed to zero so the average generates wrong result None of these options Question 5 (1 point) Saved Which of the following statements is the best description for
following SQL query:
SELECT Degree, COUNT(*)
- / 4