• databases Online Quiz - 156
Back
0

databases Online Quiz - 156

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

We can nest Group Functions

technology databases

  1. True

  2. False

Show answer
Correct Option: B

SYSDATE is a date function that returns the current database server date and time.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

The value returned by the subquery is used by the main query.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

To perform wild card search “Like” is used .

technology databases

  1. True

  2. False

Show answer
Correct Option: B

When is a Cartesian product formed?

technology databases

  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table.

  4. All of the above.

Show answer
Correct Option: D

AI Explanation

To answer this question, you need to understand the concept of a Cartesian product in the context of database joins.

A Cartesian product is formed when two tables are joined without any join condition specified. This means that all rows from the first table are combined with all rows from the second table, resulting in a combination of every row from the first table with every row from the second table.

Let's go through each option to understand why it is correct or incorrect:

Option A) When a join condition is omitted - This option is correct because a Cartesian product occurs when a join condition is not specified, resulting in the combination of all rows from both tables.

Option B) When a join condition is invalid - This option is incorrect because a Cartesian product occurs when no join condition is specified, regardless of whether the join condition is valid or not.

Option C) All rows in the first table are joined to all rows in the second table - This option is correct because a Cartesian product involves combining all rows from the first table with all rows from the second table.

Option D) All of the above - This option is correct because both option A and option C correctly describe when a Cartesian product is formed.

The correct answer is D) All of the above. This option is correct because a Cartesian product can occur when a join condition is omitted, when a join condition is invalid, or when all rows in the first table are joined to all rows in the second table.

In a join condition it is mandatory to specify the table name along with the Column name.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

The minimum number of join statements required to join 10 tables together are:

technology databases

  1. 9

  2. 11

  3. 5

  4. 12

  5. None of the above

Show answer
Correct Option: A

A Non equi-join is a join condition that does not contain an equality operator.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Sorting SQL statement result data by column alias is not possible.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

What are the two types of SQL Functions?

technology databases

  1. Single-row Functions and Double-row Functions

  2. One-row Functions and Two-row Functions

  3. Single-row Functions and Multiple-row Functions

  4. None of the above

Show answer
Correct Option: C

Single-Row Functions can return multiple results per row.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;

technology databases

  1. 99.57,99,6

  2. 99.5,99.6

  3. 99.6,99.6

  4. 99.57,99.57

Show answer
Correct Option: B

LAST_DAY(date) finds the date of the last day of the month that contains date.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following WHERE clauses represent equi-join?

technology databases

  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above

Show answer
Correct Option: B

An outer join is used to:

technology databases

  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above

Show answer
Correct Option: A

____________ is the outer join operator.

technology databases

  1. (+)

  2. (-)

  3. (*)

  4. +

Show answer
Correct Option: A

____________ is used to join a table to itself.

technology databases

  1. Selfjoin

  2. Outerjoin

  3. innerjoin

  4. equijoin

Show answer
Correct Option: A

A null is the same as zero or a blank space.

technology databases

  1. True

  2. False

Show answer
Correct Option: B
Explanation:

To solve this question, the user needs to know the definition of a null value. A null value typically represents a missing or unknown value, and it is not the same as a zero or a blank space.

Option A - True: This option is incorrect. A null value is not equivalent to zero or a blank space. In programming, null is often used to indicate the absence of a value or a missing value.

Option B - False: This option is correct. A null value is not the same as zero or a blank space. It is a distinct value that represents an absence of data.

Therefore, the correct answer is:

The Answer is: B. False

What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;

technology databases

  1. 1112

  2. 1111.93

  3. 1111.93412

  4. 1111.934

Show answer
Correct Option: D

What does the MOD Function do?

technology databases

  1. It divides both the values and gives the quotient.

  2. It multiplies both the values and gives the product.

  3. It divides both the values and gives the remainder.

  4. There is no such function.

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 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