You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

273

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

288

What is difference between co-related sub query and nested sub query?

295

What is the purpose of the grep command?

276

How many control files should you have?

265

What is the easiest method to create a file on unix?

283

Which database is best to learn?

280

What is oracle dba role?

274

What are four common errors found in an alert .log?

280

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

287

What does a dba do all day?

274

Do you need a commit after ddl statements?

279

What are the various ingredients of sga?

276

What is a junior dba?

285

What are the five functions of a database?

307