UNIVERSITAS MERCU BUANA

FACULTY: FACULTY OF COMPUTER SCIENCE

DEPARTMENT / LEVEL: INFORMATICS/S1
Document No. ...........................
Effective Date March 1st, 2020

ASSESSMENT OF THE FINAL SEMESTER EXAM

W152101001/ DATABASE SYSTEM

Academic Year/Semester : 2022-2023 / First Semester

Day/Date : Monday / December 19, 2022

Room/Time : I-403 / 10.15 – 12.45 (120 minutes)

Lecturer : Anis Cherid, SE, M.T.I.

Credits : 3 SKS

Assessment (CLO) : CLO 1, 2, 3, 4, 5

Examination Instructions for the Students:

 The final examination is working on final examination of the Oracle Academy’s
Database Foundation course (while working on the mid-term examination will be
graded for the 2nd Major Assignment)
 The deadline for the final examination submission is 12 days from the final
examination day (December 30,2022), at 23.59 PM. (Jakarta Time). If the student
fails to finish the Final Examination of The Oracle Academy’s Database Foundation
course before the deadline, the student will be considered as an absent student
during the final examination.
.
 UNIVERSITAS MERCU BUANA
FACULTY OF COMPUTER SCIENCE
INFORMATICS DEPARTMENT

THE FOLLOWING PROBLEMS ARE EXAMPLES OF THE DATABASE FOUNDATIONS

COURSE FINAL EXAMINATION FROM THE ORACLE ACADEMY. THERE IS NO
GUARANTEE THAT THE SAME QUESTIONS WILL SHOW UP IN YOUR FINAL EXAM
SHEET, AS PROBLEMS ARE RANDOMLY CHOOSEN BY THE ORACLE WEBSITE
ACADEMY.

1. The Oracle SQL Data Modeler enables you to do all 6. Constraints should be given meaningful names to
the following except: make them easier to reference.
a. Store application data o True
b. Capture business rules and information o False
c. Store metadata information 7. The steps to create a glossary from an existing Logical
d. Create process, logical, relational, and physical model are :
models a. Right click Logical model, select Create Glossary
2. In Oracle SQL Data Modeler, the attribute that you as- from Logical Model
sign as primary UID is automatically set to a manda- b. Double click the Logical Model
tory attribute and will be engineered to a primary key c. Right click the Relational model, select Create
in the relational model. Glossary from Relational Model
o True d. None of the above.
o False 8. A column or combination of columns in one table that
3. Engineering is the process of creating a con- refers to a primary key in the same or another table.
ceptual or logical model by extracting the information a. Super Key
from an existing data source. b. Foreign Key
a. Top-Down c. Candidate Key
b. Forward d. Primary Key
c. Reverse 9. ________ give you more flexibility and control when
d. Target changing data, and they ensure data consistency in the
4. The steps to convert a Relational model to a Logical event of user process failure or system failure.
model using the Oracle SQL Developer Data Modeler a. Procedures
are, b. Functions
a. Select the Relational model, Accept defaults, c. Transactions
Click the Engineer to Logical Model icon, Click d. Code blocks
Engineer 10. With the and ROLLBACK statements,
b. Click the Engineer to Relational Model icon, Se- you have control over making changes to the data per-
lect the Logical model, Click Engineer, Accept manent
defaults. a. INSERT
c. Select the Relational model, Click the Engineer b. WHERE
to Logical Model icon, Accept defaults, Click c. DELETE
Engineer d. COMMIT
d. None of the above. 11. A database transaction consists of the following ex-
5. Foreign key constraints are named using the cept
of both tables. a. One TCL Statement
a. full table name b. One DDL Statement
b. UID suffix c. DML statements representing one consistent
c. foreign key name change to the data
d. short table name d. SELECT queries

1 CONFIDENTIAL DOCUMENT | PROPERTY OF UNIVERSITAS MERCU BUANA

