1. Which is an aggregate function?
a. Union b. like c. max d. Rank
what are the types of join and explain each? : Sql dba
Does truncate need commit?
How collections are improve the performance?
there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is an invalid partition table?
How long will it take to learn pl sql?
How many null values can be inserted in a coulmn whihc is unique constraint
how many no of table can be join in a sql query.
What is meant by temporal data?
How you will create Toad Function?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?