databases Online Quiz - 160
|Description: databases Online Quiz - 160|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
____________ is used to join a table to itself.
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?
Duplicate values are eliminated by which keyword
The two types of subqueries are:
Single-row subquery returns:
What is the result of the query below? SELECT Stud_name, Rollnum FROM STUDENT WHERE stud_marks=(SELECT MIN (stud_marks) FROM STUDENT GROUPBY Rollnum);
Which of the following is not a multiple-row operator?
Which operator compares a value to every value returned by a subquery?
A DML statement is executed when you
The right syntax insert a row into a table is
Which is the function that records the current date?
Limiting the rows in a select statement for a specific condition is done by the clause
Select ename from emp where ename =”Scott”; This select statement executes successfully.