Tag: databases

Questions Related to databases

What is the maximum no.of statements that can be specified in a trigger statement ?
technology databases

  1. One

  2. Two

  3. Three

  4. Four

Show answer
Correct Option: A

What is the maximum no of cascading triggers used at a time?
technology databases

  1. 24

  2. 8

  3. 16

  4. 32

Show answer
Correct Option: D

Which symbol preceeds the path to the table in the remote database ?
technology databases

  1. /

  2. #

  3. @

  4. \

Show answer
Correct Option: C

If all the values from a cursor have been fetched and another fetch is issued, the output will be :
technology databases

  1. Error

  2. Last Record

  3. First Record

  4. Can't Say

Show answer
Correct Option: B

Is Sysdate a system variable or a system function?
technology databases

  1. System Variable

  2. System Function

  3. Both A & B

  4. None of the Above

Show answer
Correct Option: B

How can you avoid indexes ?
technology databases

  1. Use FULL hint to optimizer for full table scan

  2. Use INDEX or AND-EQUAL hint to optimizer to use one index or set to indexes instead of another.

  3. Use an expression in the Where Clause of the SQL.

  4. Disable Index on the column

Show answer
Correct Option: A,B,C,D

The variables or expressions referenced in the parameter list of a subprogram call are Actual parameters?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

The variables declared in a subprogram specification and referenced in the subprogram body are formal parameters?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure ?
technology databases

  1. No

  2. Yes

  3. Can't Say

  4. None of the above

Show answer
Correct Option: B

Which of the following is not a feature of a cursor FOR loop?
technology databases

  1. Record type declaration.

  2. Opening and parsing of SQL statements.

  3. Fetches records from cursor.

  4. Requires exit condition to be defined.

Show answer
Correct Option: D