Showing posts with label Oracle Interview Questions and Answers on SQL Queries and Database Theory. Show all posts
Showing posts with label Oracle Interview Questions and Answers on SQL Queries and Database Theory. Show all posts

Tuesday, July 30, 2013

Oracle Interview Questions and Answers

1) What is oracle database ?
Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated from each other

2) What is schema?
A user account and its associated data including tables, views, indexes, clusters, sequences,procedures, functions, triggers,packages and database links is known as Oracle schema. System, SCOTT etc are default schema's. We can create a new Schema/User. But we can't drop default database schema's.