Technical Interview Questions and Answers :: Syntel Inc.
- Select All
- Oracle PLSQL
- Java
- C++
- WebMethod
- C
- DBMS
- Operating System
- Oracle Apps HRMS
- Networking
- Soft. Engineering
- HR Question in TR
- Data Structure
- .NET
- SQL
81 / 161
To delete the data permanently we use 'commit' statement, to roll the transaction back to a certain point, without rolling back the entire transaction we use 'savepoint', to get deleted data rollback is used.
82 / 161
No Discussion on this question yet!
83 / 161
No Discussion on this question yet!
84 / 161
#include <stdio.h>
int main(){
if(printf("q4 Interview")){
}
}
note that printf returns the value printed to stdout so the above program prints q4 interview
85 / 161
No Discussion on this question yet!
86 / 161
Delete command and truncate command both will delete the data, however the truncate command can not be rolled back as delete can be. The delete command can be used for selected records using the where clause but with the truncate command we have to loose data. DELETE statement is a logged operation and hence takes more time then truncate.
87 / 161
SELECT Id, count (*) as number_records from table group by id having count (*) > 1.
88 / 161
No Discussion on this question yet!
89 / 161
No Discussion on this question yet!
90 / 161
No Discussion on this question yet!