Oracle Database(DBA) Interview Questions and Answers

What are the components of Physical database structure of Oracle Database?
ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.
What are the components of Logical database structure of ORACLE database?
Tablespaces and the Database's Schema Objects.
What is a Tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.
What is SYSTEM tablespace and When is it Created?
Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. Explain the relationship among Database, Tablespace and Data file. Each databases logically divided into one or more tablespaces One or more data files are explicitly created for each tablespace.
What is schema?
A schema is collection of database objects of a User.
What are Schema Objects ?
Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables,views,sequences,synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.

Can objects of the same Schema reside in different tablespaces.?
Yes.
Can a Tablespace hold objects from different Schemes ?
Yes.
What is Data Block?
ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

How to define Data Block size?
A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and cann't be changed latter.
What is Row Chaining?
In Circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs, the data for the row is stored in a chain of data block (one or more) reserved for that segment.
What is an Extent?
An Extent is a specific number of contiguous data blocks, obtained in a single allocation, used to store a specific type of information.
What is a Segment?
A segment is a set of extents allocated for a certain logical structure.
What are the different types of Segments?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
What is a Data Segment?
Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.
What is an Index Segment?
Each Index has an Index segment that stores all of its data.

Latest Updates

Apache Tomcat

What is the difference between Apache Tomcat server and Apache web server?

MS-DOS

What is the full form of DOS?

Explain the use of help DOS Command?

How we can create a directory in DOS?

Analogy

Riddle:Solve

Limp:Walk

Molecule:Atoms

Misfortune:Catastrophe

Pipes and Cistern

A tank can be filled by one tap in 10 minutes and by another in 30 minutes. Both the taps are kept open for 5 minutes and then the first one is shut off. In how many minutes more is the tank completely filled?

Simplification

Assume that a sum of money is divided equally among n girls. Each girl will receive $60. If another girl is added to the group and the sum is divided equally among all the girls, each child girl gets a $50 share. What is the sum of money?

Problems on Trains

A 300 meter long metro train crosses a platform in a metro station in 39 seconds while it crosses a lamp post in 18 seconds. What is the length of the platform?

Problems on Ages

In a group of 7 people, the average age is found to be 17 years. Two more people joined with an average age 19 years. One person left the group whose age was 25 years. What is the new average age of the group?

Profit and Loss

Irvin sold a book at a profit of 12%. If Irvin had sold it for Rs 18 more, then 18% would have been gained. Find the cost price?

Chemistry

Non stick cooking utensils are coated with?

The group of metals Co, Ni, Fe may best called as?

General Knowledge of India

'Kanchipuram' is in which of the following states?

General Knowledge of World

In which year was Pulitzer Prize established?

Indian History

The roads of cities in the Indus Valley Civilization generally divided the city into?

Latest Job Notifications

Jobs in West Bengal

इंडियन पोस्ट सर्विस Indian Post Service - 2357 पद - 19/08/2021 अंतिम तिथि - पश्चिम बंगाल पोस्टल सर्कल

Banking Jobs

भारतीय स्टेट बैंक State Bank of India(SBI) - 6100 पद - 26/07/2021 अंतिम तिथि - CRPD/APPR/2021-22/10

SSC Recruitment

कर्मचारी चयन आयोग Staff Selection Commission(SSC) - 25271 पद - 31/08/2021 अंतिम तिथि

Jobs in Madhya Pradesh

राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 5215 पद - 22/06/2021 अंतिम तिथि

Jobs in Punjab

पंजाब स्टेट पावर कॉर्पोरेशन लिमिटेड Punjab State Power Corporation Limited (PSPCL) - 2632 पद - 20/06/2021 अंतिम तिथि

Jobs in Chhattisgarh

स्वास्थ्य सेवा निदेशालय, छत्तीसगढ़ Department of Health & Family Welfare, Chhattisgarh - 267 पद - 26/06/2021 अंतिम तिथि

Government Jobs

दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 5807 पद - 03/07/2021 अंतिम तिथि

Jobs in Madhya Pradesh

राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 2850 पद - 31/05/2021 अंतिम तिथि

Government Jobs

इंडियन पोस्ट सर्विस Indian Post Service - 4368 पद - 29/05/2021 अंतिम तिथि

दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 7236 पद - 24/06/2021 अंतिम तिथि