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

AI Explanation

To answer this question, you need to understand the character functions used in string manipulation.

Option A) INSTR - This option is incorrect because the INSTR function is used to find the starting position of a specified substring within a string.

Option B) SUBSTRING - This option is incorrect because the SUBSTRING function is used to extract a substring from a string based on a specified starting position and length.

Option C) SUBSTR - This option is correct because the SUBSTR function is used to extract a substring from a string based on a specified starting position and, optionally, a length.

Option D) POS - This option is incorrect because there is no standard character function called POS in most programming languages or database systems.

The correct answer is C) SUBSTR. This option is correct because the SUBSTR function is specifically designed to return a specified portion of a character string.

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