Oracle SQL Interview QuestionsPosted by Kendba Admin on Feb 28, 2011 in Sample Chapters | Comments Off
Oracle DBA Interview Questions Answers during technical interview – A Sample Chapter
Oracle Interview Questions and Answers during telephonic technical interviews
A Sample Chapter of book Oracle DBA Interview Questions – Topic covered in this sample chapter is “SQL – Essential for Oracle DBA”
Here you can find out some Oracle Interview Questions and Answers for the topic of Oracle SQL and RDBMS. These all interview questions and answers are real time Oracle DBA interview questions and answers. Be careful about Oracle DBA interviews because sometime very strange SQL questions might be raised during interviews. As a Oracle DBA candidate you can’t eliminate the SQL interview questions during Oracle DBA interviews.
Some strange interview questions are really very simple but we found those strange because you are not aware of those questions and answers. Most of cases candidate failed due to not preparing proper interview questions and answers.
Following all Oracle DBA interview questions and answers are sampling from our excellent book “Oracle DBA Interview Questions and Answers”. These are only sample interview questions and answers of Oracle DBA book’s topic “SQL – Essential for Oracle DBA”. Full topic is covered in book with total 50 important and strange SQL interview questions with answers.
Q-1: How to determine the structure of the any table? Give to 2 options?
Q-2: Give the two types of tables involved in producing a star schema and the type of data they hold.
Q-3: If I am executing command “select 8 from emp” then what would be happening?
Q-4: A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Q-5: What is a Cartesian product?
Q-6: What is the default ordering of an ORDER BY clause in a SELECT statement?
Q-7: What type of index should you use on a fact table?
Q-8: What is basic difference between view and materialized view?
Q-9: Can a table contain more than 1 primary key?
Q-10: Any trick to create more than one primary key on single table?
Q-11: Can Check constraint be used for self referential integrity ? How ?
Q-12: Can null keys be entered in cluster index, normal index? OR can I able to insert NULL values in cluster index or normal index?
Q-13: What is the use of Data Dictionary?
Q-14: Are views automatically updated when base tables are updated?
Q-15: What is the SYSDATE? Is Sysdate a system variable or a system function?
Q-16: What is the difference between alias and synonym?
Q-17: What is the difference between foreign key and reference key?
Q-18: Can DUAL table be deleted, dropped or altered or updated or inserted?
Q-19: Any effect will be occurring after updating or changing DUAL table?
Q-20: What is the difference between SQL*Plus commands and SQL commands?
Q-21: Can I execute SQL*Plus command from buffer?
Q-22: Is it possible to use LONG columns in WHERE clause or ORDER BY?
Q-23: What is ROWNUM and ROWID in Oracle table?
Q-24: Give difference of ROWID and ROWNUM?
Q-25: Can we insert more than single NULL in unique constraint or unique index?
Q-26: Can we create unique constraint using non-unique index?
This is the sample SQL interview question answers from topic “SQL – Essential for Oracle DBA” of the book Oracle DBA Interview Questions. Kendba provides unique career making services for Oracle DBA from start online Oracle Training, Oracle interview questions books, fresher Oracle jobs assistance services.