Worksheetssql quiz
Total questions: 15
Worksheet time: 8mins
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 (a) table_name(column datatype,column datatype,...);
Insert into table (a) (value1,value2,.....):
syntax to delete row from table:
(a) from table_name;
which statment is used to modify the content of the table?
create
insert
update
delete
Which of the following is used to modify the size of column?
Create
pdate
Alter
Delete
which of the following are TCL operations
grant
revoke
rollback
none
which of the following are used for removing the rows from the table
Truncate
Delete
A&B
nonw
