1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review
DBMS Final Exam Fall 2023 Scored 45/50
Home / My courses / UGRD-IT6202-2212S / FINAL EXAMINATION / FINAL EXAMINATION
Started on Sunday, 22 January 2023, 12:30
PM
State Finished
Completed on Sunday, 22 January 2023,
12:58 PM
Time taken 27 mins 34 secs
Marks 45.00/50.00
Grade 90.00 out of 100.00
Question 1
Complete
Mark 0.00 out of 1.00
Refer to table 1.0 Using the SELECT statement below what would be the possible output:
SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE NAME LIKE ‘A%’ AND POSITION = ‘SEC’;
Select one:
a. It retrieves the record of ANNA and MOJICA
b. Incorrect SELECT statement
c. rows selected / no rows selected
d. It retrieves the record of AGAPITO
Question 2
Complete
Mark 1.00 out of 1.00
Extracts a string of determined
length. Select one:
a. Trim
b. INSTR
c. Length
d. SUBSTR
semestralexam.amaes.com/2212/mod/quiz/review.php? 1/21
attempt=185464&cmid=3800
,1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review
Question 3
Complete
Mark 1.00 out of 1.00
This is used to bring together data that is stored in different tables by specifying the link between them.
Select one:
a. Selection
b. Joins
c. Inclusion
d. Projection
Question 4
Complete
Mark 1.00 out of 1.00
It logically represents subsets of data from one or
more table. Select one:
a. Index
b. Table
c. View
d. Synonym
Question 5
Complete
Mark 1.00 out of 1.00
The overall logical structure (schema) of a database can be expressed
graphically by Select one:
a. DB Diagram
b. ER Diagram
c. DM Model
d. ER Model
semestralexam.amaes.com/2212/mod/quiz/review.php? 2/21
attempt=185464&cmid=3800
, 1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review
Question 6
Complete
Mark 1.00 out of 1.00
Which of the following datatype is not being used in oracle?
Select one:
a. VARCHAR
b. INT
c. CHAR
d. NUMBER
Question 7
Complete
Mark 1.00 out of 1.00
Refer to table 1.0 Using the SELECT statement below what would be the
possible output: SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG
=’JPCS’ OR POSITION = ‘SEC’;
Select one:
a. It will retrieve the record of JOAN andROAN
b. Incorrect SELECT statement
c. 0 rows selected
d. It will retrieve the record of JOAN,ROAN and JUN
Question 8
Complete
Mark 1.00 out of 1.00
What is the return value if the user try to do the
following: SELECT TRUNC (65.73,-2) FROM DUAL;
Select one:
a. 00
b. 0
c. 600
d. 60
semestralexam.amaes.com/2212/mod/quiz/review.php? 3/21
attempt=185464&cmid=3800
DBMS Final Exam Fall 2023 Scored 45/50
Home / My courses / UGRD-IT6202-2212S / FINAL EXAMINATION / FINAL EXAMINATION
Started on Sunday, 22 January 2023, 12:30
PM
State Finished
Completed on Sunday, 22 January 2023,
12:58 PM
Time taken 27 mins 34 secs
Marks 45.00/50.00
Grade 90.00 out of 100.00
Question 1
Complete
Mark 0.00 out of 1.00
Refer to table 1.0 Using the SELECT statement below what would be the possible output:
SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE NAME LIKE ‘A%’ AND POSITION = ‘SEC’;
Select one:
a. It retrieves the record of ANNA and MOJICA
b. Incorrect SELECT statement
c. rows selected / no rows selected
d. It retrieves the record of AGAPITO
Question 2
Complete
Mark 1.00 out of 1.00
Extracts a string of determined
length. Select one:
a. Trim
b. INSTR
c. Length
d. SUBSTR
semestralexam.amaes.com/2212/mod/quiz/review.php? 1/21
attempt=185464&cmid=3800
,1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review
Question 3
Complete
Mark 1.00 out of 1.00
This is used to bring together data that is stored in different tables by specifying the link between them.
Select one:
a. Selection
b. Joins
c. Inclusion
d. Projection
Question 4
Complete
Mark 1.00 out of 1.00
It logically represents subsets of data from one or
more table. Select one:
a. Index
b. Table
c. View
d. Synonym
Question 5
Complete
Mark 1.00 out of 1.00
The overall logical structure (schema) of a database can be expressed
graphically by Select one:
a. DB Diagram
b. ER Diagram
c. DM Model
d. ER Model
semestralexam.amaes.com/2212/mod/quiz/review.php? 2/21
attempt=185464&cmid=3800
, 1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review
Question 6
Complete
Mark 1.00 out of 1.00
Which of the following datatype is not being used in oracle?
Select one:
a. VARCHAR
b. INT
c. CHAR
d. NUMBER
Question 7
Complete
Mark 1.00 out of 1.00
Refer to table 1.0 Using the SELECT statement below what would be the
possible output: SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG
=’JPCS’ OR POSITION = ‘SEC’;
Select one:
a. It will retrieve the record of JOAN andROAN
b. Incorrect SELECT statement
c. 0 rows selected
d. It will retrieve the record of JOAN,ROAN and JUN
Question 8
Complete
Mark 1.00 out of 1.00
What is the return value if the user try to do the
following: SELECT TRUNC (65.73,-2) FROM DUAL;
Select one:
a. 00
b. 0
c. 600
d. 60
semestralexam.amaes.com/2212/mod/quiz/review.php? 3/21
attempt=185464&cmid=3800
