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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Where would you look for errors from the database engine?
What is dcl? : sql server DBA
What are the commands used in dcl? : sql server DBA
how can you enable flashback feature?
What is dbcc? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what are the benefits of flashback feature?
Explain about your sql server dba experience? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the operating modes in which database mirroring runs? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?