Search
Question: Which of the following is NOT a type of join in SQL Server 2000?Options: INNER JOINOUTER J..
Question: What is the maximum size of a SQL Server 2000 database?Options: 2 GB4 GB10 GB32 GBCorrect ..
Question: Which isolation level in SQL Server 2000 allows dirty reads?Options: Read UncommittedRead ..
Question: What does the acronym ER stand for in database modeling?Options: Entity RelationshipEntity..
Question: Which of the following is a valid transaction control command in SQL Server 2000?Options: ..
Question: What is the purpose of an index in SQL Server 2000?Options: To enforce data integrityTo sp..
Question: In SQL Server 2000, which command is used to create a new database?Options: CREATE DATABAS..
Question: Which normalization form eliminates transitive dependencies?Options: First Normal FormSeco..
Question: What is the maximum number of columns allowed in a SQL Server 2000 table?Options: 12825651..
Question: What does the ACID property in transactions stand for?Options: Atomicity, Consistency, Iso..
Question: Which of the following is NOT a type of index in SQL?Options: Unique indexComposite indexF..
Question: Which of the following is a type of JOIN in SQL?Options: INNER JOINOUTER JOINCROSS JOINAll..
Question: What is the main advantage of using a clustered index?Options: It allows for faster update..
Question: In the context of DBMS architecture, what does the term \'data independence\' mean?Options..
Question: Which of the following is a characteristic of a star schema in database design?Options: Hi..
Question: Which of the following is NOT a property of transactions in a database?Options: AtomicityC..
Question: Which of the following is a feature of ASP.NET compared to classic ASP?Options: Supports s..
Question: What is the main function of a DBMS architecture?Options: To provide a user interface for ..
Question: In the context of ASP, what does the term \'server-side scripting\' refer to?Options: Code..
Question: What is ADO primarily used for?Options: Data access in web applicationsDatabase designData..
Question: Which of the following is a primary purpose of OLE DB?Options: To provide a uniform interf..
Question: What does ODBC stand for?Options: Open Database ConnectivityOpen Data Base ConnectionObjec..
Question: In the context of Object-Oriented Databases, what is \'encapsulation\'?Options: Hiding the..
Question: What does \'polymorphism\' in Object-Oriented Databases refer to?Options: The ability to p..
Question: Which of the following is a benefit of using Object-Oriented Databases?Options: Easier dat..
Question: What is a common method for ensuring data consistency in Object-Oriented Databases during ..
Question: Which of the following best describes an Object-Relational Database?Options: A database th..
Question: What is the primary purpose of indexing in Object-Oriented Databases?Options: To enforce d..
Question: In Object-Oriented Databases, what does \'inheritance\' allow?Options: Creating new classe..
Question: Which of the following is NOT a characteristic of Object-Oriented Databases?Options: Encap..