Tag: technology

Questions Related to technology

YOu are asked to prepare a report for sales department that will compare the revenue generated for all products lines for all regions. What kind of report will you prepare?

technology web technology

  1. List

  2. Crosstab

  3. both

  4. none of the above

Show answer
Correct Option: B

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 of the following can be a valid column name?
technology databases

  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices

Show answer
Correct Option: C

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

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

Show answer
Correct Option: C

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

  1. *

  2. /

  3. -

  4. @

Show answer
Correct Option: C

Select valid scriptlink commands
technology programming languages

  1. lines2list

  2. list2lines

  3. select

  4. showbind

Show answer
Correct Option: A,C

What is equalent ScriptLINK command for "filestat"

technology programming languages

  1. =

  2. ?

  3. @

  4. +

Show answer
Correct Option: B

What is the output for the following expression = ceil {-4.5}

technology programming languages

  1. 5

  2. -4

  3. 4

  4. -5

Show answer
Correct Option: B