Tag: databases

Questions Related to databases

Data integrity exists on READ LOCK?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Teradata maintain rows in the received order
technology databases

  1. True

  2. False

Show answer
Correct Option: B

What determines the number of concurrent users to the database ?
technology databases

  1. PMON

  2. CMON

  3. Both

  4. None of the above

Show answer
Correct Option: A

FLOAD can be used to load data in
technology databases

  1. Tables with already existing data

  2. Empty tables

  3. Both 1 & 2

  4. None of the above

Show answer
Correct Option: B

The TOP option can appear in the
technology databases

  1. FROM clause

  2. WHERE clause

  3. Correlated sub query

  4. None of the above

Show answer
Correct Option: C

If the TOP option specifies a number greater than the number of rows in the query result set, then

technology databases

  1. The query returns the rows in the query result set without producing an error.

  2. Return no rows

  3. Produces an error

  4. The query returns rows

Show answer
Correct Option: A

MULTILOAD faster than FLOAD
technology databases

  1. True

  2. False

Show answer
Correct Option: B

In Teradata's parallel environment, response time is as fast as
technology databases

  1. the fastest AMP invloved

  2. slowest AMP involved

  3. sum of all amps involved

  4. average performance of all AMPs

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to know about Teradata's Parallel Environment.

In Teradata's Parallel Environment, the response time is determined by the slowest AMP involved in the process. This is because the Teradata system is designed to ensure that all AMPs are involved in processing a query or transaction, and the system waits for the slowest AMP to complete its task before returning the results to the user.

Therefore, the correct answer is:

The Answer is: B. slowest AMP involved

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
technology databases

  1. 2

  2. 1

  3. 3

  4. 0

Show answer
Correct Option: B
Explanation:

To solve this question, the user needs to know how the SQL SELECT statement and concatenation operator (||) work. The SELECT statement retrieves data from a database table and returns a result set. The concatenation operator is used to combine two or more strings into a single string.

The given SQL query concatenates three columns (address1, address2, and address2) using the concatenation operator and then renames the concatenated column as "Address".

The resulting query output will contain only one column named 'Address' that is the result of concatenating the three columns. Therefore, the correct answer is:

The Answer is: B. 1

What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;

technology databases

  1. Null

  2. Not Null

  3. Function NVL2 is not defined

  4. None of The above

Show answer
Correct Option: A