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?
499You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
452If you have an example table, what is the best way to get sizing data for the production table implementation?
399Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
390Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
425If you see the value for reloads is high in the estat library cache report is this a matter for concern?
453Post New Oracle DBA (Database Administration) Questions
Which is the best option used to move database from one server to another serve on same network and why?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
Why do we need a database?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What does database administrator do?
What are the types of schemas?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What exactly does a dba do?
What is oracle dba role?
What are the possible ways to gain information regarding the control file?
What are functions of dba?
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?
What does dba stand for in technology?
What is the use of the drop option in the alter table command?
What skills does a dba need?