1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER
DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION
AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT
TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01-
JAN-2007 TO 01-JAN-2008?
In my job I have 6 steps. Step01,02,03...step06.
after executing step02 i want to skip step03 and want to
execute step04. and once step04 is done then I want to go
back and execute step03. once step03 is completed I want
execute step05, 06 and so on... can any one tell me how do
i do that???
How do you script this scenario in QTP using VB?
Verify XML attributes in XML message against XSD and data
mapping of fields to Oracle tables? Verify data in XML to
data in a defined table?
HOW TO RUN SEVERAL TESTS AT A TIME USING TEST DIRECTOR ?
WITH OUT USING AUTOMATION TOOL?
(FOR EXAMPLE IF I GIVEN 20 TESTS TO TESTDIRECTOR FOR
RUNNING PURPOSE IN TODAYS NIGHT I WANT TO CHECK THE TEST
RESULTS NEXT DAY) HOW TO DO THIS ?