Tag: databases

Questions Related to databases

How do you handle an Exception?
technology databases

  1. Trap it with a Handler

  2. Propagate it to the Calling Environment

  3. A & Then B

  4. B & Then A

Show answer
Correct Option: C

Under which two circumstances do you design database triggers? (Choose two)

technology databases

  1. To duplicate the functionality of other triggers.

  2. To replicate built-in constraints in the Oracle server such as primary key and foreign key.

  3. To guarantee that when a specific operation is performed, related actions are performed.

  4. For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement.

Show answer
Correct Option: C,D

AI Explanation

To answer this question, you need to understand the purpose and use cases of database triggers. Let's go through each option to understand why it is correct or incorrect:

Option A) To duplicate the functionality of other triggers - This option is incorrect. Triggers are not designed to duplicate the functionality of other triggers. Instead, triggers are used to perform specific actions when certain events occur in the database.

Option B) To replicate built-in constraints in the Oracle server such as primary key and foreign key - This option is incorrect. Built-in constraints like primary key and foreign key are not replicated using triggers. Constraints are used to enforce data integrity rules, while triggers are used to perform actions based on specific events.

Option C) To guarantee that when a specific operation is performed, related actions are performed - This option is correct. One of the main purposes of database triggers is to ensure that when a specific operation (such as an insert, update, or delete) is performed on a table, related actions or operations are also performed. Triggers can be used to automatically update other tables, perform calculations, or enforce business rules.

Option D) For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement - This option is correct. Triggers can be designed to perform centralized, global operations that should be triggered regardless of the user or application issuing the statement. This allows for consistent and standardized actions to be performed for specific events.

Therefore, the correct answers are C) To guarantee that when a specific operation is performed, related actions are performed and D) For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement.

Which two statements about the overloading feature of packages are true? (Choose two)
technology databases

  1. Only local or packaged sub programs can be overloaded.

  2. Overloading allows different functions with the same name that differ only in their return types.

  3. Overloading allows different subprograms with the same number, type and order of the parameter.

  4. Overloading allows different subprograms with the same name and same number or type of the parameters.

  5. Overloading allows different subprograms with the same name but different in either number or type or order of parameter.

Show answer
Correct Option: A,E

What does “REPLACE” indicate in creating procedures?
technology databases

  1. An existing will be dropped and it will be replaced by the new version.

  2. An existing will be dropped and it will not be replaced by the new version.

  3. No change will occur

  4. There is no such option available in creating procedures.

Show answer
Correct Option: A

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

  1. Packages can be nested.

  2. You can pass parameters to packages.

  3. A package is loaded into memory each time it is invoked.

  4. The contents of packages can be shared by many applications.

  5. You can achieve information hiding by making package constructs private.

Show answer
Correct Option: D,E

A function must return zero or more values to its calling environment, whereas a procedure returns a value to the calling environment.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following statements is false with respect to packages?
technology databases

  1. The package itself cannot be called, parameterized, or nested.

  2. The format of a package is similar to that of a subprogram.

  3. The contents can be shared by many applications once written.

  4. None of the above.

Show answer
Correct Option: D

Identifiers defined only in the package body are public constructs. These are visible outside the package body
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which two program declarations are correct for a stored program unit? (Choose two)
technology databases

  1. CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER

  2. CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER) RETURN NUMBER

  3. CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER)

  4. CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER(10,2)

  5. CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER(10, 2))

Show answer
Correct Option: A,C

What is true about stored procedures?
technology databases

  1. A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters.

  2. A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.

  3. A stored procedure must have at least one executable statement in the procedure body.

  4. A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.

Show answer
Correct Option: C