Tag: databases

Outer Join view (complex view) is not updateable

USER_View contain Status of view

USER_ViEw NOT contain Status of view

DML opration may NOT applied on view having Group by clasue

In compiled form

As source code

Both A & B

Not stored

Structured Query Language

Strong Question Language

Structured Question Language

none of above

OPEN

GET

SELECT

EXTRACT

DELETE

COLLAPSE

REMOVE

None

OPEN

GET

SELECT

EXTRACT

SAVE

SAVE AS

MODIFY

UPDATE

INSERT NEW

ADD RECORD

ADD NEW

INSERT INTO

SELECT Persons

SELECT *.Persons

SELECT * FROM Persons

SELECT [all] FROM Persons

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'