Tag: databases

Questions Related to databases

Which two statements are true? (Choose two)
technology databases

  1. a) A function must return a value.

  2. b) A procedure must return a value.

  3. c) A function executes a PL/SQL statement.

  4. d) A function is invoked as part of an expression.

  5. e) A procedure must have a return data type specify in its declaration.

Show answer
Correct Option: A,D

CREATE OR REPLACE PROCEDURE find_cpt (v_movie_id {Argument Mode} NUMBER, v_cost_per_ticket {argument mode} NUMBER) IS BEGIN IF v_cost_per_ticket > 8.5 THEN SELECT cost_per_ticket INTO v_cost_per_ticket FROM gross_receipt WHERE movie_id = v_movie_id; END IF; END; Which mode should be used for V_COST_PER_TICKET?

technology databases

  1. IN OUT

  2. IN

  3. OUT

  4. RETURN

Show answer
Correct Option: A

The ADD_PLAYER, UPD_PLAYER_STAT and UPD_PITCHER_STAT procedures are grouped together in a package. A variable must be shared among only these procedures. Where should you declare this variable?
technology databases

  1. a) In the package body.

  2. b) In the data base triggers.

  3. c) In the package specification.

  4. d) In the procedures declare section using the exact name in each.

Show answer
Correct Option: A

For which trigger timing can you reference the NEW and OLD qualifiers?
technology databases

  1. Statement and Row

  2. Statement only

  3. Row only

  4. Oracle Forms trigger

Show answer
Correct Option: C

Examine this code: CREATE OR REPLACE STORED FUNCTION get_sal (p_raise_amt NUMBER, p_employee_id employees.employee_id%TYPE) RETURN NUMBER IS v_salary NUMBER; v_raise NUMBER(8,2); BEGIN SELECT salary INTO v_salary FROM employees WHERE employee_id = p_employee_id; v_raise := p_raise_amt * v_salary; RETURN v_raise; END; Which statement is true?
technology databases

  1. a) This statement creates a stored procedure named get_sal.

  2. b) This statement returns a raise amount based on an employee id.

  3. c) This statement creates a stored function named get_sal with a status of invalid.

  4. d) This statement creates a stored function named get_sal.

  5. e) This statement fails.

Show answer
Correct Option: E

When using a packaged function in a query, what is true?
technology databases

  1. a) The COMMIT and ROLLBACK commands are allowed in the packaged function.

  2. b) You can not use packaged functions in a query statement.

  3. c) The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.

  4. d) The packaged function can execute and INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery.

  5. e) The packaged function can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used.

Show answer
Correct Option: C

Which three are true regarding error propagation? (Choose three)

technology databases

  1. a) An exception cannot propagate across remote procedure calls.

  2. b) An exception raised inside a declaration immediately propagates to the current block.

  3. c) The use of the RAISE; statement in an exception handler reprises the current exception

  4. d) An exception raised inside an exception handler immediately propagates to the enclosing block.

Show answer
Correct Option: A,C,D

Which procedure of the dbms_output supply package would you use to append text to the current line of the output buffer?

technology databases

  1. a) GET.

  2. b) GET_LINE.

  3. c) PUT_TEXT_LINE.

  4. d) PUT_LINE.

Show answer
Correct Option: D

The first prime minister of Bangladesh was
technology databases

  1. Manmohan

  2. Sonia Gnadhi

  3. Mujibur Rahman

  4. Obama

Show answer
Correct Option: B,C

An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?
technology databases

  1. PMON

  2. SMON

  3. RECO

  4. ARCn

  5. CKPT

Show answer
Correct Option: B