|
Question |
Rating |
View Answer |
|
When I have 6 values for any column, in select statement I get display of 6 rows selected while if I have 5 values for one column i don't get display of 5 rows selected, how to get that display? |
|
View Answer |
|
table name stud,a mark 23,b mark 87,c mark 75,d mark 34; write the query to find 2nd highest mark in stud table? |
|
View Answer |
|
Whet are the difference between primary key and foreign key? |
|
View Answer |
|
What are various joins used while writing SUBQUERIES? |
|
View Answer |
|
What are various constraints used in SQL? |
|
View Answer |
|
What are different Oracle database objects? |
|
View Answer |
|
What is difference between Rename and Alias? |
|
View Answer |
|
What is a view? |
|
View Answer |
|
What are various privileges that a user can grant to another user? |
|
View Answer |
|
What is difference between UNIQUE and PRIMARY KEY constraints? |
|
View Answer |
|
Can a primary key contain more than one columns? |
|
View Answer |
|
How you will avoid duplicating records in a query? |
|
View Answer |
|
What is difference between SQL and SQL*PLUS? |
|
View Answer |
|
Which datatype is used for storing graphics and images? |
|
View Answer |
|
How will you delete duplicating rows from a base table? |
|
View Answer |
|
What is difference between SUBSTR and INSTR? |
|
View Answer |
|
There is a string 120000 12 0 .125 , how you will find the position of the decimal place? |
|
View Answer |
|
There is a % sign in one field of a column. What will be the query to find it? |
|
View Answer |
|
When do you use WHERE clause and when do you use HAVING clause? |
|
View Answer |
|
Which is more faster - IN or EXISTS? |
|
View Answer |