Infisys Database Administrator DBA Interview Questions and Answers

A structured collection of data that is organized and managed to provide access and efficient retrieval of information.

• A database is a collection of related data that is organized in a specific way.

• It is designed to store, retrieve, and manage data efficiently.

• It can be used to store any type of data, such as text, images, videos, and more.

• Examples of databases include MySQL, Oracle, SQL Server, and MongoDB.

RDBMS stands for Relational Database Management System.

• It is a type of database management system that stores data in tables with relationships between them.

• It uses SQL (Structured Query Language) to manage and manipulate data.

• Examples include Oracle, MySQL, Microsoft SQL Server, and PostgreSQL.

To install SQL Server on a laptop, download the installation file from Microsoft's website and follow the installation wizard.

• Download the SQL Server installation file from Microsoft's website

• Run the installation file and follow the installation wizard

• Choose the appropriate installation options, such as the edition and features

• Set up the necessary authentication and security settings

• Complete the installation process an

Joints are used to combine data from multiple tables in a database. There are different types of joints such as inner, outer, left, and right.

• Inner join returns only the matching rows from both tables

• Outer join returns all the rows from both tables and null values for non-matching rows

• Left join returns all the rows from the left table and matching rows from the right table

• Right join returns all the rows from the right

My typing speed is around 70 words per minute.

• My typing speed is measured at around 70 words per minute.

• I have experience typing for extended periods of time without fatigue.

• I am comfortable using a variety of keyboard layouts and typing software.

• I prioritize accuracy over speed when typing important documents.

• I am always looking for ways to improve my typing speed and efficiency.

Different types of explain plans include basic, serial, parallel, and statement-level.

• Basic explain plan shows the execution plan of a SQL statement

• Serial explain plan shows the execution plan for a serial query

• Parallel explain plan shows the execution plan for a parallel query

• Statement-level explain plan shows the execution plan for each SQL statement in a PL/SQL block

MVCC stands for Multi-Version Concurrency Control, a technique used in database management systems to allow multiple transactions to access the same data simultaneously.

• MVCC is used to maintain data consistency and prevent conflicts between transactions.

• It works by creating multiple versions of a data item, each with a timestamp indicating when it was created.

• When a transaction reads a data item, it sees the version wi...read more