Introduction to Databases
Exam Answer Key
Course Introduction
Introduction to Databases provides a foundational understanding of how data is stored, managed, and retrieved in modern information systems. The course explores key concepts such as data modeling, relational databases, SQL (Structured Query Language), normalization, and transaction management. Students learn to design and implement database schemas, perform queries and updates, and understand the principles of database security and integrity. Through hands-on exercises and projects, students gain the practical skills necessary to work with database management systems and appreciate their role in supporting data-driven applications across various industries.
Recommended Textbook
Oracle 11G PL SQL Programming 2nd Edition by Joan Casteel
Available Study Resources on Quizplus
10 Chapters
645 Verified Questions
645 Flashcards
Source URL: https://quizplus.com/study-set/1149 Page 2
Chapter 1: Introduction To PL/SQL
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/22517
Sample Questions
Q1) A programming language allows the actions of an end user to be converted into instructions that a computer can understand.
A)True
B)False
Answer: True
Q2) <u>Functions</u> perform tasks automatically when a DML action occurs on the table with which it is associated. _________________________
A)True
B)False
Answer: False
Q3) A(n) ____ is a general framework or design that describes how the various components of the application will be addressed.
A) programming language
B) procedural language
C) database
D) application model
Answer: D
Q4) A(n) ____________________ typically returns only one value.
Answer: Function
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Basic PL/SQL Block Structures
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/22518
Sample Questions
Q1) The following code fragment is a correct example of the use of a basic loop. BEGIN LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num );
lv_cnt_num := lv_cnt_num + 1; END LOOP; END;
A)True
B)False
Answer: False
Q2) A(n)<u> CASE expression</u> evaluates conditions and returns a value in an assignment statement. _________________________
A)True
B)False
Answer: True
Q3) The ____________________ section of a PL/SQL block contains handlers that allow you to control what the application will do if an error occurs during the executable statements in the BEGIN section.
Answer: EXCEPTION
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Handling Data In PL/SQL Blocks
Available Study Resources on Quizplus for this Chatper
51 Verified Questions
51 Flashcards
Source URL: https://quizplus.com/quiz/22519
Sample Questions
Q1) A(n) ____________________ statement could be used to create a record data type.
Answer: TRYPE
Q2) A(n)<u>index table</u> is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit.
A)True
B)False
Answer: False
Q3) The INTO clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.
A)True
B)False Answer: True
Q4) A disadvantage of using the %TYPE attribute is that there is a slight performance hit in that the database server must look up the data type from the data dictionary.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Cursors and Exception Handling
Available Study Resources on Quizplus for this Chatper
65 Verified Questions
65 Flashcards
Source URL: https://quizplus.com/quiz/22520
Sample Questions
Q1) An attempted violation of a unique or primary key column constraint causes the ____________________ exception.
Q2) Implicit and explicit cursors are considered dynamic because they are associated with specific queries.
A)True
B)False
Q3) A(n) ____________________ is one that a developer explicitly raises in the block to enforce a business rule.
Q4) The ____ option groups rows of queries or DML statements for processing.
A) FORALL
B) COLLECT BULK
C) BULK COLLECT
D) LIMIT
Q5) ____ is used to trap errors not specifically addressed in one of the exception handlers.
A) WHERE
B) EXIT WHEN
C) WHEN OTHERS
D) EXCEPTION
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Procedures
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22521
Sample Questions
Q1) The RAISE_APPLICATION_ERROR built-in function is provided by Oracle to ____.
A) create error messages
B) display error messages
C) track error messages
D) display functions
Q2) The DBMS_OUTPUT.PUT_LINE statement can be used to ____.
A) assist with the creation of a cursor
B) assist with the creation of an exception
C) assist with creating functions
D) assist with debugging your code
Q3) The term<u> autonomous transaction</u> refers to additional instructions for the PL/SQL compiler to use during program unit compilation.
A)True B)False
Q4) The ____________________ area of a block determines what happens if an error occurs.
Q5) The reuse of code is an important contributor to programming efficiency. A)True B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Functions
Available Study Resources on Quizplus for this Chatper
51 Verified Questions
51 Flashcards
Source URL: https://quizplus.com/quiz/22522
Sample Questions
Q1) The following is a correct example of the use of the DROP command. DROP function_name;
A)True
B)False
Q2) At least one ____ statement must be included in a function body to instruct which value to return.
A) CREATE
B) RETURN
C) BEGIN
D) EXCEPTION
Q3) The term "actual parameters" refers to the parameters that are listed in the program unit.
A)True
B)False
Q4) What are the main differences between a function and a procedure?
Q5) A(n) <u>procedure</u> is part of an expression and cannot serve an entire statement. ____________________
A)True B)False
Q6) What are formal and actual parameters?
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: PL/SQL Packages
Available Study Resources on Quizplus for this Chatper
68 Verified Questions
68 Flashcards
Source URL: https://quizplus.com/quiz/22523
Sample Questions
Q1) Why would a package require two procedures or functions with the same name?
Q2) When the values of package element persist throughout a user session and, therefore, can be referenced in code within various parts of the application during a user session, the elements are considered to be <u>global</u>.
A)True
B)False
Q3) Package code is not cached, nor is package data such as variables and cursors. A)True B)False
Q4) A(n) <u>package body</u> is the program unit that contains the code for any procedures and functions declared in the specification.
A)True B)False
Q5) A(n) ____________________ procedure is a procedure in a package that runs only once, when the package is initially invoked.
Q6) The query to be used to populate a ____________________ data type can be determined at run time.
Q7) What is meant by the term package body?
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Program Unit Dependencies
Available Study Resources on Quizplus for this Chatper
61 Verified Questions
61 Flashcards
Source URL: https://quizplus.com/quiz/22524
Sample Questions
Q1) Which of the following compiler parameter will determine the code optimization techniques used?
A) PLSQL_OPTIMIZE_LEVEL
B) PLSQL_OPTIMIZER
C) PLSQL_CODE_TYPE
D) PLSQL_CCFLAGS
Q2) Oracle offers two models or methods to determine invalidation of remote dependent objects at runtime: timestamp and ____________________________.
Q3) Only modifications to the package specification or the program unit header section can raise the ____________________________ status of dependent objects.
Q4) The ____ is considered the default method of remote dependent objects.
A) signature model
B) datestamp model
C) timestamp model
D) record model
Q5) The ____________________________ compares the mode, data type, and the order of parameters and the RETURN data type (for functions) when a remote object call is accomplished in order to determine invalidation.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Database Triggers
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/22525
Sample Questions
Q1) CREATE [OR REPLACE] TRIGGER trigger_name [BEFORE, AFTER]
[List of DDL or Database System Events] [ON DATABASE | SCHEMA] Trigger body; The syntax above represents that of a(n) ____ trigger.
A) statement
B) row level
C) system
D) Instead-Of
Q2) LOB and OBJECT columns can be referenced in a trigger and can also be modified.
A)True
B)False
Q3) To remove a trigger from the system, the <u>DEL TRIGGER</u> statement is used.
A)True
B)False
Q4) A(n) ___________________________ is one that is referenced via a foreign key constraint on the table that a trigger is modifying.
Q5) The default timing of a trigger is ___________________________ level and no code is included to achieve this timing.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Oracle-Supplied Packages, Dynamic SQL, and
Hiding Source Code
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/22526
Sample Questions
Q1) The util.ora file contains environment settings, such as the UTL_FILE_DIR parameter, that determine if and how certain Oracle features are accessible from within PL/SQL code.
A)True
B)False
Q2) The UTL_FILE package contains a PUT_LINE data type that is used to declare a file variable.
A)True
B)False
Q3) ____ are used to distinguish parameter values that are used as criteria in the DBMS_SQL package, versus parameters that provide identifiers such as column names.
A) DDLs
B) Placeholders
C) DMLs
D) Cursors
Q4) The _________________________ package is used to display messages to the screen from a stored program unit or an anonymous block.
Q5) What is the difference between a mutator and an observer?
Q6) Describe the basic mechanics of the alert process.
To view all questions and flashcards with answers, click on the resource link above. Page 12