[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

Technical Interview Questions and Answers :: DBMS

    121 / 143

    What is the difference b/w OS and database?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    122 / 143

    Define View and write syntax of view?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    123 / 143

    Explain Normalization and Normal forms with tables.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    124 / 143

    What is tablespace?
    Answer:

    A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data and serves to allocate storage for all DBMS managed segments.

    Please Login First :

    125 / 143

    What is the use of Sysaux tablespace in Oracle?
    Answer:

    The SYSAUX tablespace is a new tablespace that is required in Oracle Database 10g. SYSAUX is a secondary tablespace for storage of a number of database components that were previously stored in the SYSTEM tablespace. It is created as a locally managed tablespace using automatic segment space management.

    Please Login First :

    126 / 143

    What is the use of system tablespace?
    Answer:

    SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata comprises the data dictionary. Every Oracle database has to have a SYSTEM tablespace—it is the first tablespace created when a database is created.

    Please Login First :

    127 / 143

    Why do we need tablespace in Oracle?
    Answer:

    An Oracle database is comprised of one or more logical storage units called tablespaces. The database's data is collectively stored in the database's tablespaces. Each tablespace in an Oracle database is comprised of one or more operating system files called datafiles.

    Please Login First :

    128 / 143

    What is data buffer cache?
    Answer:

    Database buffer cache is typically the largest portion of the SGA. It has data that comes from the files on disk. Because accessing data from disk is slower than from memory, the database buffer cache's sole purpose is to cache the data in memory for quicker access.

    Please Login First :

    129 / 143

    What is Redolog buffer? What exactly it stores?
    Answer:

    A log buffer is a circular buffer in the SGA that holds information about changes made to the database. This information is stored in the redo entries. Redo entries contain the information necessary to reconstruct or redo changes made to the database by insert, update, delete, create, alter, or drop operations. Redo entries are primarily used for database recovery as necessary.

    The server processes generate redo data into the log buffer as they make changes to the data blocks in the buffer. LGWR subsequently writes entries from the redo log buffer to the online redo log.

    The redo log buffer is a RAM area (defined by the initialization parameter log_buffer) that works to save changes to data, in case something fails and Oracle has to put it back into its original state (a ?rollback?). When Oracle SQL updates a table (a process called Data Manipulation Language, or DML), redo images are created and stored in the redo log buffer. Since RAM is faster than disk, this makes the storage of redo very fast.

    Please Login First :

    130 / 143

    What is the use of alert & Control files?
    Answer:

    No Discussion on this question yet!

    Please Login First :


Database Management System(DBMS) is an important subject for Freshers and Experienced candidates, Who are looking to grab a job as a Database Developer or Administrator. Practice the frequently Asked DBMS Technical Interview Questions and Answers - Q4Interveiw.com asked at Freshers and Experienced level. Most of the listed questions here have been previously asked during the technical rounds in IT companies. You can test your SQL database knowledge by solving these questions and compare your chances of getting the job with a top IT company.

Go through the basics of Database Management System before the interview process. Here, listed DBMS interview questions are Frequently asked during an Interview with different companies like Wipro, Accenture, TCS, Oracle, CTS, Adobe, TechM.

You can Filter the question set by the company name easily. If you are not sure about a specific answer, you can easily click and read the answer along with the explanation. So, check these SQL Technical Interview Questions and Answers to prepare for your dream job.