Loading, please wait ...
Open its course - Database Systems

Microsoft SQL Server 2008

Example...
View Complete Description
×

Topic Summary

Example of a DBMS
Topic Questions:
19
MCQs T/F FiB SQ
7 7 4 1
Question Type Legends

Easy

Medium

Difficult
Open its course - Database Systems

Multiple Choice Questions for Microsoft SQL Server 2008

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert 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

  • 2 Which of the following changes the structure of the database?
    1. ALTER
    2. DROP
    3. RENAME
    4. SELECT

  • 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

  • 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

  • 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

  • 6 Which of the following DBMS provided by Microsoft?
    1. SQL Server
    2. MySQL
    3. Oracle
    4. R

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert