Technical Interview Questions and Answers :: SQL
41 / 108
The PRIMARY KEY is the column(s) used to uniquely identify each row of a table.
42 / 108
A FOREIGN KEY is one or more columns whose values are based on the PRIMARY or CANDITATE KEY values from the database.
43 / 108
A UNIQUE KEY is one or more columns that must be unique for each row of the table.
44 / 108
The UNIQUE KEY column restricts entry of duplicate values but entry of NULL value is allowed. In case of PRIMARY KEY columns entry of duplicate as well as
45 / 108
A View is a database object that is a logical representation of a table. It is derived from a table but has no storage space of its own and often may be used in the same manner as a table.
46 / 108
ROWID is the logical address of a row, and it is unique within the database.
47 / 108
INDEX is a general term for an SQL feature used primarily to speed up execution and impose UNIQUENESS upon data. You can use an index to gain fast access to specific information in a database table. An index is a structure that orders the values of one or more columns in a database table. The index provides pointers to the data values stored in specified columns of the table, and then orders those pointers according to the sort order you specify.
48 / 108
'Count': Counts the number of non-null values. 'Count (*)': Counts the number of rows in the table, including null values and duplicates.
49 / 108
Master, Model, msdb, Northwind, Pubs, tempdb.
50 / 108
No Discussion on this question yet!