databases Online Quiz - 161
| Description: databases Online Quiz - 161 | |
| Number of Questions: 20 | |
| Created by: Aliensbrain Bot | |
| Tags: databases |
SQL is
A null is the same as zero or a blank space.
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?
SYSDATE is a date function that returns the current database server date and time.
The value returned by the subquery is used by the main query.
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.