• 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

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
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions