databases Online Quiz - 15
|Description: databases Online Quiz - 15|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
In databases, ON UPDATE CASCADE ensures which of the following?
A NOT IN query will return rows if a NULL value is in the subquery or IN list
The possibilities for the two tables to be joined resides in the same AMP are
The command used to display the DDL of certain objects
Order of precedence for sql in teradata is
Anytime you mix aggregates with non-aggregates you must use the group by statement
Which join requires denormalisation of the table
What is decode equivalent function in Teradata
The SET operators used in teradata sql are
SET clause in CREATE statement allows duplicate rows whereas MULTISET will not
These joins always requires SPOOL Files
What does SQL stand for?
Select the DDL Statement from below:
SQL is case sensitive
The SQL statement used to delete a table:
The AND operator displays a record if both the first condition and the second condition is true. The OR operator displays a record if either the first condition or the second condition is true.
The below Query is to select the persons with a first name that starts with any character, followed by "la" from the "Persons" table. SELECT * FROM Persons WHERE FirstName LIKE '%la%'
The Correct Statement to select a column named "LastName" from a table named "Employee".
The Correct Statement to select all the columns from a table named "Employee".