12. Users may view data that is in the process of being 22. Will the following statement execute successfully
changed by another user. (True or False)?
o True SELECT employee_id, city, department_name
o False FROM employees e JOIN departments d
13. The following statement will execute successfully ON d.department_id = e.department_id
(true or false): JOIN location l
SELECT employee_id, last_name, salary*12 annsal ON d.location_id = l.location_id
FROM employees ORDER BY annsal ; o True
o True o False
o False 23. A clause creates an equijoin between two ta-
14. Which SQL key word is used to do ranking in top-n- bles using one column with the same name, regardless
analysis of the data type.
a. WHERE a. NATURAL JOIN
b. GROUP BY b. USING
c. ORDER BY c. EQUI-JOIN
d. ROWNUM d. ON
15. Which is the correct order of execution for statements 24. A self-join can be used when there are two fields with
in a SELECT query? the same data on a table that have different meanings.
a. FROM, SELECT, ORDER BY, WHERE o True
b. SELECT, ORDER BY, FROM, WHERE, o False
c. SELECT, WHERE, FROM, ORDER BY 25. The join clause is based on all the columns
d. FROM, WHERE, SELECT, ORDER BY in the two tables that have the same name and the
16. Which character is used as a substitution variable in same datatype.
APEX? a. NATURAL JOIN
a. & b. OUTER JOIN
b. * c. USING
c. : d. CROSS JOIN
d. ; 26. Which of the following statements is an example of a
17. A __________ can be found at the intersection of a SELF JOIN?
row and column and contains one value. a. SELECT e.employee_id, e.last_name, e.depart-
a. field ment_id, d.department_id, d.location_id
b. table FROM employees e JOIN departments d ON
c. entity (e.department_id = d.department_id)
d. instance AND e. manager_id = 149 ;
18. To connect to an Oracle database, you need to use a b. SELECT department_id, department_name, loca-
client program. True or False? tion_id, city
o True FROM departments NATURAL JOIN locations;
o False c. SELECT e.employee_id, e.last_name, e.depart-
19. The stages of SQL processing are Parsing, Optimiza- ment_id, d.depaftment_id, d.location_id
tion, Row Source Generation and FROM employees e JOIN departments d
a. Execution ON (e.department_id = d.department_id);
b. Display d. SELECT worker.last_name emp,
c. None of the above are stages of SQL process- manager.last_name mgr
ing. FROM employees worker JOIN employees
20. The type of SQL Command used to define database manager
structures is . ON (worker.manager_id =
a. DML manager.employee_id);
b. DCL 27. In the SQL Workshop/SQL Commands
c. TCL tab you can view and retrieve previously run queries.
d. DDL a. Saved SQL
21. Why will the following statement result in an error? b. Describe
SELECT l.city, d.department_name FROM locations I c. Results
JOIN departments d d. Explain
USING (location_id) e. History
WHERE d.location id 1400; 28. In APEX SQL Workshop and Object Browser options
a. Syntax of the USING clause is incorrect. you can view table layouts.
b. The field in the USING clause cannot have a o True
qualifier. o False
c. WHERE clause cannot be used in a query with 29. To see selected records from a table we will need to
USING. add a clause to the query.
d. There is nothing wrong - this will run correctly.
2 CONFIDENTIAL DOCUMENT | PROPERTY OF UNIVERSITAS MERCU BUANA
a. FROM b. *
b. ORDER BY c. %
c. WHERE d. ALL
d. IF 40. Literals can be used within a SELECT statement.
e. None of the above o True
o False
30. To issue a CREATE TABLE statement, you must 41. When you have constraints in place on columns, an er-
have the privilege. ror is returned if you try to violate the constraint rule.
a. DISTRIBUTE TABLE o True
b. CREATE TABLE o False
c. Both 42. You can delete a row that contains a primary key that
d. None is used as a foreign key in another table.
31. DDL means o True
a. Data Distribution Language o False
b. Data Definers Language 43. When issuing a SQL DELETE command all rows in
c. Data Definition Language the table are deleted if you omit the
d. None of the above. clause.
32. To create a table you must identify all of the following a. IF
except b. SELECT
a. Field data types c. WHEN
b. Table name d. WHERE
c. Field values 44. The command that always removes all rows from a ta-
d. Field names ble, leaving the table empty and the table structure in-
33. __________ constraints can only be created at the col- tact is …
umn level. a. TRUNCATE
a. Check b. DELETE
b. Not Null c. Both
c. Unique d. None
d. Primary Key 45. Data Manipulation Language includes all of the fol-
34. Columns without the NOT NULL constraint can con- lowing except
tain null values by default. a. COMMIT
o True b. DELETE
o False c. UPDATE
35. Which statement displays the last name, salary, and d. INSERT
annual compensation of employees where the annual 46. You can override the default order by using parenthe-
compensation is calculated by multiplying the monthly ses around the expressions that you want to calculate
salary with 15, plus a one-time bonus of $200. first.
a. SELECT last_name, salary, 15*salary+200 o True
FROM employees; o False
b. SELECT last_name, salary, 15*(salary+200) 47. According to the rules of precedence which operator
FROM employees; will be evaluated first?
c. Either statement will produced the desired result. a. AND
d. Neither statement will produce the desired result. b. OR
36. Arithmetic expressions containing a null value evalu- c. Both are on the same level of precedence
ate to 48. You use the operator to perform wildcard
a. whatever the calculation evaluates to searches of valid search string values.
b. zero a. BETWEEN
c. null b. LIKE
d. will cause an error c. MATCH
37. Selecting specific columns from a table to be dis- d. STRING
played in a query is called _______ selection 49. The ___________ operator requires either of the com-
a. elimination ponent conditions to be true.
b. sorting a. EITHER
c. projection b. AND
38. You can display all columns of data in a table by fol- c. OR
lowing the SELECT keyword with an asterisk (*). d. BETWEEN
o True 50. Which statement will display those employees who
o False have a job title that contains the string 'JEF' and earn
39. The following statement displays all the rows in the $10,000 or more?
departments table: SELECT FROM departments; a. SELECT employee_id, last_name, job_id, salary
a. # FROM employees
3 CONFIDENTIAL DOCUMENT | PROPERTY OF UNIVERSITAS MERCU BUANA
 WHERE salary 10000 AND job_id LIKE , c. Either statement displays the desired output.
b. SELECT employee_id, last_name, job_id, salary d. Neither statement displays the desired output.
FROM employees
WHERE salary 10000 OR job_id LIKE ;

4 CONFIDENTIAL DOCUMENT | PROPERTY OF UNIVERSITAS MERCU BUANA