Tag: technology

Questions Related to technology

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

AI Explanation

To answer this question, you need to understand how SQL*Plus works and how statements are executed.

SQL*Plus is a command-line interface provided by Oracle for executing SQL and PL/SQL statements. In SQL*Plus, a statement can be continued onto the next line using the character "-".

Option A) * - This option is incorrect because the "*" character is not used to continue a statement in SQL*Plus. Option B) # - This option is incorrect because the "#" character is not used to continue a statement in SQL*Plus. Option C) / - This option is incorrect because the "/" character is used to execute a statement in SQL*Plus, not to continue a statement. Option D) - - This option is correct because the "-" character is used to continue a statement onto the next line in SQL*Plus. Option E) @ - This option is incorrect because the "@" character is used in SQL*Plus to execute a script or a file, not to continue a statement.

The correct answer is Option D) "-". This option is correct because the "-" character is used to continue a statement in SQL*Plus.

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

When an instance of a class, or object, is specified as a parameter to a method, a reference to the said object is passed to the method.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

All interface methods must be declared as public when implemented in a class.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

A method in a class declared as static may be invoked simply by using the name of the method alone.

technology programming languages

  1. True

  2. False

Show answer
Correct Option: B