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 1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review Supposed that the user uses the ff SELECT statement: what will be the possible output. SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT; Select one: a. Will display the column GRADE rename as STUDENT MAK b. Error because of the keyword AS. c. Error because of missing “” mark. d. Will display all rows and columns. It is collection of data that contains information relevant to an enterprise. Select one: a. Relational database b. Database system c. Database Management System d. Database Refer to table 1.0 Using the SELECT statement below what would be the possible output: SELECT NAME, ORG, POSITION, ID * (100 + 3) FROM ORGCHAR WHERE ORG = ‘AMATHS’ Select one: a. It will retrieve the record of ANNA with new ID of 1030 b. It will retrieve the record of ANNA with new ID of 1003 c. 0 rows selected d. It will retrieve the record of ANNA with new ID of 10 1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review Which of the following is not part of data manipulation language? Select one: a. Update b. Merge c. Alter d. Insert Are applied to the table and form the logical schema. Select one: a. Not null b. Primary key c. Constraints d. Foreign key 1/22/23, 12:58 PM FINAL EXAMINATION: Attempt review Based on the given table Stocks type the possible out if the following sql statement is executed. What is the character position of ‘O’ of the description Microware Oven from parts when this SQL statement is executed? SELECT INSTR(DESCRIPTION,'O') FROM PART; Select one: a. 5 b. 4 c. 2 d. 3 Your answer is correct. This is used to perform wildcard searches of valid search string values. Select one: a. Like b. Comparison c. IN d. Between