Tag: programmingPage 1 of 3
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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…