1. What is a Cartesian product? What causes it? Expected answer: A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will

What is normalization? Explain different levels of normalization? Check out the article Q100139 from Microsoft knowledge base and of course, there’s much more information available in the net. It’ll

What is JServer and what is it used for? Oracle JServer Option is a Java Virtual Machine (Java VM) which runs within the Oracle database server’s address space. Oracle also provides a JServer Accelera

What is a major difference between SQL Server 6.5 and 7.0 platform wise? SQL Server 6.5 runs only on Windows NT Server. SQL Server 7.0 runs on Windows NT Server, workstation and Windows 95/98. Is SQL

Which of the following statements is true about implicit cursors? Implicit cursors are used for SQL statements that are not named. Developers should use implicit cursors with great care. Implicit curs

Explain the difference between a hot backup and a cold backup and the benefits associated with each. - A hot backup is basically taking a backup of the database while it is still up and running and it

What’s the command to see the current user name? Sql> show user; What’s the command to change the SQL prompt name? SQL> set sqlprompt “database-1 > ” database-1 > database-1 > How

Compare and contrast SQL Server with MySQL.Compare and contrast stored procedures and dynamic SQL.Describe a standard 3-tier architecture and the interfaces between each tier.Compare and contrast a ri

How do you read transaction logs?How do you reset or reseed the IDENTITY column?How do you persist objects, permissions in tempdb?How do you simulate a deadlock for testing purposes?How do you rename

What is source qualifier?Difference between DSS & OLTP?Explain grouped cross tab?Hierarchy of DWH?How many repositories can we create in Informatica?What is surrogate key?What is difference betwee