Which data type can store unstructured data in a column?
a) CHAR
b) RAW
c) NUMERIC
Which of the following is not Constraint in SQL?
a) primary key
b) not null
c) check
d) union
Which of the following is not a valid aggregate function?
a) count
b) compute
c) sum
d) max
Which data manipulation command is used to combines the records from one or more tables?
a) select
b) project
c) join
d) product
If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default……..
a) DESC
b) ASC
c) no default value
d) none of these
Explanation: ASC stand for ascending order of values
What is returned by INSTR ('JAVAT POINT', 'P')?
a) 6
b) 7
c) POINT
d) JAVAT
