Physical Database Design – General Questions
1. If a denormalization situation exists with a one-to-one binary relationship, which of the following is true? A.…
Data Warehousing – True or False
1. A data mart is designed to optimize the performance for well-defined and predicable uses. A. True B.…
Data Warehousing – General Questions
1. Data scrubbing is which of the following? A. A process to reject data from the data warehouse…
Database Processing for BIS – True or False
1. Business Intelligence (BI) systems do not obtain data from operational databases. A. True B. False 2. Data…
Database Processing for BIS – General Questions
1. A BI reporting system does not ________ . A. create meaningful information B. deliver information to users…
XML and ADO.NET – True or False
1. SOAP uses HTTP as its only transport mechanism. A. True B. False 2. The DTD defines the…
XML and ADO.NET – General Questions
1. The XSLT processor copies the elements of the stylesheet until it finds a command in the format:…
SQL Server 2000 – True or False
1. There is only one way to create and modify tables in SQL Server. Write SQL code using…
SQL Server 2000 – General Questions
1. With which type of SQL Server recovery model are all database changes logged except those that cause…
Managing Multiuser Databases – True or False
1. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when…