Question 1. What Is A System Tablespace And When It Is Created?
When the database is created in Oracle database gadget, it routinely generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains information dictionary tables for the complete database.
Question 2. What Is The Fastest Query Method To Fetch Data From The Table?
You can use ROWID to fetch Row from the desk. The use of ROW ID is the fastest question method for fetching facts from the desk.
Oracle 10g Interview Questions
Question three. What Is Using Clause And Give Example?
he USING clause is used to specify with the column to check for equality while two tables are joined.
[sql]Select * from table1 join table2 using table1 ID[/sql]
table1 tables join with the table2 tables with the tableID.
Question 4. What Is The Purpose Of Save Points In Oracle Database?
Save Points are used to divide a transaction into smaller phases.
It allows rolling returned a part of a transaction.
Maximum 5 store points are allowed in Oracle Database.
Whenever an errors is encountered, it is viable to rollback from the point where the SAVEPOINT has been saved.
Oracle 10g Tutorial
Question five. What Is An Oracle Index?
An index is an non-compulsory shape associated with a desk to have direct access to rows, which can be created to boom the overall performance of records retrieval. Index may be created on one or more columns of a desk.
Oracle 9i Interview Questions
Question 6. Explain The Function Of Optimizer In Oracle?
The optimizer determines the most green way to execute a SQL announcement based totally on the sort of records inside the desk and the statements fired to fetch that statistics like indexes, complete table scans, loops, joins and so on. Optimizers also are used to avoid excessive I/O resources.
Question 7. What Is The Use Of Aggregate Functions In Oracle?
Aggregate characteristic is a feature in which values of multiple rows or facts are joined together to get a unmarried fee output.
Common aggregate features are :-
Oracle 9i Tutorial Informatica Interview Questions
Question eight. What Is Hash Cluster?
Hash Cluster is a technique used for storing the table to make it faster to retrieve. It order to retrieve the rows from the desk, practice the hash cost on the table.
Question nine. What Is Hot Backup And How It Can Be Taken?
Hot backup is taking backup of archived log documents when database is open.THe ARCHIVE LOG switch have to be enabled for this to take place. Hot backup occurs while the database remains being accessed with the aid of users and tables are being updated. It does not want the database to have a downtime.
PL/SQL Interview Questions
Question 10. What Are The Components Of Physical Database Structure Of Oracle Database?
Components of bodily database shape are given underneath:
One or greater data documents.
Two or extra redo log documents.
One or more manipulate files.