Maximum number of columns allowed inside an index
12
256
128
32
Which of the following is DDL Statement
Truncate
Merge
Revoke
Grant
Select the incorrect Oracle Select Statement
select distinct * from T1
select C1 from T1 order by C2
select distinct C1 from T1
select 12*14 from T1
select C1 AS 'column1",C1 AS 'column2',C2 AS 'column1' from T1.
Which of the following is a DML Statement
We can sort by a column without present in the SELECT List
True
False
Select Incorrect Oracle Group Function
floor
sum
variance
stddev
which of the following views identify the status of the view in the database
USER_VIEWS
USER_TAB_COLUMNS
USER_TABLES
USER_OBJECTS
ROWID is a column datatype
we can select while LOCk is on a rows
reference to sysdate,nextval,currval is allowed on constraint definition