My Puzzles
Report bug
Collected Puzzles
User listed puzzles
Random Puzzle
Log In/Out

SQL Server

Rajesh Kumar Yadav

Crossword based on SQL Server concepts

1 2           3  
4   5  
  6     7       8
9         10            
      11   12    
15           16    
18             19                      
  20 21                       22
    25   26

2.A calculated value that is used to test data for the presence of errors that can occur when data is transmitted or when it is written to disk.
7.in this normal form,No duplicate information is permitted
9.A table stored permanently in a database. (2 Words)
13.'A' in ACID
14.Executes the specified pass-through query on the specified linked server.
15.This object can store pictures, audio, video, or other BLOBs (Binary Large OBjects)
17.The complex process of copying and cleaning data from heterogeneous sources.
18.The ___ command in SQL marks the finalization of a database transaction
19.An index in which the logical order of the index key values is different than the physical order of the corresponding rows in a table.
21.An option that causes SQL Server to close the current file and create a new file when the maximum file size is reached. (2 Words)
23.The language containing the commands used to administer instances of SQL Server, create and manage all objects in an instance of SQL Server, and to insert, retrieve, modify and delete all data in SQL Server tables.
27.This sp places a lock on an application resource
29.the process of organizing data to minimize redundancy and remove ambiguity
30.A set of SQL statements submitted together and run as a group
31.A service that provides a simple way for a smart device application to access (pull) and send (push) data to and from a remote SQL Server database table and a local SQL Server Mobile Edition database table.
1.The ____ JOIN keyword returns all the rows from the left table and all the rows from the right table.
3.A hidden 4-byte column that the SQL Server Database Engine automatically adds to a row to make the index key for that row unique. It is added to a row only when the clustered index on the table is not created with the UNIQUE property and the values in the index key for that row do not provide uniqueness.
4.Type of file consisting of records of a single record type, in which there is no embedded structure information governing relationships between records. (2 Words)
5.Returns the error number for the last Transact-SQL statement executed.
6.If you want to sort the records in a descending order, we can use the ___ keyword
8.Reads that contain uncommitted data. (2 Words)
10.sum(), max(),min(), etc are called _____ functions
11.A data mining technique that analyzes data to group records together according to their location within the multidimensional attribute space.
12.____ is used by Database management systems to facilitate concurrency control
16.A data structure used by one party to prove that another party knows a secret key.
18.a database object pointing to a currently selected set of records
20.The maximum number of table sources that we can have in a single SELECT query in SQL server 2008
22.The subset of SQL statements that define all attributes and properties of a database and its objects.
23.the command used for deleting only the data inside a table, not the table itself
24.Because the WHERE keyword could not be used with aggregate functions, ___ clause was added.
25.A join in which the values in the columns being joined are compared for equality, and all columns are included in the results.
26.A program that installs or runs other programs.
28.The ORDER BY keyword sort the records in ascending order by default(true/false)

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!

Web armoredpenguin.com

Copyright information Privacy information Contact us Blog