DBMS-Microsoft SQL Server Questions and Answers
The SQL Server questions with answers topic focuses on essential database management concepts, including queries, joins, stored procedures, and triggers. It provides programming questions and answers that help aspirants prepare for technical interviews and placement exams at leading IT firms like TCS, Infosys, and Accenture. Practicing SQL programming interview questions with answers enhances your ability to manage and optimize relational databases, ensuring success in both coding assessments and real-world development scenarios.
DBMS-Microsoft SQL Server
Showing 10 of
49 questions
1. Microsoft SQL Server is a multithreaded server that scales from laptops and desktops to enterprise servers.
- TRUE
- FALSE
2. Microsoft SQL Server can operate on clusters and symmetrical multiprocessing (SMP) CONFIGURATIONS.
- TRUE
- FALSE
3. 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.
- TRUE
- FALSE
5. Microsoft SQL Server is
- Relational DBMS.
- Hierachical DBMS
- Networking DBMS.
- None of these
7. Microsoft SQL Server was originally developed at Sybase for
- Windows NT system
- UNIX system
- Both (a) and (b)
- None of these
8. Microsoft SQL Server can operate on
- clusters
- symmetrical multiprocessing.
- personal digital assistnt.
- All of these
9. Service Manager of Microsot SQL Server 2000 is used to control.
- the main SQL Server process.
- Microsoft Distributed Transaction Coordinator.
- SQL Server Agent process
- All of these
10. Which SQL statement is used to retrieve data from a database?
- GET
- SELECT
- OPEN
- EXTRACT