DBMS-Microsoft SQL Server Questions and Answers

Practice Mode
Showing 10 of 49 questions
Q1
Microsoft SQL Server is a multithreaded server that scales from laptops and desktops to enterprise servers.
  • A TRUE
  • B FALSE
Answer: Option A
Q2
Microsoft SQL Server can operate on clusters and symmetrical multiprocessing (SMP) CONFIGURATIONS.
  • A TRUE
  • B FALSE
Answer: Option A
Q3
Data Transamission Services (DTS) provide an extremely flexible method for improting and exporting data between a Microsoft SQL Server installation and a large variety of other formats.
  • A TRUE
  • B FALSE
Answer: Option A
Q4
SQL Server does not provide any graphical tools
  • A TRUE
  • B FALSE
Answer: Option B
Q5
Microsoft SQL Server is
  • A Relational DBMS.
  • B Hierachical DBMS
  • C Networking DBMS.
  • D None of these
Answer: Option A
Q6
Microsoft SQL Server was developed in
  • A 1980
  • B 1990
  • C 2000
  • D None of these
Answer: Option B
Q7
Microsoft SQL Server was originally developed at Sybase for
  • A Windows NT system
  • B UNIX system
  • C Both (a) and (b)
  • D None of these
Answer: Option B
Q8
Microsoft SQL Server can operate on
  • A clusters
  • B symmetrical multiprocessing.
  • C personal digital assistnt.
  • D All of these
Answer: Option D
Q9
Service Manager of Microsot SQL Server 2000 is used to control.
  • A the main SQL Server process.
  • B Microsoft Distributed Transaction Coordinator.
  • C SQL Server Agent process
  • D All of these
Answer: Option D
Q10
Which SQL statement is used to retrieve data from a database?
  • A GET
  • B SELECT
  • C OPEN
  • D EXTRACT
Answer: Option B
Explanation: SELECT statement is used to query and retrieve data from database tables.

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test