Tag: databases

Questions Related to databases

If there are frequent updates in tables, then which utility to use?
technology databases

  1. BTEQ

  2. TPUMP

  3. FASTEXPORT

  4. MULTILOAD

Show answer
Correct Option: B

The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table:select count(mgr) from emp;which of the following choice indentifies the result oracle will return
technology databases

  1. <14

  2. >14

  3. 14

  4. 0

Show answer
Correct Option: A

You can declare this only by using table contraint syntax
technology databases

  1. Not NULL

  2. Primary key

  3. Foreign key

  4. Composite primary keys

Show answer
Correct Option: D

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

  1. *

  2. /

  3. -

  4. =

Show answer
Correct Option: B

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

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS

Show answer
Correct Option: C

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

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

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

  4. 4

Show answer
Correct Option: B

To use Global temporary tables in a compound statement you require which type of tablespace to be present
technology databases

  1. User temporary

  2. Large

  3. System

  4. Regular

Show answer
Correct Option: A

Which of the following is not true for Stored Procedures?
technology databases

  1. Simplifies code reuse, code standardization and code maintenance

  2. Controlled access to other database objects

  3. Improving application performance

  4. DB2 Stored Procedures can be written only in SQL.

Show answer
Correct Option: D