SQL plus Interview Questions
- What is ROWID?
- What is a transaction?
- How to drop the index?
- What is a database link?
- What are the pre requisites?
- What is a Cartesian product?
- What is Referential Integrity?
- What is a corelated sub query?
- Any three PL/SQL Exceptions?
- What is an Integrity Constraint?
- How to drop the column in a table?
- Explain some PL/SQL Exceptions?
- What are the advantages of VIEW?
- Explain the different types of joins?
- Display the number value in Words?
- What is a Non- corelated sub query?
- Explain what is a Cartesian product?
- What are the different types of SQL?
- What are PL/SQL Cursor Exceptions?
- What are the types of SQL Statement?
- What do you know about sub queries?
- Display Odd/ Even number of records?
- How do I eliminate the duplicate rows?
- Can a view be updated/inserted/deleted?
- Explain what is an Integrity Constraint?
- What are the data types allowed in a table?
- What is explaining plan and how is it used?
- How do I display row number with records?
- Explain what are the different types of SQL?
- Explain how do we eliminate the duplicate rows?
- How can you call a PL/SQL procedure from SQL?
- What is the maximum SIZE allowed for each type?
- What is the fastest way of accessing a row in a table?
- How will you a activate/deactivate integrity constraints?
- Where the integrity constraints are stored in Data Dictionary?
- How do I replace a comma (,) with a blank in a select statement?
- What is the maximum number of triggers, can apply to a single table?
- Can a view be updated/inserted/deleted? If Yes under what conditions?
- Explain How do we replace a comma (,) with a blank in a select statement?
- Explain what is the maximum number of triggers is, can apply to a single table?