Introduction to Databases Test Questions

Course Introduction

Introduction to Databases provides a comprehensive overview of fundamental concepts in database systems, focusing on the design, implementation, and management of relational databases. Students will explore data modeling using Entity-Relationship diagrams, relational algebra, and SQL query language for data manipulation and retrieval. The course covers database normalization, indexing, transaction management, data integrity, and security, while introducing current trends such as NoSQL databases and distributed systems. Emphasis is placed on practical skills through hands-on projects and exercises, preparing students to develop and interact with modern database-driven applications.

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

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) An example of an application ____________________ is PL/SQL code that automatically runs when a particular button is clicked on the screen.

Answer: Trigger

Q2) Which of the following statements is correct?

A) The application server contains the user interface and processing logic, which together, respond to user actions.

B) The user interface is delivered from the database server that contains the logic to respond to user actions.

C) The user interface is delivered from the SQL database that contains the logic to respond to user actions.

D) The user interface is delivered from the thin client that contains the logic to respond to user actions.

Answer: A

Q3) PL/SQL fully supports SQL data types.

A)True

B)False

Answer: True

To view all questions and flashcards with answers, click on the resource link above.

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 ____________________ loop is constructed with conditions in the LOOP statement to determine when the looping action begins and ends.

Answer: WHILE FOR

Q2) An infinite loop causes a program to loop indefinitely, disrupting the ability of the code to continue with any processing beyond the loop.

A)True

B)False

Answer: True

Q3) If the EXIT WHEN clause is not included in the basic loop, the result is the programmer's nightmare of a(n) ____________________.

Answer: infinite loop

Q4) ____ are used to change the values of variables.

A) Loops

B) Assignment statements

C) Exceptions

D) Blocks

Answer: B

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 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

Q2) 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

Q3) A(n) ____ is a variable that can handle many rows of data but only one field.

A) assignment statement

B) associative array

C) collection

D) table attribute

Answer: B

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) A(n) ____________________ is one that a developer explicitly raises in the block to enforce a business rule.

Q2) An attempted violation of a unique or primary key column constraint causes the ____________________ exception.

Q3) Some cursor variables are references or pointers to a specific work area.

A)True B)False

Q4) In PL/SQL, comment text is not executed.

A)True

B)False

Q5) Discuss the meaning of the term exception handler.

Q6) If the ____________________ clause of a SELECT statement contains either scalar or record variables and if more than one row is selected, the TOO_MANY_ROWS error is raised.

Q7) A FORALL statement can process a group of rows in a DML operation.

A)True B)False

Q8) What is the difference between a predefined exception and a user-defined exception?

Q9) An attempted division by zero causes the ____________________ exception. Page 6

To view all questions and flashcards with answers, click on the resource link above.

Page 7

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 variable name ____ conforms to Oracle11g naming standards.

A) $quantity

B) ship_date

C) :p_ship

D) _ship_date

Q2) ____ a program unit or PL/SQL block of code allows the storage and reuse of the code.

A) Naming

B) Processing

C) Creating

D) Debugging

Q3) A(n) application trigger performs tasks automatically when a DML action occurs on the table with which it is associated. _________________________

A)True

B)False

Q4) The term server-side refers to code that resides on the client machine.

A)True

B)False

Q5) What is the difference between a database trigger and an application trigger?

Page 8

Q6) What is the difference between a function and a procedure?

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) Which of the following statements is True?

A) After IN OUT parameters are included in functions, the function can no longer be used in SQL statements.

B) After OUT parameters are included in functions, the function can no longer be used in SQL statements.

C) After INOUT parameters are included in functions, the function can no longer be used in SQL statements.

D) After IN parameters are included in functions, the function can no longer be used in SQL statements.

Q2) ____________________ cannot be used in SQL statements.

Q3) The default behaviors of value passing can be overridden by using a compiler hint named NOCOPY. _________________________

A)True B)False

Q4) Formal parameters including the RETURN data type cannot include size information. A)True B)False

Q5) What are the main differences between a function and a procedure?

To view all questions and flashcards with answers, click on the resource link above. Page 9

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) A(n) program declaration 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

Q2) Functions are used in CHECK constraints or as a default values of table columns. A)True B)False

Q3) The AUTHID CURRENT_USER clause is used to override definer-rights behavior. _________________________

A)True

B)False

Q4) A(n) ____________________ procedure is a procedure in a package that runs only once, when the package is initially invoked.

Q5) Package code is not cached, nor is package data such as variables and cursors. A)True B)False

Q6) The term ____________________ in packages refers to the ability to use the same name on multiple program units within the same package.

Page 10

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) Which item below is the name for an IF THEN structure used to accomplish conditional compilation?

A) Selection instruction

B) Selection directive

C) Selective statement

D) Selective option

Q2) Which of the following is used by Oracle to determine invalidation of remote dependent objects at runtime?

A) datestamp model

B) record model

C) USER_OBJECT model

D) signature model

Q3) The dependency tree utility allows the user to review direct and indirect dependencies of an object in either numeric order or indented format.

A)True

B)False

Q4) If a dependent object is flagged as INVALID, this means that the program unit should be ____________________________.

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 11

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 ____ trigger clause allows a trigger to include multiple triggering events in a single trigger.

A) MULTIPLE

B) MULTIPLE TRIGGER

C) COMPOUND

D) COMPOUND TRIGGER

Q2) All of the following would cause a trigger to fire, except ____.

A) BEFORE

B) INSERT

C) DELETE

D) UPDATE

Q3) The ALTER TRIGGER statement is used to recompile, enable, or disable a trigger.

A)True

B)False

Q4) 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;

Q5) What is the difference between a mutating table and a key-preserved table?

Page 12

To view all questions and flashcards with answers, click on the resource link above.

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 DBMS_DDL package provides the only Oracle method available to hide source code.

A)True

B)False

Q2) A(n) mutator is similar to a partition or area of the physical disk.

A)True

B)False

Q3) The array-like processing available in DBMS_SQL makes working with many rows much more cumbersome.

A)True

B)False

Q4) When the SQL statement is built in the PL/SQL block, placeholders with colon prefixes are used to mark where values are supplied at runtime.

A)True

B)False

Q5) The _________________________ action of the DBMS_DDL package computes statistics on a database object, typically tables and indexes, such as the range of values.

Page 13

To view all questions and flashcards with answers, click on the resource link above.