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);
It gives the name and marks of all the students.
It does not return anything.
It shows an error saying” INVALID SYNTAX ERROR”
It shows an error saying” Single-row subquery returns more than one row
Which of the following is not a multiple-row operator?
IN
OF
ALL
ANY
Which operator compares a value to every value returned by a subquery?
A DML statement is executed when you
Add new rows to a table
Modify existing rows of a table
Remove existing rows from a table
All of the above
The right syntax insert a row into a table is
Insert to table tablename (….);
Insert into table tablename (….);
Insert into table tablename values (…..);
Any one of the above
Which is the function that records the current date?
Date
Sysdate
Current Date
System Date
Fastload does not use Transient Journal
True
False
Please select the two phases of Fastload
Acquisition
Transaction
Application
Clean Up
DEFINE command in Fastload stands for
Define the target table
Define the Work table
Define the input file
Define the Error table
It is possible to restart Fastload script when the target table is created in the script