Database Design and Implementation Practice Exam
Course Introduction
This course introduces the fundamental concepts and techniques involved in designing and implementing relational databases. Students will explore data modeling using Entity-Relationship diagrams, normalization processes, and the principles of database schema design. The course covers Structured Query Language (SQL) for database creation, manipulation, and querying, as well as essential aspects of database security, transactions, and concurrency control. Practical labs and projects provide hands-on experience in building robust and efficient databases, preparing students to address real-world data management challenges in various application domains.
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) <u>SQL*Plus</u> is a basic tool available with the Oracle server that allows a user to enter SQL and PL/SQL statements directly to the Oracle database server for processing.
A)True
B)False
Answer: True
Q2) Structured Query Language (SQL) is considered a procedural language.
A)True
B)False
Answer: False
Q3) A(n) <u>package </u>is any block of PL/SQL code that has been named so that it can be saved and reused. _________________________
A)True
B)False
Answer: False
Q4) Because a PL/SQL engine is part of the ____________________, code modules can be used or called from almost any application development language.
Answer: server
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) To keep code efficient and minimize statement processing, any statements that are <u>dynamic</u> in nature should be placed outside a loop.
A)True
B)False
Answer: False
Q2) If the EXIT WHEN clause is not included in a basic loop, then the result is a(n) ____.
A) infinite loop
B) exception
C) RAISE_APPLICATION_ERROR
D) SQLCODE error
Answer: A
Q3) The simple IF statement performs an action only if the condition is ____________________.
A)True
B)False
Answer: True
Q4) _____________________ statements are used to put or change values in variables.
Answer: Assignment
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) The<u> REF </u>attribute tells the system to look up the data type of a database column and use it for the declared variable. _________________________
A)True
B)False
Answer: False
Q2) tbl_basketitems(5).idproduct := :g_prod; According to the above statement, which of the following indicates the field into which a value will be placed?
A) idproduct
B) tbl_basketitems
C) :g_row
D) :g_prod
Answer: A
Q3) The GOTO statement interrupts the flow of execution of a program. A)True
B)False
Answer: True
Q4) A(n) _________________ data type is quite similar to the structure of a row in a database table.
Answer: record
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) The ____ action used with an explicit cursor clears the active set of rows and frees the memory area used for the cursor.
A) CLOSE
B) OPEN
C) DECLARE
D) FETCH
Q2) A FORALL statement can process a group of rows in a DML operation.
A)True
B)False
Q3) ____ refers to a SELECT statement in a PL/SQL block that retrieves more than one row.
A) NO_DATA_FOUND
B) ZERO_DIVIDE
C) CASE_NOT_FOUND
D) TOO_MANY_ROWS
Q4) Predefined exceptions are declared in the ____________________ package, which makes these globally available on the system.
Q5) What is the difference between an explicit and an implicit cursor?
Q6) The ____________________ function returns the Oracle error number.
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 ____ mode type is considered constant because it cannot be changed within the procedure.
A) IN
B) OUT
C) INOUT
D) IN OUT
Q2) If no mode is indicated in a parameter, the default value of ____________________ is applied.
Q3) What is the difference between a database trigger and an application trigger?
Q4) A(n)<u> procedure</u> is used to accomplish one or more tasks, return none or many values, and can be used only in PL/SQL statements.
A)True
B)False
Q5) The term pragma refers to additional instructions for the PL/SQL compiler to use during program unit compilation.
A)True B)False
Q6) ____________________ is the process of identifying and removing errors from within program code.
Page 7
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) How many input values does the following code require? CREATE OR REPLACE FUNCTION memfmt1_sf (p_id IN NUMBER, P_first IN VARCHAR2, P_last IN VARCHAR2) RETURN VARCHAR2 IS
Lv_mem_txt VARCHAR2(35); BEGIN
Lv_mem_txt := 'Member ' ||p_id|| ' - ' ||p_first|| ' ' ||p_last; RETURN lv_mem_txt; END;
A) 1
B) 2 C) 3 D) 4
Q2) You cannot include <u>data type</u> information when declaring a formal parameter. ________________________
A)True B)False
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) Items declared in the package body and not in the specification can be used only by other procedures and functions within this same package body.
A)True
B)False
Q2) Functions cannot be used in a(n) ____________________ constraint or as a default value of a table column.
Q3) For overloading to be successful, the formal parameters in the procedures or functions must be the same.
A)True
B)False
Q4) Packages can be created in local libraries, as can procedures and functions.
A)True
B)False
Q5) The term ____________________ in packages refers to the ability to use the same name on multiple program units within the same package.
Q6) When compiling objects that call packaged program units, only the ____________________ is used for verification.
Q7) Define the term package, and explain why it is used.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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) The ____ view shows only the direct privileges of the current schema.
A) SESSION_PRIVS
B) SESSION_ROLES
C) USER_OBJECTS
D) USER_SYS_PRIVS
Q2) The<u> user source</u> utility is a mechanism available in the Oracle system to provide a map to visualize both direct and indirect dependencies within the database.
A)True
B)False
Q3) ____ instructs the system to assign the variable data type based on the underlying table column data type at runtime.
A) %SELECT
B) %ROWTYPE
C) %INSERT
D) %DATATYPE
Q4) A(n) ____________________________ occurs when one database object directly references other objects.
Q5) What is the purpose of the %TYPE and %ROWTYPE attributes?
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) A(n) <u>mutating table</u> is one that is referenced via a foreign key constraint on the table that a trigger is modifying. _________________________
A)True
B)False
Q2) The statement ____ recompiles the trigger named sales_trg.
A) ENABLE TRIGGER sales_trg COMPILE;
B) DROP TRIGGER sales_trg COMPILE;
C) COMPILE TRIGGER sales_trg COMPILE;
D) ALTER TRIGGER sales_trg COMPILE;
Q3) What is the difference between a mutating table and a key-preserved table?
Q4) In the syntax of the CREATE TRIGGER statement, the ____________________ clause can be used to change the OLD and NEW qualifier names to something of your choice.
Q5) To remove a trigger from the system, the <u>DEL TRIGGER</u> statement is used.
A)True
B)False
Q6) The default timing of a trigger is ___________________________ level and no code is included to achieve this timing.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter
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 programs within the ____ package can be grouped into two sets: mutators and observers.
A) BLOB
B) DBMS_LOB
C) CLOB
D) BFILE
Q2) Attempting to use a(n) _________________________ to provide an identifier, such as a column name or table name, in an SQL statement within PL/SQL raises an error.
Q3) The ____ package allows parameters to be directly used as identifiers, such as column names and table names.
A) DBMS_SQL
B) DBMS_ALERT
C) UTL_SMTP
D) DBMS_PIPE
Q4) The ____ program associates placeholders in the Cursor with PL/SQL variables.
A) PARSE
B) BIND_VARIABLE
C) CLOSE_CURSOR
D) EXECUTE
To view all questions and flashcards with answers, click on the resource link above. Page 12