Tag: databases

Questions Related to databases

Which object privileges can be granted on a view?
technology databases

  1. none

  2. DELETE, INSERT, SELECT

  3. ALTER, DELETE, INSERT, SELECT

  4. DELETE, INSERT, SELECT, UPDATE

Show answer
Correct Option: D

Which command will delete all data from a table and will not write to the rollback segment?
technology databases

  1. DROP

  2. DELETE

  3. CASCADE

  4. TRUNCATE

Show answer
Correct Option: D

Which Oracle access method is the fastest way for Oracle to retrieve a single row?
technology databases

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan

Show answer
Correct Option: C

Which character function can be used to return a specified portion of a character string?
technology databases

  1. INSTR

  2. SUBSTR

  3. SUBSTRING

  4. POS

Show answer
Correct Option: B

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
technology databases

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error

  5. Undefined

Show answer
Correct Option: C

Which character is used to continue a statement in SQL*Plus?
technology databases

  1. *

  2. #

  3. /

  4. -

  5. @

Show answer
Correct Option: D

Assuming today is Friday, 28 August 2009, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'FRIDAY'), 'DD-MON-RR') FROM dual;
technology databases

  1. 21-AUG-09

  2. 28-AUG-09

  3. 04-SEP-09

  4. 29-AUG-09

  5. 27-AUG-09

Show answer
Correct Option: C

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
technology databases

  1. 8

  2. 3

  3. 5

  4. There is no such criteria

Show answer
Correct Option: B

Which of the following can be a valid column name?
technology databases

  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices

  5. None of the above

Show answer
Correct Option: C

Normalization is…
technology databases

  1. the process of arranging information stored in a database in a way, which removes redundancy and ambiguity.

  2. a special way of selecting data

  3. the process of adding primary key to a table

  4. All the above

Show answer
Correct Option: D