Sql Server Interview Questions and Answers (1758) - Page 64

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

1758 records found.

Post |

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

What is the Sql syntax for sorting, and which is the default order?

The default Sorting Order is Ascending.Below Two statements are identical:-

select * from table order by id;

select * from table order by id asc;

For descending order,simply replace asc with desc.

______ stores metadata about the structure of the data base? + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

______ responsible to define the content, the structure, the constraints, and functions or transactions against the database + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

Conceptual data modeling uses a high level data modeling concept of E-R Models? + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time? + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

In the DBMS approach, application programs perform the -----

NOTE: This is objective type question, Please click question title for correct answer.

Each program maintains its own set of data. So users of one program may be unaware of potentially useful data held by other programs this leads to Duplication of data? + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is a problem of file management system? + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

______ level describes what data is stored in the database and the relationships among the data? + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

The language used application programs to request data from the DBMS is referred to as the ..... + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

A _____ is an association between entities. + DBMS

NOTE: This is objective type question, Please click question title for correct answer.

The problem that is compounded when constraints involve several data items from different files are Called ______ ?

NOTE: This is objective type question, Please click question title for correct answer.

Which is the make given to the database management system which is able to handle full text data, image data, audio and video?

NOTE: This is objective type question, Please click question title for correct answer.

Database management systems are intended to?

NOTE: This is objective type question, Please click question title for correct answer.

If a piece of data is stored in two places in the database, then,

NOTE: This is objective type question, Please click question title for correct answer.

A traditional database stores just data – with no procedures

NOTE: This is objective type question, Please click question title for correct answer.

Foreign Key can be null

NOTE: This is objective type question, Please click question title for correct answer.

Choose the incorrect option about the Sql Server Indexes?

NOTE: This is objective type question, Please click question title for correct answer.

What's the feature of an Identity columns?

There are various features of an Identity columns some are listed below:-

1. An identity column is an auto incrementing column.
2. An identity column is typically used as a primary key.
3. An identity column must be NOT NULL.
4. If you want to insert a specific value into the identity column you have to use the IDENTITY_INSERT setting.
5. If you truncate a table Identity resets the seed.
6. The data type of an identity column is typically an INT but can be most numeric data types. ie tinyint,smallint,int, bigint,decimal,or numeric.
7. A primary key that’s an identity column is usually a surrogate key.
8. A surrogate key is one that is not related to the contents of the row in any way.