Tag: databases

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".