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”. |
| |
|
| 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.
|
| |
|
| 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. |
| |
|
| 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. |
| |
|
| 95. |
Define transaction? |
| |
A collection of operations that fom a single logical unit of works are called transaction. |
| |
|
Gk Questions with Answers