SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Crossword #1

By Kenneth Fisher,

Enjoy our first crossword puzzle and see if you can solve all the clues. The key will be posted tomorrow.

Across

2. Column1 + Column2 is a ______ column.

5. Determines which set of characters is being used in a non-unicode column.

8. Only one of each value is allowed.

9. A query within a query

10. Parent element

11. Switch to the secondary automatically when the primary fails.

12. The index can go up (asc) or down (desc)

14. Change the database immediately by rolling back all open transactions.

16. A transaction is kept separate from all other transactions until it's completed.

Down

1. Last option to fix database corruption

3. GO

4. Indexes that uses more than one column.

6. End a transaction successfully.

7. Once a transaction is complete the changes are permanent.

13. 1 or 0

15. Alternate name

The answer key is in this PDF.

 

Resources:

SSC Crossword 2017-07-09 Answer Key.pdf
Total article views: 238 | Views in the last 30 days: 4
 
Related Articles
FORUM

Transaction block and Identity column

The scope of identity column value in a transaction block.

FORUM

transactional replication

transactional replication

FORUM

transaction log

transaction log

FORUM

Begin transaction ........... commit transaction

Begin transaction ........... commit transaction

BLOG

Transaction Rollbacks with Identity Values

Have you ever noticed unexpected gaps in sequences in IDENTITY columns?  Even though you’ve got tran...

Tags
editorial    
puzzle    
 
Contribute