delete will lower the water mark
True
False
Which of the following denote group clause in SQL
having
group by
where
both 1 and 2
If base table does not exists, can we create a view?
If the base table of a view is deleted and we give SQL Select command on view table name
Gives the columns referred in select statement of view
Reports a error
Select only particular columns of view table
Outputs the whole view table
Which of the following data types are used in SQL?
Long
Date
rowid
all above
Which of the following SQL statement create a sequence SE with starting value as 30 and in increments of 20?
GENERATE SEQUENCE SE START WITH 30 ADD BY 20;
CREATE SEQUENCE SE START WITH 30 ADD BY 20;
CREATE SEQUENCE SE START WITH 30 INCREMENT BY 20;
GENERATE SEQUENCE SE INITIATE WITH 30 INCREMENT BY 20;
Which of the following is TRUE about Primary Key?
Same value of Primary Key can appear in more than one row in the table
A Primary key defined column can be of type LONG
A column that is defined as Primary Key cannot contain NULL value
Both A. and B.
Which of the following is not allowed while creating a table using CRRATE TABLE in SQL?
Table name can be an oracle reserved word
Table names must begin with a letter
Table names can contain in it numbers also
None of the Above
With SQL, how can you return the number of records in the "Persons" table?
SELECT COLUMNS(*) FROM Persons
SELECT COUNT() FROM Persons
SELECT COUNT(*) FROM Persons
SELECT COLUMNS() FROM Persons
Which SQL keyword is used to sort the result-set?
order
sort
order by
sort by