Sql Interview Question and Answers:
106. 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”.
107. 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.
108. 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.
109. 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.
106. 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”.
107. 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.
108. 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.
109. 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.
So instead of sipping his morning coffee with a heavy heart and feeling paralysed by helpless rage, he chose to make it the subject of his next painting: a composition in monochrome that arrests the moment of the collapse of a city to immortalize it in the collective consciousness of the twentieth century, as a metaphor for the crumbling of the values of civilization and humanity itself.
ReplyDeletekizi free online Games
free online games 2019
a10 games