databases Online Quiz - 156
|Description: databases Online Quiz - 156|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
We can nest Group Functions
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.
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 used to join a table to itself.