Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of this query
selet * from employee where 1=2
- 7 Answers
- 11600 Views
- Tera Informatics, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / asha
I Agree with Satya K
If the Table contanins the columns as
EMPLOYEE table
EmpNo Ename Salary
101 Hello 1000
102 hi 2000
103 dear 3000
When you execute the above query it gives only the
structure of the table...with the blank rows
Ans : EmpNO Ename Salary
is displayed
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / jana
here only the structure of the table is available and what
ever the data is there in the table is not copied into the
other table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / qaprofessional
This query would copy the structure, when the query is like
select into abc from xyz where 1=2 would result in the
structure of xyz getting copied to abc.
This query would return no values
| Is This Answer Correct ? | 0 Yes | 0 No |
hai poonam i am rajendra
if you execute query like
selet * from employee where 1=2
here the where condition is meaningless
but you have selected all columns of data from table
it just displays all column names of table without data.
Not only where 1=2 for nay meaningless condition.
if you have still any doubt plz mail me i can send you
answers.
ok byeeeee
Rajendra Prasad Reddy
Mobile:+91-9885162742
Hyderabad.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is Alpha testing/ Beta testing?
Hi Friends How can we do manual testing? Is it similar to QTP? can some one give real time examples or point me to some websites or books where i can practice manual testing. pls give some ideas. It would be great help. Thanx & regards sunitha.
when u involved in uat suppose if u find one defect then do u intmate it or not
In front end if you enter one record it will be inserted in to 20 tables in back end.so How you are going to test in Manually whether data is going properly in to concern data tables or not? Is there any better solution to do that instead of opening the table and checking individually?
1. Write configuration tests for a web based application. 2. How does a plane turn on ground? Explain with logic. 3. How would you test the volume control for a music system? 4. You have been given an application and you have only 15 mins to test the application. How would you do the testing? 5. Your machine, which is on a network has been disconnected. How you debug the problem? 6. What is the sum of numbers from 1 to 1000? 7. What is the probability that on rolling four dices same number appears on all dices? 8. You have been given 8 identical balls out of which one of them is heavier. How would find the heavier ball in the least number of tries with the help of a balance? Explain 9. There is a disc which has been painted half black and half white. You have been given sensors which could detect white or black colors. The disc is revolving in either clockwise or anticlockwise direction with variable angular speed. Find the minimum number of sensors required to determine the direction of rotation of the disc. 10. 64,54,42,31,20 which number does not fit in the series?
I attendend written test in NDS bangalore in aug 2009. 20 aptitude and 10 descriptive questions. In aptitude they ask sums from time and work,time and distance,tap,feet and inches(12 inches=1feet),percentage etc...
What is Internal Links, External Links, orphan Pages, Broken Links
When a defect is assign as Postponed and differed. explain with example? thanks
If the Developers are unable to understand the bug send by the testers , then how will the Testers convince or explain the developer.
The degree to which the software LOC of a program has been tested is called A.Data flow testing B.Code coverage C.Code walk through D.Statement coverage
What type of testing process do you follow in current organisation?
how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?
Automation Testing 
