Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Sql Server 2000(Database ) Questions and Answers
Home
Topic
Database
Sql Server 2000
Question 1.
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery
Explanation:-
Answer: Option D. ->
Bulk-logged recovery
Question 2.
What mode of authentication does SQL Server NOT provide?
Windows-only security
Both SQL Server and Windows-only security
Mixed security
SQL Server only security
Explanation:-
Answer: Option D. ->
SQL Server only security
Question 3.
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
#
%
&
@
Explanation:-
Answer: Option D. ->
@
Question 4.
The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ
SERIALIZABLE
READ COMMITTED
READ UNCOMMITTED
Explanation:-
Answer: Option B. ->
SERIALIZABLE
Question 5.
SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
INSTEAD OF trigger
BEFORE trigger
AFTER trigger
BEGIN trigger
Explanation:-
Answer: Option A. ->
INSTEAD OF trigger
Question 6.
Which of the three possible types of triggers does SQL Server support?
INSTEAD OF only
AFTER only
BEFORE only
INSTEAD OF and AFTER only
Explanation:-
Answer: Option D. ->
INSTEAD OF and AFTER only
Question 7.
Which of the following is a way to create and modify tables using SQL Server?
Write SQL code using either CREATE or ALTER SQL statements only
Use the graphical facilities of SQL Server Enterprise Manager only
Both of the two methods above will work
Neither of the two methods above will work
Explanation:-
Answer: Option C. ->
Both of the two methods above will work
Question 8.
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
READCOMMITTED
Explanation:-
Answer: Option D. ->
READCOMMITTED
Question 9.
With which type of SQL Server recovery model, is no logging done?
Differential recovery
Full recovery
Bulk-logged recovery
Simple recovery
Explanation:-
Answer: Option D. ->
Simple recovery
Question 10.
SQL Server 2000 stored procedures can:
never be kept within the database
be kept within the database and invoked by application programs
be stored on the users' computer
support BEFORE, INSTEAD OF and AFTER types
Explanation:-
Answer: Option B. ->
be kept within the database and invoked by application programs
1
2
3
4
Next →
One click Login
Login With Google
Old way of Login
Login With Email