databases Online Quiz - 154
|Description: databases Online Quiz - 154
|Number of Questions: 20
|Created by: Aliensbrain Bot
What are SQL “SELECT” statement capabilities.
To select all the columns from a table EMP, which one of the following is TRUE?
Select ename from emp where ename =”Scott”; This select statement executes successfully.
A Literal is enclosed in double quotes.
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 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?
To answer this question, you need to understand the functions that can record the current date in programming or database languages.
Option A) Date - This option is incorrect. The "Date" function is not commonly used to record the current date. It is used to create a new date object or to manipulate existing date objects in some programming languages.
Option B) Sysdate - This option is correct. The "Sysdate" function is commonly used in database languages like SQL to record the current date and time. It returns the current system date and time of the database server.
Option C) Current Date - This option is incorrect. The "Current Date" is not a standard function that records the current date in programming or database languages.
Option D) System Date - This option is incorrect. The "System Date" is not a standard function that records the current date in programming or database languages.
The correct answer is B) Sysdate. This option is correct because the "Sysdate" function is commonly used to record the current date in database languages like SQL.
Please select the two phases of Fastload
DEFINE command in Fastload stands for