Advanced Database Systems
Exam Materials
Course Introduction
Advanced Database Systems explores the architecture, design, and implementation of modern database management systems beyond the basics. The course covers advanced data models, query processing and optimization, transaction management, distributed and parallel databases, NoSQL systems, and emerging topics such as big data technologies and cloud databases. Students will gain hands-on experience with advanced database features, analyze scalability and performance issues, and study how cutting-edge database systems are applied in solving complex real-world problems.
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) Describe the three-tier application model.
Answer: The three-tier model is growing in popularity because it attempts to ease application maintenance and enables the support of larger numbers of users. In this scenario, the user interface is typically presented via a Web browser and is often referred to as a thin client. Application code is not loaded onto the client machine; all the application code now resides on an application server, which is also referred to as the middle tier.
Three layers now exist in this model: the user interface, the application server, and the database server. The Oracle application server allows the deployment of Oracle Forms applications via the Web. The application server contains the user interface and processing logic, which together, respond to user actions and, in turn, send appropriate code to the database server for processing.
Q2) A procedure and function are named program units that are called to perform a specific task.
A)True
B)False
Answer: True
Q3) A program that can run on any platform is considered ____________________. Answer: portable
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 <u>DECLARE </u>section of the PL/SQL block contains all the processing action, or programming logic. _________________________
A)True
B)False
Answer: False
Q2) The<u> basic</u> loop dictates exactly how many times the loop should run in the opening LOOP clause. ____________________
A)True
B)False
Answer: False
Q3) Which of the following allow us to repeat the processing of a desired portion of code?
A) Functions
B) Looping constructs
C) IF statements
D) CASE expressions
Answer: B
Q4) The code order NUMBER(2) := 6; is an example of a(n) ____________________.
Answer: assignment statement
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) ____ is a variable that can store and handle multiple values of the same data type as one unit.
A) composite data type
B) collection
C) record
D) assignment statement
Answer: B
Q2) Which of the following statements about collections is NOT True?
A) Collections are similar to arrays.
B) An index allows references to individual values or rows within a collection.
C) A collection may hold many rows of data and many fields.
D) The values in each row of the collection must be of the same type.
Answer: C
Q3) The ____ markers are used in PL/SQL to identify a label.
A) <>
B) ""
C) << >>
D) :=
Answer: C
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) ____ refers to a SELECT statement in a PL/SQL block that retrieves no rows.
A) TOO_MANY_ROWS
B) NO_DATA_FOUND
C) ZERO_DIVIDE
D) DUP_VAL_ON_INDEX
Q2) ____ returns the Oracle error message.
A) EXIT WHEN
B) SQLCODE
C) SQLERR
D) SQLERRM
Q3) Bulk processing options can have a detrimental effect on performance.
A)True
B)False
Q4) Explicit cursors are declared automatically for all DML and SELECT statements issued within a PL/SQL block.
A)True
B)False
Q5) Some cursor variables are references or pointers to a specific work area.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
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) ____________________ refers to the logical group of DML actions that is affected by a transaction control statement.
Q2) A PL/SQL block created and named is a named program unit or subprogram.
A)True
B)False
Q3) An application trigger performs a task automatically when a DML action occurs on the table with which it is associated.
A)True
B)False
Q4) What is the difference between a database trigger and an application trigger?
Q5) ____ can accept and return none, one, or many parameters.
A) Triggers
B) Procedures
C) Packages
D) Programs
Q6) ____________________ indicate which way the value provided for the parameter flows: into the procedure, out of the procedure, or both.
Q7) In a(n) ____________________, you associate a value to each parameter by name in the invoke statement.
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) Procedures can be used in SQL statements.
A)True B)False
Q2) You cannot include ____________________ information when declaring a formal parameter.
Q3) 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
Q4) The RETURN statement in a function is used to control the flow of execution. A)True B)False
Q5) Functions cannot be used in a(n) <u>CHECK</u> constraint or as a default value of a table column. _________________________
A)True B)False
Q6) A(n) ____________________ cannot serve as an entire statement.
Q7) ____________________ cannot be used in SQL statements.
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) Package elements that can be referenced from outside the package are considered
A) public
B) overloaded
C) one time only procedures
D) private
Q2) Package code is not cached, nor is package data such as variables and cursors.
A)True
B)False
Q3) A(n)<u> program declaration</u> is a declaration of a program unit in a package body by placing the header code at the top of the package body code.
A)True
B)False
Q4) The statement ____ would successfully remove the package specification and body.
A) DROP PACKAGE BODY package_name;
B) DEL PACKAGE BODY package_name;
C) DROP PACKAGE package_name;
D) DEL PACKAGE package_name;
Page 9
Q5) Why would a package require two procedures or functions with the same name?
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) ____ can be used to check the status of database objects.
A) USER_OBJECTS
B) USER_REFERENCE
C) USER_CHECK
D) USER_SOURCE
Q2) When a program unit includes references to database objects that in turn reference other database objects, it is said to contain direct dependencies.
A)True
B)False
Q3) The ____________________________ data dictionary view reveals all the privileges of the current schema.
Q4) The<u> %TYPE</u> declaration instructs the system to assign the variable data type based on the underlying table column data type at runtime.
A)True B)False
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) The default timing of a trigger is ____.
A) statement level
B) system level
C) row level
D) header level
Q2) A database ___________________________ is a block of PL/SQL code that runs automatically when a particular database event occurs.
Q3) ____ triggers refer to database triggers that are fired by Data Definition Language (DDL) statements or database system events rather than DML actions.
A) ALTER
B) CREATE
C) System
D) Instead-Of
Q4) The default timing of a trigger is row level and no code is included to achieve this timing.
A)True
B)False
Q5) Discuss three critical pieces of information regarding the WHEN clause of a trigger.
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) A(n) _________________________ is a pointer to a cursor or SQL work area.
Q2) In the UTL_FILE package, the ____ program unit is used to read a line from a file.
A) FOPEN
B) PUT_LINE
C) GET_LINE
D) FCLOSE
Q3) When the SQL statement is built in the PL/SQL block, <u>placeholders</u> with colon prefixes are used to mark where values are supplied at runtime.
A)True
B)False
Q4) In the DBMS_DDL package, ____ is a valid ANALYZE_OBJECT exception.
A) ORA-20000
B) ORA-20002
C) ORA-20003
D) ORA-20004
Q5) Discuss the purpose of the UTL_MAIL package and identify at least five parameters available in the package.
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