Tag: databases

SELECT DIFFERENT

SELECT DISTINCT

SELECT UNIQUE

SELECT PRIMARY

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT [all] FROM Persons

SELECT Persons

SELECT *.Persons

SELECT * FROM Persons

iSQL*Plus commands manipulate table definitions in the database.

iSQL*Plus is the Oracle proprietary interface for executing SQL statements.

iSQL*Plus commands cannot be abbreviated.

iSQL*Plus commands are accesses from a browser.

Use the DESCRIBE command in the EMP_DEPT VU view.

Use the DEFINE VIEW command on the EMP_DEPT VU view.

Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.

Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.

insert

update

select

describe

Selection, projection, join

Difference, projection, join

Selection, intersection, join

Intersection, projection, join

True

False

True

False

True

False