Database MCQ - English
- Introduction to Database
- The Relational Model and Normalization
- Data Modeling with ER Model
- SQL for Database Construction
- Managing Multiuser Databases
- SQL Server 2000
- XML and ADO.NET
- Database Processing for BIS
- The Database Development Process
- ER Model and Business Rules
- Physical Database Design
- The Client Server Database
- Data Warehousing
- Distributed Databases
- Object Oriented Database
- Introduction to SQL
- Database Design Using Normalization
- Data Models into Database Designs
- Database Redesign
- Managing Databases with Oracle
- ODBC, OLE DB, ADO, and ASP
- JDBC, Java Server Pages, and MySQL
- The Database Environment
- Modeling Data in the Organization
- Logical Database Design
- Advanced SQL
- The Internet Database Environment
- Data and Database Administration
- Object Oriented Data Modeling
SQL Server 2000 MCQ Questions and Answers
Home | Database | SQL Server 2000In this section we provide lots of objective question of SQL Server 2000 in Database Management System.
1) With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
2) Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
3) What mode of authentication does SQL Server NOT provide?
Answer : D Discuss
4) The strictest transaction isolation level provided by SQL Server is called:
5) SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
6) Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
7) Which of the three possible types of triggers does SQL Server support?
8) Which of the following is a way to create and modify tables using SQL Server?
Answer : C Discuss
9) With which type of SQL Server recovery model, is no logging done?
10) SQL Server 2000 stored procedures can:
Answer : B Discuss