SQL Server - Crossword - #1

PandianS
Posted by in Sql Server category on for Intermediate level | Points: 250 | Views : 5924 red flag
Rating: 4 out of 5  
 1 vote(s)

SQL Server - Crossword Puzzle - #1

Introduction

The main intension of this article is Playing/Trying game with SQL Server experience - "SQL Server Crossword #1"

Crossword:


 


Questions:

A. Left to Right
      1 _____Is a SET option ON to used to restrict the "Row(s) affected" information
_____Is a Key composed of two of more columns
_____Is a statement used to alters the flow of execution to a label
_____Is the bottom level of nodes in the index.
_____Is a statement which blocks the execution of a batch until a specified time or time interval is reached
10  _____Is a collection of database objects that are owned by a single user.
11  _____Is an unique number assigned to each entry in a transaction log

B. Top to Bottom
_____Is a function returns a null value if the two specified expressions are equal.
_____Is the SET operator allows you to combine the results of two or more SELECT statements into a single result set. And It'll not apply SORT
_____Is a Fixed-length, non-Unicode character data with a length of n bytes.
_____Is a function which returns the first nonnull expression among its arguments
_____Is a statement to prevent the principal from inheriting the permission
12  _____Is a function which returns a numeric value, rounded to the specified length or precision

C. Right to Left
12  _____Is a function which returns a random float value from 0 through 1.

D. Bottom to Top
13  _____Is a default batch seperator(It can be changed)

Answer:

 

Page copy protected against web site content infringement by Copyscape

About the Author

PandianS
Full Name: Pandian Sathappan
Member Level: Silver
Member Status: Member,MVP
Member Since: 5/11/2009 2:24:28 AM
Country: India
Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions
http://sqlserverbuddy.blogspot.com/
Microsoft Certification - MCITP: Microsoft Certified IT Professional - SQL Server 2008 Database Administrator - MCTS: Microsoft Certified Technology Specialist - SQL Server 2005 - MCP: Microsoft Certified Professional - SQL Server 2000

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)