-
Oracle Unused Column
How to set unused column back to normal column?
-
Block Level Recovery
How can we perform block level recovery in database files?
-
Insert Picture or Sound Clipping
How to insert a picture or sound clipping in Oracle Database?
-
SQL Loader
How does Export/Import feature differ from that of SQL Loader?
-
Auto Commit
When we insert new values into the table using loops. Is it going to be auto commit or do we need to commit manually?
-
1st and 2nd Normalization
How to perform 1st and 2nd normalization? Explain with example.
-
Database Backup & Restore
Tell the step by step procedure of taking backup of database & restore the same in case of database crash.
-
Process and a Program
What is the difference between process and program? Is this difference important in single process operating system? Why? Why not?
-
Monitor the Database
How to monitor the database ?Why shmmax and semaphore parameters are used whenever we are installing database on linux?
-
Composite Variables
What are Composite Variable?
-
Identify Instance Name
How we identify instance name, free space, used space in database & datafile that makes up the system tablespace?
-
UNIX Security Mechanisms
What are the different security mechanisms available in UNIX?
-
Converting extended E-R model
Describe the process of converting an extended E-R model into a relational database design.
-
one to many
Explain the representation of a one-to-many strong entity relationship in a relational database design.
-
Primary Key
Why is the choice of primary key important and are three characteristics of an ideal primary key?
-
Type of Participation
What is meant by type of participation? Name the three types of relationship participation.
-
Degree of Relationship
What is the degree of relationship? Name the three degrees.
-
Find which parameter file Oracle is using
When a Oracle instance is up, How can we find which parameter file (pfile or spfile) the oracle is using?
-