What are the steps you will take to improve performance of a poor performing query?

HCL,

What are the steps you will take, if you are tasked with securing an SQL Server?

HCL,

What is blocking and how would you troubleshoot it?

HCL,

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

HCL,

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

HCL,

What are statistics, under what circumstances they go out of date, how do you update them?

HCL,

What are the different ways of moving data/databases between servers and databases in SQL Server?

HCL,

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

HCL,

What is database replicaion? What are the different types of replication you can set up in SQL Server?

Aptech, HCL, Perpetual, SAIC,

How to determine the service pack currently installed on SQL Server?

HCL,

Describe the vertebrate brain and name its major areas.

Discuss the major features of at least two very different nervous systems (i.e. jellyfish, locust, lamprey, octopus, owl, rat, monkey). In what ways might the features of each system affect neural processing?

Describe the main pathways between sensory receptors and cortex (including intra-cortical circuits) for mammalian vision, hearing and olfaction.

What do you know about high-frequency oscillations (20-50 Hz) in invertebrates or vertebrates? What causes them?

In mammals, somatosensory, visual, auditory, and olfactory sensory systems all project to the cerebral cortex. To what extent does this imply some common form of neural processing?