• databases Online Quiz - 60
Back
0

databases Online Quiz - 60

Description: databases Online Quiz - 60
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

reservepagegap can be used in any one of the following

technology databases

  1. Index

  2. Page deallocation

  3. Trigger creation

  4. None of the above

Show answer
Correct Option: A

What does SQL stand for??

technology databases

  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. None of the Above

Show answer
Correct Option: B

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

technology databases

  1. TRUNCATE

  2. DELETE

  3. DELETE ALL

  4. REMOVE

Show answer
Correct Option: B

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

technology databases

  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

Show answer
Correct Option: D

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

technology databases

  1. 2

  2. 4

  3. 3

  4. 5

Show answer
Correct Option: C

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

technology databases

  1. ASCENDING

  2. DESCENDING

  3. RANDOM

  4. PHYSICAL

Show answer
Correct Option: A

UNION vs. UNION ALL

technology databases

  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)?

Show answer
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?

technology databases

  1. 10

  2. 1

  3. 5

  4. 50

Show answer
Correct Option: B

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

technology databases

  1. WHERE

  2. HAVING

  3. HAVING BY

  4. ORDER BY

Show answer
Correct Option: B

Which statement does not fire the Trigger?

technology databases

  1. Delete

  2. Truncate

  3. Insert

  4. Update

Show answer
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...

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

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

technology databases

  1. Tranform

  2. Extract

  3. Load

  4. All of the Above

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions