Search
Question: What is the binary equivalent of the decimal number 10?Options: 1010100111001110Correct An..
Question: Which of the following is a feature of ADO.NET?Options: Disconnected data architectureDire..
Question: What is the role of a transaction in a database?Options: To group multiple operationsTo cr..
Question: Which of the following is a common concurrency control mechanism?Options: Two-Phase Lockin..
Question: What is the primary purpose of indexing in a database?Options: To speed up data retrievalT..
Question: In ADO.NET, which class is used to represent a connection to a database?Options: SqlConnec..
Question: Which of the following is a method to load XML data into a DataSet?Options: ReadXmlLoadXml..
Question: What does ADO.NET primarily use to interact with XML data?Options: DataSetDataReaderDataAd..
Question: In the context of concurrency control, what does \'locking\' refer to?Options: Preventing ..
Question: Which of the following is a potential problem that normalization aims to solve?Options: Da..
Question: What is the purpose of a primary key in a relational database?Options: To uniquely identif..
Question: Which normal form is achieved when a relation is in 3NF and every determinant is a candida..
Question: What does the term \'functional dependency\' mean in the context of databases?Options: One..
Question: Which normal form requires that a relation is in 1NF and has no partial dependencies?Optio..
Question: What is the primary purpose of normalization in a relational database?Options: To increase..
Question: What does normalization aim to achieve in database design?Options: Data redundancyData int..
Question: Which architecture is commonly used in a client-server database environment?Options: Two-t..
Question: Which of the following is a disadvantage of normalization?Options: Increased data redundan..
Question: What is the purpose of an index in a database?Options: To store dataTo speed up data retri..
Question: Which of the following is a characteristic of a star schema in data warehousing?Options: H..
Question: Which of the following is NOT a type of database index?Options: Unique indexClustered inde..
Question: What is concurrency control in a database system?Options: Managing simultaneous operations..
Question: What is a transaction in the context of databases?Options: A single operation on the datab..
Question: What is normalization in the context of databases?Options: The process of organizing data ..
Question: Which SQL command is used to retrieve data from a database?Options: INSERTUPDATESELECTDELE..
Question: What is the role of the client in a client-server database architecture?Options: To store ..
Question: Which of the following is NOT a benefit of using a client-server database?Options: Central..
Question: In a client-server database, which component is responsible for processing queries?Options..
Question: What is the primary purpose of a client-server database architecture?Options: To store dat..
Question: What is the purpose of the \'WITH (NOLOCK)\' hint in SQL Server 2000?Options: To lock the ..