How can you tell if a database object is invalid

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How can you tell if a database object is invalid?

Level: Low
Expected answer: By checking the status column of the DBA_, ALL_ or USER_OBJECTS views, depending upon whether you own or only have permission on the view or are using a DBA account.

(Continued on next question...)

Other Job Interview Questions

• What is an Index?
• Which of the two views should objects according to possession?
• What is a Tablespace?
• What is bind reference and how can it be created?
• Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?
• When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -How do you correct it?
• What is the advantage of the library?
• Can a formula column referred to columns in higher group?
• What is the maximum number of triggers, can apply to a single table?
• What is a difference between pre-select and pre-query?
• More...