When creating a user, what permissions must you grant to
allow them to connect to the database?
Post New Answer View All Answers
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are statistics, under what circumstances they go out of date, how do you update them?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How would you go about verifying the network name that the local_listener is currently using?
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.
how can you communicate with operating system files from oracle?
What is a system database and what is a user database? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what are the differences of where and if in SAS?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you record information about current session?
what is asm?