Confuse Skull: SQL

§ This is a generic question often asked by many interviewers. Explain what are the different SQL Server Versions you have worked on, what kind of administration of those instances has been done by you. Your role and responsibilities carried out in your earlier projects that would be of significance to the potential employer. This is the answer that lets the interviewer know how suitable are you for the position to which you are being interviewed.

2. What are the different SQL Server Versions you have worked on?

§ The answer would be depending on the versions you have worked on, I would say I have experience working in SQL Server 7, SQL Server 2000, 2005 and 2008. If you have worked only the some version be honest in saying that, remember, no one would be working on all versions, it varies from individual to individual.

3. What are the different types of Indexes available in SQL Server?

§ The simplest answer to this is “Clustered and Non-Clustered Indexes”. There are other types of Indexes what can be mentioned such as Unique, XML, Spatial and Filtered Indexes. More on these Indexes later.

Pages

Search Your Question...!

Structured Query Language(SQL) MCQ's

1. Hbase DDL Operations (create, delete tables) are maintained by

Region Server

2. Pre-join projection is equivalent to ________ as in traditional relational systems.

Materialized view

3. Hbase main server components include all except

Hbase Memstore

4. The column store has to perform _____ IO to insert a new value.

multiple

5. The row store needs to perform _____ IO to insert a new value.

single

NoSQL - Database Revolution MCQ's

1. Hbase main server components include all except _

Hbase Memstore

2. In column-oriented stores, data is stored on a basis.

Column Family

3. In Hbase, 'Columns' are named and specified in table definition.

False

4. HBase Tables are divided _ by row key range into .

horizontally - regions

5. Columnar databases are preferable for OLTP systems.

False

SQL Interview Questions -1