When creating a user, what permissions must you grant to
allow them to connect to the database?
- 3 Answers
- 7862 Views
- I also Faced
- E-Mail Answers
Answer Posted / sweta
Grant connect,create session to <username>;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the different sql server versions you have worked on? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
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?
What are the steps you will take to improve performance of a poor performing query?
What is fill factor? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
what is the role of dip user in our database?
What is a correlated sub-query? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
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.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the recovery models for a database? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
