Tag: programming languages

Questions Related to programming languages

Which two statements about views are true? (Choose two)

  1. A view can be created as read only.

  2. A view can be created as a join on two or more tables

  3. A view cannot have a n ORDER BY clause in the SELECT statement.

  4. A view cannot be created with a GROUP BY clause in the SELECT statement.


Correct Option: A,B
  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. INTERVAL DAY TO SECOND

  4. INTERVAL YEAR TO MONTH

  5. TIMESTAMP WITH DATABASE TIMEZONE


Correct Option: A,C,D

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS


Correct Option: D
  1. No data found

  2. Internal error

  3. TNS:could not resolve service name"

  4. None of the above


Correct Option: A

ORA-01017 ?

  1. Oracle not available (the database is down)

  2. Invalid Username/Password

  3. Snapshot too old (Rollback has been overwritten)

  4. Unique constraint violated


Correct Option: B

ORA-00001 Means?

  1. PL/SQL Error

  2. No data found

  3. Insufficient privileges

  4. Unique constraint violated. (Invalid data has been rejected)


Correct Option: D
  1. PL/SQL Error

  2. No data found

  3. Insufficient privileges

  4. Unique constraint violated. (Invalid data has been rejected)


Correct Option: D

From the following code fragments select the most appropriate way of throwing exceptions ?Assume that variable i is properly defined , in scope and has appropriate value

  1. if ( i > 10) { throws new IndexOutOfBoundsException("Index is out of bound!"); }

  2. if ( i > 10) { throw new IndexOutOfBoundsException("The value of index i=" + " is out of bound!" ); }

  3. if ( i > 10) { throw "Index is out of bound!"; }

  4. None of the ABove


Correct Option: B
  1. Not connected to ORACLE

  2. Table or view does not exist

  3. Internal error (contact support)

  4. None Of The Above


Correct Option: A

ORA-03114 Means?

  1. Not connected to ORACLE

  2. Table or view does not exist

  3. Internal error (contact support)

  4. None Of The Above


Correct Option: A