What is dba and functionalities of dba?

301

What are types of data model?

292

What does the no logging option do? Why would we be careful of using it?

280

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

273

What does the no logging option do? Why would we use it? Why would we be careful of using it?

297

System tablespace cant be exported from one database and imported into another why?

286

What are the main functions of dba?

271

How do I become a data manager?

264

When configuring sqlnet on the client what files need to be set up?

263

What is the difference between sga and pga?

321

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

285

How can you find out how many users are currently logged into the database?

323

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

288

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

269

What do you understand by the term 'system change number (scn)'?

318