Daily Archives: October 1, 2015

MS SQL Server 2005 Test

1. Which of the following clauses are not allowed in a single row sub-query? Answers: From Where Group by Having Order by 2. What is the function of "DBCC CHECKDB" command? Answers: It checks the allocation of all the objects in the specified database It checks the structural integrity of all the objects in the [...]

By | October 1st, 2015|Upwork Databases|0 Comments

MS Access 2003 Test

1. A query that uses the BETWEEN syntax for two numbers is identical to: Answers: >= and <= > and < >= and < > and <= No such synta 2. How can the duplicate data on a report be hidden? Answers: By Setting the HideDuplicates property to Yes By Setting the DuplicateRecords property to [...]

By | October 1st, 2015|Upwork Databases|0 Comments