Database Administration Questions

BIOS in computers stands for Basic Input Output System.

BIOS is a set of computer instructions in firmware which control input and output operations.

Here in this declaration public static void main string[] args, each keyword has its importance.

1. public - Here public is an access specifier which allows the main method to be accessible everywhere.

2. static - static helps the main method to get loaded without getting called by any instance/object.

3. void - void clarifies that the main method will not return any value.

4. main - It's the name of the method.

5. String[] args - Here we are defining a String array to pass arguments at the command line. args is the variable name of the String array.

Computer was invented by Charles Babbage.

The First Mechanical Computer Designed by Charles Babbage, a British mathematician was called as Analytical Engine which resembles today's modern machines  between 1833 and 1871.

This is a very Common Interview Questions in all interview we all face.

Purpose of this question ::

When an interviewer asks you, "Why should we hire you?" she is really asking, "What makes you the best fit for this position?" 

How To Approach the Answer ::

Here you can find the Simple and Best Answer for "Why should we hire you?"

1. Keep It Concise

You want your answer to be brief - no more than a minute or two long.

2. Focus on Your Uniqueness

The interviewer wants to know how you stand out among the other applicants.

Therefore, focus on one or two qualities you possess that are different from what other interviewees might offer, or are more difficult to find in candidates generally.

3. Mention Any Experience You Have ::

The primary focus of your answer should be to match your qualifications, certifications, experience and skills with their job needs. Mention key strengths and give examples that connect with the company and the job requirements.

For Example ::

" I think and believe that my experience and familiarity with the industry and my ability to work autonomously make me best suitable for this position."

Internet is not an operating system.

SQL statements are broadly classified into three. They are

1. DDL – Data Definition Language

DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.

2. DML – Data Manipulation Language

DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.

3. DCL – Data Control Language

DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

Executive plan can be defined as:

* SQL Server caches collected procedure or the plan of query execution and used thereafter by subsequent calls.

* An important feature in relation to performance enhancement.

* Data execution plan can be viewed textually or graphically.