|
Question |
Rating |
View Answer |
|
What is join in sql? |
|
View Answer |
|
Advantages and disadvantages of attributes. |
|
View Answer |
|
What is compute command? |
|
View Answer |
|
What is an integrity constraint? |
|
View Answer |
|
Write short notes in XSU & java ? |
|
View Answer |
|
What is correlated subquery? |
|
View Answer |
|
How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value? |
|
View Answer |
|
What is Commit event used for? |
|
View Answer |
|
Given an employee and manager table, write a SQL syntax that could be used to find out an employee's manager's manager, assuming all managers are in the employee table.
|
|
View Answer |
|
Explain about the object language binding’s extension? |
|
View Answer |
|
Explain about the MERGE field? |
|
View Answer |
|
What is SQLLoader? |
|
View Answer |
|
What is the difference between Single row sub-Query and Scalar sub-Query
|
|
View Answer |
|
What are the advantages of client/server model ?
|
|
View Answer |
|
Identify error in following SQL: SELECT EMPNO, SUM(SAL) FROM EMP GROUP BY EMPNO HAVING ENAME= ‘KENT’ a) Syntax Error b) SUM() is not an aggregate function c) HAVING can not be used with GROUP BY d) The Having condition has to be based on some column that appears in the select list. |
|
View Answer |
|
What is the difference between SQL and SQL Server?
|
|
View Answer |
|
Can we call user defined packages in SQL statements?
|
|
View Answer |
|
What is the difference between "select * from table name" and "select column_name from table name" The above quiries are simple select quiries without having any "where" clause. Secondly which query will be performed faster and why?? |
|
View Answer |
|
What's the difference between a primary key and a unique key? |
|
View Answer |
|
How do we select the employees detail from the table who were joined in the last 5yrs? |
|
View Answer |