DBSkool Header Image Background

Tag: programmingPage 1 of 3

Restricting & Sorting Data

1. Which two clauses of the SELECT statement facilitate selection and projection? A. SELECT, FROM B. ORDER BY, WHERE C. SELECT, WHERE D. SELECT, ORDER BY Answer: C…

Using Conversation and Conditional Expressions

1. Define Group Functions Group functions operate on sets of rows to give one result per group. These sets may comprise the entire table or the table split…

Design Considerations for PL/SQL Code

1. All unnamed, programmer-defined exception that are user in the application and the error numbers are— A. -1 through -19999 B. -20000 through -20999 C. -20000 through -40000…

Using Dynamic SQL

1. Every SQL statement must be___ A. Bind B. Execute C. Parsed D. Fetched Answer: C 2. Parse statement checking____ A. Logic B. Syntax C. Variable D. References…

Creating Packages

1. Which two programming constructs can be grouped within a package? (Choose two) A. Cursor B. Constant C. Trigger D. Sequence E. View Answer: A, B 2. Which…

Creating Functions & Debugging Subprogram

1. Which statement is true? A. Stored functions can be called from the SELECT and WHERE clauses only. B. Stored functions do not permit calculations that involve database…

Introduction Stored Procedures & Functions

1. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( p_dspt_name VARCHAR2 DEFAULT ‘Placeholder’, p_location VARCHAR2 DEFAULT ‘Boston’ ) IS BEGIN INSERT INTO departments VALUES ( dept_id_seq.NEXTVAL, p_dept_name,…

Writing Executable Statements

1. Which statement is true about nesting blocks? A. Variable name must be unique between blocks. B. A variable defined in the outer block is visible in the…

Declaring Variables

1. Examine the code: SET SERVER OUTPUT ON DECLARE v_char_val varchar2(100); BEGIN v_char_val:= ‘Hello World’, DBMS_OUTPUT.PUT_LINE(v_char_val); END SET SERVER OUTPUT OFF This code is stored in a script…

Dependency

1. What is local dependency? In the case of local dependencies, the objects are on the same node in the same database. The Oracle server automatically manages all…