0

databases Online Quiz - 131

Description: databases Online Quiz - 131
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

If the below block, when you execute then what will be the output? Begin Null; Exception When others then Dbms_output.put_line(‘ I am in Others Exception’); When no_data_found then Dbms_output.put_line(‘ I am in no data found Exception’); End;

  1. I am in Others Exception

  2. I am in no data found Exception

  3. Compilation Error

  4. None of the above


Correct Option: C
  1. Positional & Named

  2. Positional alone

  3. Positional ,Name and Combination

  4. None of the above


Correct Option: C
  1. %ROWTYPE allows you to associate a variable with an entire table row

  2. %ROWTYPE associates a variable with a single column type

  3. Both of the above

  4. None of the above


Correct Option: A
  1. SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN

  2. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN

  3. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN

  4. All of the above


Correct Option: C

Raw types are used to store _________ data.

  1. binary

  2. Character

  3. ASCII

  4. All of the above


Correct Option: A
  1. DELCARE and BEGIN

  2. DECALRE and EXCEPTION

  3. EXCEPTION and END

  4. BEGIN and END


Correct Option: B
  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.


Correct Option: C,D
  1. SELECT column_name ALIAS alias_name FROM table_name;

  2. SELECT column_name alias_name FROM table_name;

  3. SELECT alias_name FROM table_name;

  4. ASSIGN alias_name TO column_name;


Correct Option: B

Which of the following are reasonable series of transaction-control commands?

  1. Insert some records, COMMIT, ROLLBACK

  2. SAVEPOINT, insert some records, ROLLBACK, ROLLBACK, COMMIT

  3. ROLLBACK, insert some records, COMMIT

  4. ROLLBACK, insert some records, COMMIT, COMMIT


Correct Option: C
  1. ROUND(4.5, 0) < TRUNC(4.5, 0)

  2. ROUND(4.1, 0) < TRUNC(4.2, 0

  3. ROUND(8.9, 0) > TRUNC(8.9, 0)

  4. ROUND(8.9, 1) > TRUNC(8.95, 2)


Correct Option: C
- Hide questions