Microsoft SQL Server 2008

Open its course - Database Systems

Topic Questions: 19
MCQs	T/F	FiB	SQ
7 6 1	7 1 6	4 0 4	1 1 0

Question Type Legends
	Easy		Medium		Difficult

MCQs T/F FiB Short Qs

Open its course - Database Systems

×
Hidden Questions!

Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. We recommends them to have more than 70+ questions against the topic and make them public.
1 Which of the following DML command insert data into a table?
1. INSERT
2. ADD
3. INSERT DATA
4. NONE
- View Answer
2 Which of the following changes the structure of the database?
1. ALTER
2. DROP
3. RENAME
4. SELECT
- View Answer
3 What is the purpose of [*] in DML SELECT command?
1. All rows of table will be shown
2. All columns of table will be shown
3. Subset of columns will be shown
4. Subset of rows will be shown
- View Answer
4 A database name can start with which of the following option(s)?
1. Letters
2. Difgits
3. Underscore
4. Any non-readable character
5. All of Above
- View Answer
5 Which of the following files types are created by SQL Server for each database?
1. .mdf & .mdb
2. .mdf & .ldf
3. .mdf & .mdd & .ldf
4. Many types
- View Answer
6 Which of the following DBMS provided by Microsoft?
1. SQL Server
2. MySQL
3. Oracle
4. R
- View Answer