databases Online Quiz - 161 Online Test

Back

databases Online Quiz - 161

Description: databases Online Quiz - 161
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

Start the Quiz

SQL is

technology databases

Structured Query Language
Standard Query Language
System Query Language
Simple Query Language

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

technology databases

True
False

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

technology databases

1112
1111.93
1111.93412
1111.934

What does the MOD Function do?

technology databases

It divides both the values and gives the quotient.
It multiplies both the values and gives the product.
It divides both the values and gives the remainder.
There is no such function.

What does the MOD Function do?

technology databases

It divides both the values and gives the quotient.
It multiplies both the values and gives the product.
It divides both the values and gives the remainder.
There is no such function.

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

technology databases

True
False

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

technology databases

True
False

To perform wild card search “Like” is used .

technology databases

True
False

When is a Cartesian product formed?

technology databases

When a join condition is omitted.
When a join condition is invalid.
All rows in the first table are joined to all rows in the second table.
All of the above.

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

technology databases

True
False

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

technology databases

9
11
5
12
None of the above

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

technology databases

True
False

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

technology databases

True
False

What are the two types of SQL Functions?

technology databases

Single-row Functions and Double-row Functions
One-row Functions and Two-row Functions
Single-row Functions and Multiple-row Functions
None of the above

Single-Row Functions can return multiple results per row.

technology databases

True
False

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

technology databases

99.57,99,6
99.5,99.6
99.6,99.6
99.57,99.57

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

technology databases

True
False

Which of the following WHERE clauses represent equi-join?

technology databases

Table1.column1=Table2.column2
Table1.column1=Table2.column1
Table1.column2=Table2.column1
None of the above

An outer join is used to:

technology databases

Return records which have no direct match
Return records which have direct match
Return all the records
None of the above

____________ is the outer join operator.

technology databases

- Hide questions

databases Online Quiz - 161

Find more quizzes from top tags