Scribd
Upload
9 views2 pages

Question

The document provides an overview of database concepts, including definitions of various database types, ACID properties, and specific Oracle Database components such as instances, data files, and control files. It also covers SQL usage, database operations, and the importance of normalization and ER diagrams in database management. Additionally, it discusses NoSQL databases and RAID technology, highlighting their advantages and disadvantages.

Uploaded by

romanmolla047
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views2 pages

Question

The document provides an overview of database concepts, including definitions of various database types, ACID properties, and specific Oracle Database components such as instances, data files, and control files. It also covers SQL usage, database operations, and the importance of normalization and ER diagrams in database management. Additionally, it discusses NoSQL databases and RAID technology, highlighting their advantages and disadvantages.

Uploaded by

romanmolla047
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Section – 1:

What is Database?

What are the various databases available in the market?

What is the ACID property in a database?

Define Oracle Server

Define Oracle Instance.

Define Oracle Database.

What are the different Oracle Database objects?

What are the types of backups in Oracle?

What are Data Files?

What are Control Files?

What are Redo log Files?

How will you recover a lost control file?

Define Parameter Files

Define System Tablespace and its significance.

Explain the advantages of using view?

In Oracle terminology, what do you mean by tablespace?

How long does it take for the SYSTEM tablespace to be created?

What is the relationship between tablespace and data files?

How do we use the materialized view?

What are the uses of SQL?

What is the purpose of the SELECT statement?

What is the keyword to get distinct records from a table?

What is the definition of GROUP BY?

What are the methods for shutting down an Oracle Database?

What are the common Oracle DBA tasks?

What are the tools you can use to start up an Oracle Database?
Can you explain each digit in the Oracle database version?

Explain how the database writer process (DBWn) works.

Explain how the log writer process (LGWR) works.

What is database client and server?

Explain how user connectivity happens in database.

There are 100 users connected to database and listener goes down. What will happen?

Explain about optimizer?

What is PGA or Private Global Area? How it is different from SGA?

Section – 2:

What is ER (Entity Relationship) Diagram in DBMS?


Define Components of ER Diagram.
What is NoSQL Database?
Write down Advantage of NoSQL and Dis Advantage of NoSQL
What is Normalization?
Why do we need Normalization?
Types of Normal Forms.
Advantages of Normalization
Disadvantages of Normalization
What is RAID (Redundant Array of Independent Disk)?
Describe RAID technology.

You might also like