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