»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Important Sql Interview Questions
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 b
|