Tag: technology

Questions Related to technology

Select length(-1) from dual What is the output of the above sql stmt

technology databases

  1. 0

  2. 1

  3. 2

  4. error

Show answer
Correct Option: C

conditional logic can be applied in which utilitiy?
technology databases

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. TPUMP

Show answer
Correct Option: A,C,D

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