Sql Interview Question and Answers

91. What's the maximum size of a row?
  8060 bytes. Don't be surprised with questions like what is the maximum number of columns per table. Check out SQL Server books online for the page titled: “Maximum Capacity Specifications”.
 
Your Name Your Email-ID
Your Answer
92. What is the difference between a local and a global variable?
  A Local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement.
A Global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection are closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when database is opened next time.
 
Your Name Your Email-ID
Your Answer
93. What is a query?
  A query with respect to DBMS relates to user commands that are used to interact with a data base. The query language can be classified into data definition language and data manipulation language.
 
Your Name Your Email-ID
Your Answer
94. What is Relational Algebra?
  It is procedural query language. It consists of a set of operations that take one or two relations as input and produce a new relation.
 
Your Name Your Email-ID
Your Answer
95. Define transaction?
  A collection of operations that fom a single logical unit of works are called transaction.
 
Your Name Your Email-ID
Your Answer