sql quiz

Expand SQL

• Structured query language

• System Query Language

• structured queue language

• None

Which of the following are pseudo columns

• ROWID

• CURRVAL

• CONNECT_BY_ISCYCLE

• ALL

Which of the following are SQL Components?

• Data Definition Language

• Data Manipulation Language

• Transaction Control Language

• All

pick the correct arithmetic operators.

• +,-,*,/

• =,IN,NOT IN,Exists

• both a&b

• none

which of the following are comparision operators

• LIKE

• IN

• Between

• <=

• all

which of the following are Logical operators

• AND

• +

• IN

• UNION

which of the following are set operators?

• UNION

• INTERSECTION

• NOT

• ALL

which of the following is used for table creation

• create table

• insert

• delete

• update

create _________ table_name(column datatype,column datatype,...);

Insert into table___________(value1,value2,.....):