Mysql online test, practice interview questions and answers

Which are the authentication modes in SQL Server?

All of the above

Windows mode

Mixed mode

none

One table can have more than one combination of columns that uniquely identify the row in a table each combination is called as?

Composite Key

Candidate Key

Foreign Key

Primary key

What is meant by indexes?

Index stores large number of integer values

None of the above.

Index minimize the data redundancy

Index speed up the data retrieval

Which are the different types of trigger in SQL?

DDL and DCL

DML and DDL

DDL and DUL

DML and DTL

The different types of replication available in SQL server are?

Merge Replication

Transactional Replication

All of the above

Snapshot Replication

Which of the followings are the types of locks in SQL Server?

Exclusive locks

All of the above

Shared locks

What is meant by Primary Key in SQL?

primary is no of rows in table

Primary keys are integer ids in a table rows.

Primary keys are unique names of a table.

Primary keys are unique identifiers for each row in a table.

What does RAID stands for?

Redundant Automatic Individual Durable

Redundant Array of Independent Disks

Redundancy Accelerator Independent Disks

Reduce Array of Independent Disks

Difference between Primary key and Unique key?

Primary key allows one null value whereas unique key doesn’t allow null value.

Primary key doesn’t allow null value whereas unique key allows one null value.

Primary key allows one null value whereas unique key allows multiple null values.

Primary key doesn’t allow null value whereas unique key allows multiple null values

10.

Which is not a valid data type in SQL server in the following answers?

xml

money

blob

nvarchar