thinkinterview » interview questions » DataBase

DataBase Interview Questions

  showing 1 to 15 of 35 questions   next » |   sort by:   Latest first / Popular first

You are creating a procedure that will update two tables within a...
question-61 You are creating a procedure that will update two tables within a transaction. The code looks similar to the followin... view full question with answer

Posted in: DataBase(35) |

In asp.net 2.0 what is the best way to handle sql connection stat...
question-158 In asp.net 2.0 what is the best way to handle sql connection stat... view full question with answer

Posted in: ASP.NET Controls (2) | ASP.NET 2.0 (2) | .NET Deployment (2) | SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | ADO.NET Basics (15) | ASP.NET MVC (2) | ASP.NET Basics (2) | ASP.NET Architecture (2) | ASP.NET Security (2) | .NET Security (2) | .NET 2.0 (2) | .NET 3.5 (2) | .NET Architecture (2) | .NET Basics (2) | C# (2) | VB.NET (2) | SQL Server security (15) | ASP.NET(45) | .NET(40) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: ASP.NET Controls | ASP.NET 2.0 | .NET Deployment | SQL Server 2005 | SQL | SQL Server Basics | ADO.NET Basics | ASP.NET MVC | ASP.NET Basics | ASP.NET Architecture | ASP.NET Security | .NET Security | .NET 2.0 | .NET 3.5 | .NET Architecture | .NET Basics | C# | VB.NET | SQL Server security |

What is a Linked Server?...
question-164 What is a Linked Serve... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

What is DESCRIBE command in SQL Server 2005? What is its purpose?...
question-149 What is DESCRIBE command in SQL Server 2005? What is its purpose? How to use i... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

What is RDBMS?...
question-150 What is RDBM... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

What is a "trigger" in SQL Server 2005?...
question-152 What is a "trigger" in SQL Server 200... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

Can UNIQUE KEY in SQL Server 2005 have two or more NULL?...
question-151 Can UNIQUE KEY in SQL Server 2005 have two or more NUL... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

You are building a scientific application that will store data in...
question-62 You are building a scientific application that will store data in a SQL Server 2005 database. The application does not store data until a final process is complete. One of the procedures you... view full question with answer

Posted in: DataBase(35) |

How do you optimize stored procedures in SQL Server 2005...
question-155 How do you optimize stored procedures in SQL Server 20... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

What is View in Database (SQL Server 2005, ORACLE)?...
question-153 What is View in Database (SQL Server 2005, ORACLE... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

What is Index?...
question-163 What is Inde... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

You need to add a column to a table that will hold a unique value...
question-60 You need to add a column to a table that will hold a unique value. Which of the following would accommodate the situatio... view full question with answer

Posted in: DataBase(35) |

What are different normalization forms?...
question-162 What are different normalization form... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

Difference between "VARCHAR" and "VARCHAR2" d...
question-154 Difference between "VARCHAR" and "VARCHAR2" datatype... view full question with answer

Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |

You would like to add an additional column to a table. The new co...
question-59 You would like to add an additional column to a table. The new column will be used to hold a seven-character serial number for assets and will be a mandatory element of data in the future. H... view full question with answer

Posted in: DataBase(35) |

Page: [1]   2   3   next »