Prizes & Awards
My Profile
Active Members
TodayLast 7 Days
more...
|
 New Feature: Community Sites:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
|
Important Sql Interview Questions
Posted Date: 05 Jul 2007 Resource Type: Articles Category: Databases
|
Posted By: ChandraShekar Thota Member Level: Diamond
Rating:  Points: 10
|
Database related interview questions
Here we see database related interview questions which are very very imp for a person who attent a microsoft related interview
What is sql
SQL is a standard computer language for accessing and manipulating database systems.
SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, and other database systems.
What is ado
ADO is a programming interface to access data in a database from a web site.
ADO uses SQL to query data in a database.
Can you be precise about sql and What can u do with sql
· SQL stands for Structured Query Language
· SQL allows you to access a database
· SQL is an ANSI standard computer language
· SQL can execute queries against a database
· SQL can retrieve data from a database
· SQL can insert new records in a database
· SQL can delete records from a database
· SQL can update records in a database
Do u know any commands in sql if so tell about them
· SELECT - extracts data from a database table
· UPDATE - updates data in a database table
· DELETE - deletes data from a database table
· INSERT INTO - inserts new data into a database table
Tell some thing about ddl
The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables.
Tell some basic ddl statements
· CREATE TABLE - creates a new database table
· ALTER TABLE - alters (changes) a database table
· DROP TABLE - deletes a database table
· CREATE INDEX - creates an index (search key)
· DROP INDEX - deletes an index
What do u know about result set
The result from a SQL query is stored in a result-set
Where we use distinct statement
The DISTINCT keyword is used to return only distinct (different) values.
Tell some thing about aliases
With SQL, aliases can be used for column names and table names
Tell syntaxes for column name aliases and table name aliases
SELECT column AS column_alias FROM table
SELECT column FROM table AS table_alias
What do u know about primary key
A primary key is a column with a unique value for each row. Each primary key value must be unique within the table. The purpose is to bind data together, across tables, without repeating all of the data in every table.
Where exactly u use joins?
we can select data from two tables with the JOIN keyword
what does inner join do?
The INNER JOIN returns all rows from both tables where there is a match.
Do u know any thing about union?
The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type.
What is union all command
The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.
Tell some thing about drop index
You can delete an existing index in a table with the DROP INDEX statement.
What does truncate do?
deletes only the data inside the table
what does alter table do?
The ALTER TABLE statement is used to add or drop columns in an existing table.
How do we use fuctions in sql
SELECT function(column) FROM table
Write syntax for group by
SELECT column,SUM(column) FROM table GROUP BY column
What do u know about view
In SQL, a VIEW is a virtual table based on the result-set of a SELECT statement.
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from a single table.
Tell me what u know about dbms
A Database Management System (DBMS) is a computer program that can access data in a database.
The DBMS program enables you to extract, modify, or store information in a database.
Different DBMS programs provides different functions for querying data, reporting data, and modifying data.
Tell me what u know about Rdbms
A Relational Database Management System (RDBMS) is a Database Management System (DBMS) where the database is organized and accessed according to the relationships between data.
RDBMS is the basis for SQL, and for all modern database systems like Oracle, SQL Server, IBM DB2, Sybase, MySQL, and Microsoft Access.
database related interview questions are very very imp for a person who attent a microsoft related interview
|
Responses
|
| Author: Chandrasekhar. Anumakonda 06 Jul 2007 | Member Level: Gold Points : 0 | Single line answers are not sufficient to qualify in interviews. There are basic questions you can find in examinations. And the interview patterns may change from time to time according to the requiremts and qualification and experience of the candidate.
| | Author: ChandraShekar Thota 29 Nov 2007 | Member Level: Diamond Points : 0 | these are given here for beginners for their confidence building only
| | Author: http://venkattechnicalblog.blogspot.com/ 27 Sep 2008 | Member Level: Diamond Points : 1 | ck this URL for more interview questions,
http://venkattechnicalblog.blogspot.com/2008/09/sql-server-interview-questions_27.html
Regards,
Venkatesan Prabu .J
|
|