A. EXTRACT

B. GET

C. SELECT

D. OPEN

A. SELECT [all] FROM Persons

B. SELECT *.Persons

C. SELECT * FROM Persons

D. SELECT Persons

A. SELECT * FROM Persons WHERE FirstName='Peter'

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

C. SELECT * FROM Persons WHERE FirstName<>'Peter'

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

A. SELECT * FROM Persons WHERE FirstName='a'

B. SELECT * FROM Persons WHERE FirstName LIKE '%a'

C. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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

A. SELECT UNIQUE

B. SELECT DISTINCT

C. SELECT DIFFERENT

A. select honours_subject, avg(percentage_of_marks) from students where avg(percentage_of_marks) > 50.0 group by honours_subject;

B. select honours_subject, avg(percentage_of_marks) from students having avg(percentage_of_marks) > 50.0 group by honours_subject;

C. select honours_subject, avg(percentage_of_marks) from students group by honours_subject having avg(percentage_of_marks) > 50.0;

D. None of the above.

A. 33

B. 30

C. 3

D. 10

A. delete view all_marks_english;

B. drop view all_marks_english;

C. delete all_marks_english;

D. drop all_marks_english;

A. SUM

B. NVL

C. COUNT

D. MIN