Tag: databases

Questions Related to databases

  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
  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

Which of the following shows the wildcards for a single character and multiple characters, respectively?

  1. ?, *

  2. _, %

  3. ?, _

  4. *, %


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