Best 100+ SQL Interview Questions and Answers 2020-21 - 2

Question: 6

What is a primary key?

The primary key is the column(s) used to uniquely identify each row of a table.

Question: 7

What is a UNIQUE KEY?

A UNIQUE KEY is one or more columns that must be unique for each row of the table.

Question: 8

What is a ROWID?

ROWID is the logical address of a row, and it is unique within the database.

Question: 9

What’s the data provider name to connect to Access database?

Micorosft.Access

Question: 10

What does the parameter Initial Catalog define inside Connection String?

The database name to connect to.