Tag: databases

Questions Related to databases

Which statement does not fire the Trigger?
technology databases

  1. Delete

  2. Truncate

  3. Insert

  4. Update

Show answer
Correct Option: B

Multiple indexes on a table will lead to...
technology databases

  1. Increase the performance during SELECT operation

  2. Degrade the performance during INSERT operation?

  3. Degrade the performance during the UPDATE or DELETE operation

  4. All of the above

Show answer
Correct Option: B

Which key has a logical relationship to the attributes within that row in a table??
technology databases

  1. Natural Key

  2. Domain Key

  3. Candidate Key

  4. All of the Above

Show answer
Correct Option: D

Which of the following is not true about an AMP?
technology databases

  1. AMP stores and retrieves data using the file system

  2. AMP parses the SQL to determine the type and validity

  3. AMP sorts and formats the output

  4. AMP environment is a Shared Nothing Architecture

Show answer
Correct Option: B

Bandwidth of BYNET increases with each consecutive node added to the system.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following is true for Perm Space
technology databases

  1. Perm space can be dynamically modified.

  2. All Perm space specifications are subtracted from the immediate owner or parent.

  3. Perm space currently unused is available to be used as Spool or Temp space.

  4. Perm space is only used for tables and stored procedures.

  5. Volatile Temporary tables and “derived” tables utilize Perm space.

Show answer
Correct Option: A,B,C,D

We refer to a join as a self-join when…
technology databases

  1. We are using left and right join together

  2. We are joining more than 2 tables

  3. We are joining table to itself

  4. we are joining 2 tables

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know the concept of self-join in database management systems.

A self-join is a regular join, but the table is being joined with itself. This means that we are using a single table to compare rows within the same table.

Option A is incorrect because a left and right join is not referred to as a self-join.

Option B is incorrect because the number of tables being joined does not determine whether a self-join is being used or not.

Option D is incorrect because a regular join between two tables is not referred to as a self-join.

Therefore, the correct answer is:

The Answer is: C. We are joining table to itself.

What is the purpose of the SQL AS clause?
technology databases

  1. The AS clause is used with the JOIN clause only.

  2. The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

  3. The AS clause defines a search condition.

  4. The AS clause defines a join

Show answer
Correct Option: B

The BETWEEN SQL keywords specifies ...
technology databases

  1. a column list.

  2. a table list.

  3. a list of values.

  4. a range to test in the SQL query search condition.

Show answer
Correct Option: D

Which SQL keyword is used to retrieve only unique values?
technology databases

  1. UNIQUE

  2. DIFFERENT

  3. DISTINCT

  4. DISTINCTIVE

Show answer
Correct Option: C