0

databases Online Quiz - 60

Description: databases Online Quiz - 60
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Index

  2. Page deallocation

  3. Trigger creation

  4. None of the above


Correct Option: A
  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. None of the Above


Correct Option: B

Which of the statement allows you to roll back and creates log in the transaction log?

  1. TRUNCATE

  2. DELETE

  3. DELETE ALL

  4. REMOVE


Correct Option: B

Arrange the keyword “FROM, WHERE, SELECT, HAVING,GROUP BY, ORDER BY ” in the proper ?order

  1. SELECT, FROM , WHERE,GROUP BY, ORDER BY, HAVING?

  2. SELECT, FROM, WHERE, ORDER BY, HAVING,GROUP BY

  3. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING

  4. SELECT, FROM , WHERE,GROUP BY, HAVING, ORDER BY


Correct Option: D

The Minimum number of tables required to establish a many to many relationships are...

  1. 2

  2. 4

  3. 3

  4. 5


Correct Option: C

What will be the default sort order if nothing is specified explicitly in the SELECT statement?

  1. ASCENDING

  2. DESCENDING

  3. RANDOM

  4. PHYSICAL


Correct Option: A

UNION vs. UNION ALL

  1. UNION only selects distinct values, UNION ALL selects all values (excluding ?duplicates)?

  2. UNION ALL only selects distinct values, UNION selects all values (including ?duplicates)?

  3. UNION only selects distinct values, UNION ALL selects all values (including ?duplicates)?

  4. UNION ALL only selects distinct values, UNION selects all values (excluding ?duplicates)?


Correct Option: C

The Query has Main and Sub Query. If the main query returns 10 records and subquery returns 5 records, then how many times the subquery gets executed?

  1. 10

  2. 1

  3. 5

  4. 50


Correct Option: B

Which CLAUSE is used in a SELECT statement to filter the records that a GROUP BY returns?

  1. WHERE

  2. HAVING

  3. HAVING BY

  4. ORDER BY


Correct Option: B

Which statement does not fire the Trigger?

  1. Delete

  2. Truncate

  3. Insert

  4. Update


Correct Option: B

AI Explanation

To answer this question, we need to understand what a trigger is and how it works in a database.

A trigger is a stored procedure that automatically executes when a specific event occurs in a database. These events can include inserting, updating, or deleting records in a table. Triggers are commonly used to enforce data integrity rules, perform calculations or validations, or log changes made to the database.

Now let's go through each option to determine which statement does not fire the trigger:

A) Delete: When a record is deleted from a table, it triggers the "delete" event, and any associated triggers will be fired. Therefore, option A can fire the trigger.

B) Truncate: When a table is truncated, all the records in that table are deleted. However, the truncate operation does not fire any triggers associated with the table. Therefore, option B does not fire the trigger.

C) Insert: When a new record is inserted into a table, it triggers the "insert" event, and any associated triggers will be fired. Therefore, option C can fire the trigger.

D) Update: When an existing record is updated in a table, it triggers the "update" event, and any associated triggers will be fired. Therefore, option D can fire the trigger.

Based on the explanations above, the correct answer is B) Truncate. This option does not fire the trigger associated with the table being truncated.

Multiple indexes on a table will lead to...

  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


Correct Option: B
  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


Correct Option: B

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

  1. True

  2. False


Correct Option: A

Which of the following is true for Perm Space

  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.


Correct Option: A,B,C,D
  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


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?

  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


Correct Option: B

The BETWEEN SQL keywords specifies ...

  1. a column list.

  2. a table list.

  3. a list of values.

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


Correct Option: D

What does Source Definitions stands for in terms of ETL processes?

  1. Tranform

  2. Extract

  3. Load

  4. All of the Above


Correct Option: B
- Hide questions