Interested to Buy Any Domain ? << Click Here >> for more details...
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY
PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT
PRIVILIZES.
- 4 Answers
- 8337 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / suman
we have 8 privilizes that is
create index
create views
create synonyms
create tables
create procedures
create triggers
create functions
we can see in db level that is
> desc v$session_privilizes;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is grd?
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?
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.
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
how can you initialize log miner?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What is the difference between clustered and non-clustered index? : sql server DBA
what is the diffrence between core dba and apps dba?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can a session indicate its interest in receiving alerts?
what is the use of ocr?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What the different topologies in which replication can be configured? : sql server DBA
