Answer / suman

we have to create any user in system level By default we
have 8 prives that is
create table
create index
create sysnonims
create view
etc......
sys>desc v$session_prives;

Answer / 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;

Answer / ravindra

Grant Create Session,Resource;

Answer / feroz

creating user at OS level wont get any privileges
question is not clear first of all?
how come a DBA will be able to create a user
we cann't create users at DB2 level

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

What is dcl? : sql server DBA

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---