Set - 9

Question 31 :

What is the difference between the SQL*Loader and IMPORT utilities?

Answer :

These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL*Loader utility allows data to be loaded that has been produced by other utilities from different data sources just so long as it conforms to ASCII formatted or delimited files.


Question 32 :

Name two files used for network connection to a database.

Answer :

TNSNAMES.ORA and SQLNET.ORA


Question 33 :

What is the function of Optimizer ?

Answer :

The goal of the optimizer is to choose the most efficient way to execute a SQL statement.


Question 34 :

What is Execution Plan ?

Answer :

The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.


Question 35 :

Can one resize tablespaces and data files? (for DBA)

Answer :

One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command.
ALTER DATABASE DATAFILE 'filename2' RESIZE 100M;
Because you can change the sizes of datafiles, you can add more space to your database without adding more datafiles. This is beneficial if you are concerned about reaching the maximum number of datafiles allowed in your database.
Manually reducing the sizes of datafiles allows you to reclaim unused space in the database. This is useful for correcting errors in estimations of space requirements.
Also, datafiles can be allowed to automatically extend if more space is required. Look at the following command:
CREATE TABLESPACE pcs_data_ts
DATAFILE 'c:\ora_apps\pcs\pcsdata1.dbf' SIZE 3M
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
DEFAULT STORAGE (INITIAL 10240
NEXT 10240
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0)
ONLINE
PERMANENT;