What are the requirements of simple database?

519

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

488

How many types of database software are there?

536

How does one create a new database?

536

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

536

What operator tests column for the absence of data?

540

What are dba privileges?

484

What are the types of schemas?

530

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

549

Is oracle dba in demand?

535

What does an oracle dba do?

539

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

508

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?

560

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

643

What is dba software?

581