Answer Posted / pallavi
cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within sql statement
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what do you understand by flashback feature of oracle?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the default port no on which sql server listens? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Why would you use sql agent? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the importance of a recovery model? : sql server DBA
what is a crs resource?