Difference between “ORACLE” and “MICROSOFT ACCES

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

(Continued from previous question...)

127. Difference between “ORACLE” and “MICROSOFT ACCESS” databases.

Answer1
ORACLE ….can be use with a no of platform eg unix,windown,solaris.SQL that is use for retriving data from oracle is known as Transact SQL.ORACLE is very big database compare with MSAcess.
MSAcess……Can be use with windows only.SQL use is known just as SQL.

Answer2
MSA support only in windows platforms. But oracle available in all platforms. No security and there is no conceprs of schema,users,privilages in access. Aceess is used in small and medium organizations. Oracle is a collection of large no database tools for mangaing data.

(Continued on next question...)

Other Job Interview Questions

• What is the maximum number of triggers, can apply to a single table?
• What is the mechanism provided by ORACLE for table replication?
• Any three PL/SQL Exceptions?
• What are the various sub events a mouse double click event involves?
• What are three panes that appear in the run time pl/SQL interpreter?
• What is strip sources generate options?
• Is it possible to disable the parameter from while running the report?
• What is a deadlock?
• Can a Tablespace hold objects from different Schemes?
• What are the built-ins used for processing rows?
• More...