DBMS Final Exam Fall 2023 Scored 45/50

1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review DBMS Final Exam Fall 2023 Scored 45/50 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 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 Extracts a string of determined length. Select one: a. Trim b. INSTR c. Length d. SUBSTR 1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review 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 It logically represents subsets of data from one or more table. Select one: a. Index b. Table c. View d. Synonym 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 1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review Which of the following datatype is not being used in oracle? Select one: a. VARCHAR b. INT c. CHAR d. NUMBER 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 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