Infosys Ms SQL DBA Administrator Interview Questions and Answers

A pull request is a method of submitting contributions to a project on GitHub for review and merging.

• Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

• They allow developers to collaborate and discuss changes before merging them into the main branch.

• Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

• Rev...read more

Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.

• Stateful set ensures that each pod in the set has a unique identity and stable network identity.

• Stateful set pods are created in order and are not replaced until they are deleted.

• Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

• Example:...read more

Start up parameters are used to configure the behavior of SQL Server when it starts up.

• Start up parameters are specified in the SQL Server Configuration Manager.

• Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

• Start up parameters can be modified to customize the behavior of SQL Server during startup.

• Example: -dC:\Program Files\Microso...read more

SQL is a programming language used for managing and manipulating relational databases.

• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

• Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE

Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.

• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Procedure is a set of SQL statements stored in the database and executed when called

• Procedures can accept input parameters

SQL architecture refers to the structure and components of a SQL database system.

• SQL architecture includes components like storage engine, query processor, and buffer manager.

• The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

• The buffer manager handles caching and memory management to optimize performance.

• Examples of SQL architectures include MySQL, Oracle, and SQL Se

Use the INSERT INTO statement with multiple value sets separated by commas

• Use the INSERT INTO statement followed by the table name

• List the column names in parentheses after the table name

• Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas

• Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)

Update query using joins in SQL

• Use UPDATE statement with JOIN clause to update data in multiple tables

• Specify the tables to be updated and joined using ON clause

• Set the columns to be updated in SET clause

Query to display the highest salary in a table

• Use the SELECT statement to retrieve data

• Use the MAX() function to find the highest salary

• Specify the column name for salary in the query