databases Online Quiz - 161
Description: databases Online Quiz - 161 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;
What does the MOD Function do?
What does the MOD Function do?
To perform wild card search “Like” is used .
When is a Cartesian product formed?
In a join condition it is mandatory to specify the table name along with the Column name.
The minimum number of join statements required to join 10 tables together are:
A Non equi-join is a join condition that does not contain an equality operator.
Sorting SQL statement result data by column alias is not possible.
What are the two types of SQL Functions?
Single-Row Functions can return multiple results per row.
Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;
LAST_DAY(date) finds the date of the last day of the month that contains date.
Which of the following WHERE clauses represent equi-join?
An outer join is used to:
____________ is the outer join operator.