|
Question |
Rating |
View Answer |
|
Difference - Primary Key and Aggregate Key
|
|
View Answer |
|
Why can a "group by" or "order by" clause be expensive to process?
|
|
View Answer |
|
Difference - Primary Key and Aggregate Key
|
|
View Answer |
|
How to remove duplicate records from a table?
|
|
View Answer |
|
What is the difference between "procedure" and "function"?
|
|
View Answer |
|
What is the maximum value that can be stored for a datetime field?
|
|
View Answer |
|
Give some examples of Analytical functions.
|
|
View Answer |
|
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employye table and department table with employee having department no.
|
|
View Answer |
|
What is DYNAMIC SQL method 4?
|
|
View Answer |
|
How many column maximum we can add in one table and how many foreign key maximum we can use in one table
|
|
View Answer |
|
What is a "trigger"?
|
|
View Answer |
|
Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?
|
|
View Answer |
|
Explain Normalization and Denormalization with examples.
|
|
View Answer |
|
Name of the class of sql
|
|
View Answer |
|
What is the use of Analyzing the tables?
|
|
View Answer |
|
When do you get constraint violation? What are the types of constraints?
|
|
View Answer |
|
What is the difference among "dropping a table”,” truncating a table" and deleting all records" from a table.
|
|
View Answer |
|
What is SQL*Loader?
|
|
View Answer |
|
Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause
|
|
View Answer |
|
What is the use of database index (apart from fast searching of records);What is use of composite key ?
|
|
View Answer |