Database Interview Questions
Oracle Technical Interview Questions
- What are the built-in functions used for sending Parameters to forms?
- Can you have more than one content canvas view attached with a window?
- Is the After report trigger fired if the report execution fails?
- Does a Before form trigger fire when the parameter form is suppressed?
- Is it possible to split the print reviewer into more than one region?
- Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?
- For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
Basic Database Interview Quesitons
- What are the different types of joins?
- Explain normalization with examples.
- What cursor type do you use to retrieve multiple recordsets?
- Diffrence between a “where” clause and a “having” clause
- What is the difference between “procedure” and “function”?
- How will you copy the structure of a table without copying the data?
- How to find out the database name from SQL*PLUS command prompt?
- Tadeoffs with having indexes
- Talk about “Exception Handling” in PL/SQL?
- What is the diference between “NULL in C” and “NULL in Oracle?”
- What is Pro*C? What is OCI?
Interview Question for DBA
- How many memory layers are in the shared pool?
- How do you find out from the RMAN catalog if a particular archive log has been backed-up?
- How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up?
- Define the SGA and how you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
- What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
MySQL and General Database Interview Questions
- What is MySQL?
- What is Postgres?
- What are the basic steps in setting up an Oracle system?
- What is a stored procedure, and which databases support it?
- What is RMAN?
- What is the TDS protocol?
- What is required to connect to an oracle system remotely?
- In MySQL, how do I create a database?
- In MySQL, how do I grant access to a user to a specific database with read only permissions?
- In MySQL, what table type is required for foreign keys to work?
Interview Questions for Oracle Database Administrator
- Differentiate between TRUNCATE and DELETE
- What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
- Can you use a commit statement within a database trigger?
- What is an UTL_FILE.What are different procedures and functions associated with it?
- Difference between database triggers and form triggers?
- What is OCI. What are its uses?
- What are ORACLE PRECOMPILERS?
- What is syntax for dropping a procedure and a function? Are these operations possible?
- Can a function take OUT parameters. If not why?
- Can the default values be assigned to actual parameters?
