Q. In SQL Server 2000, which command is used to create a new database?
-
A.
CREATE DATABASE
-
B.
NEW DATABASE
-
C.
ADD DATABASE
-
D.
MAKE DATABASE
Solution
The command to create a new database in SQL Server 2000 is 'CREATE DATABASE'.
Correct Answer:
A
— CREATE DATABASE
Learn More →
Q. What does the acronym ACID stand for in the context of transactions?
-
A.
Atomicity, Consistency, Isolation, Durability
-
B.
Atomicity, Concurrency, Isolation, Durability
-
C.
Atomicity, Consistency, Integrity, Durability
-
D.
Atomicity, Consistency, Isolation, Data
Solution
ACID stands for Atomicity, Consistency, Isolation, and Durability, which are the properties of database transactions.
Correct Answer:
A
— Atomicity, Consistency, Isolation, Durability
Learn More →
Q. What does the acronym ER stand for in database modeling?
-
A.
Entity Relationship
-
B.
Entity Relation
-
C.
Entity Record
-
D.
Entity Reference
Solution
ER stands for Entity Relationship in database modeling.
Correct Answer:
A
— Entity Relationship
Learn More →
Q. What is the default isolation level in SQL Server 2000?
-
A.
Read Uncommitted
-
B.
Read Committed
-
C.
Repeatable Read
-
D.
Serializable
Solution
The default isolation level in SQL Server 2000 is Read Committed, which prevents dirty reads.
Correct Answer:
B
— Read Committed
Learn More →
Q. What is the maximum number of columns allowed in a SQL Server 2000 table?
-
A.
128
-
B.
256
-
C.
512
-
D.
1024
Solution
SQL Server 2000 allows a maximum of 1024 columns in a table.
Correct Answer:
B
— 256
Learn More →
Q. What is the maximum size of a SQL Server 2000 database?
-
A.
2 GB
-
B.
4 GB
-
C.
10 GB
-
D.
32 GB
Solution
The maximum size of a SQL Server 2000 database is 32 GB.
Correct Answer:
D
— 32 GB
Learn More →
Q. What is the primary purpose of a foreign key in a database?
-
A.
To uniquely identify a record
-
B.
To create a relationship between tables
-
C.
To enforce data types
-
D.
To index a table
Solution
The primary purpose of a foreign key is to create a relationship between tables.
Correct Answer:
B
— To create a relationship between tables
Learn More →
Q. What is the purpose of an index in SQL Server 2000?
-
A.
To enforce data integrity
-
B.
To speed up data retrieval
-
C.
To store data
-
D.
To create relationships
Solution
An index is used to speed up data retrieval in SQL Server 2000.
Correct Answer:
B
— To speed up data retrieval
Learn More →
Q. What is the purpose of the 'WITH (NOLOCK)' hint in SQL Server 2000?
-
A.
To lock the table
-
B.
To prevent deadlocks
-
C.
To allow dirty reads
-
D.
To optimize performance
Solution
'WITH (NOLOCK)' allows dirty reads by not placing shared locks on the data.
Correct Answer:
C
— To allow dirty reads
Learn More →
Q. Which isolation level in SQL Server 2000 allows dirty reads?
-
A.
Read Uncommitted
-
B.
Read Committed
-
C.
Repeatable Read
-
D.
Serializable
Solution
The Read Uncommitted isolation level allows dirty reads in SQL Server 2000.
Correct Answer:
A
— Read Uncommitted
Learn More →
Q. Which normalization form eliminates transitive dependencies?
-
A.
First Normal Form
-
B.
Second Normal Form
-
C.
Third Normal Form
-
D.
Boyce-Codd Normal Form
Solution
Third Normal Form (3NF) eliminates transitive dependencies.
Correct Answer:
C
— Third Normal Form
Learn More →
Q. Which of the following is a characteristic of a primary key in SQL Server 2000?
-
A.
It can contain NULL values
-
B.
It must be unique
-
C.
It can be duplicated
-
D.
It can be a composite key only
Solution
A primary key must be unique and cannot contain NULL values in SQL Server 2000.
Correct Answer:
B
— It must be unique
Learn More →
Q. Which of the following is a valid data type in SQL Server 2000?
-
A.
VARCHAR
-
B.
STRING
-
C.
TEXT
-
D.
CHARACTER
Solution
VARCHAR is a valid data type in SQL Server 2000, used for variable-length strings.
Correct Answer:
A
— VARCHAR
Learn More →
Q. Which of the following is a valid transaction control command in SQL Server 2000?
-
A.
BEGIN TRANSACTION
-
B.
START TRANSACTION
-
C.
COMMIT WORK
-
D.
ROLLBACK WORK
Solution
The valid transaction control command in SQL Server 2000 is 'BEGIN TRANSACTION'.
Correct Answer:
A
— BEGIN TRANSACTION
Learn More →
Q. Which of the following is NOT a type of join in SQL Server 2000?
-
A.
INNER JOIN
-
B.
OUTER JOIN
-
C.
CROSS JOIN
-
D.
LINK JOIN
Solution
LINK JOIN is not a type of join in SQL Server 2000.
Correct Answer:
D
— LINK JOIN
Learn More →
Q. Which of the following is NOT a valid normalization form?
-
A.
First Normal Form (1NF)
-
B.
Second Normal Form (2NF)
-
C.
Third Normal Form (3NF)
-
D.
Fourth Normal Form (4NF)
Solution
All listed forms are valid normalization forms; however, 4NF is less commonly discussed than the first three.
Correct Answer:
D
— Fourth Normal Form (4NF)
Learn More →
Q. Which SQL Server 2000 feature allows for the management of concurrent transactions?
-
A.
Locking
-
B.
Indexing
-
C.
Partitioning
-
D.
Replication
Solution
Locking is the feature in SQL Server 2000 that manages concurrent transactions to ensure data integrity.
Correct Answer:
A
— Locking
Learn More →
Showing 1 to 17 of 17 (1 Pages)
