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

RDBMS 1-5

KOSTAS LEFTHERIOTIS

THIS PUZZLE CHECKS YOYR KNOWLEDGE IN CHAPETRS 1-5. IF THERE ARE TWO WORDS, WRITE THEM WITH NO SPACES BETWEEN THEM.

1
2 3          
4       5    
     
    6 7 8
9 10                    
            11 12
               
    13                      
             
          14          
         
    15    
16           17       18    
      19                
  20 21                
      22   23      
      24   25      
        26            
27              
  28                
29          

Across
3.IT RESTRICTS THE VALUES OF GROUPS (SQL)
4.NUMBER OF ATTRIBUTES
9.A RELATIONAL ALGEBRA OPERATION WHERE TUPLES THAT ARE IN RELATION R BUT NOT IN RELATION S
13.A RELATIONAL ALGEBRA OPERATION WHERE ALL TUPLES THAT ARE COMMON IN BOTH RELATIONS
14.THE INTEGRITY THAT DOESN'T ALLOW AN ATTRIBUTRE OF A PRIMARY KEY TO BE NULL
16.A COLLECTION OF LOGICALLY RELATED DATA
19.NOT SELECTED AS A PRIMARY KEY
21.USED TO CHANGE THE VALUE IN AN ATTRIBUTE (SQL)
22.USED IN A MEMBERSHIP SEARCH CONDITION(SQL)
23.A DERIVED RELATION
24.A VALUE THAT IS UNKNOWN OR NOT APPLICABLE
26.NOTE THE FOLLOWING EXPRESSION (SELECT A, SUM(B) FROM TABLE1), WHICH CLAUSE MUST WE USE
27.AGGREGATE FUNCTION TO FIND THE TOTAL NUMBER OF VALUES OF AN ATTRIBUTE
28.USED INSTEAD OF A JOIN
29.USED TO FIND WHETHER A VALUE IS NULL
Down
1.NUMBER OF TUPLES
2.THE LANGUAGE TO DESCRIBE THE DATA
5.ADDITIONAL RULES SPECIFIED BY THE USER
6.USED TO ERASE DATA (SQL)
7.USED FOR SORTING RESULTS (SQL)
8.IT RESTRICTS THE VALUES IN ROWS(SQL)
10.USED TO ENTER A NEW TUPLE IN A TABLE(SQL)
11.USED IN A RANGE SEARCH CONDITION (SQL)
12.A SUPERKEY WITH NO PROPER SUBSET
15.THE LANGUAGE TO CHANGE/MANIPULATE THE DATA
16.IT ELIMINATES DUPLICATES
17.ATTRIBUTES THAT UNIQUELY IDENTIFY TUPLE IN A RELATION
18.A RELATIONAL ALGEBRA OPERATION WHERE IT CONTAINS THE TUPLES OF R THAT PARTICIPATE IN THE JOIN OF R WITH S
20.A RELATIONAL ALGEBRA OPERATION WHERE ALL TUPLES FROM BOTH RELATIONS DUPLICATES ELIMINATED
25.USED IN PATTERN MATCH SEARCH CONDITION(SQL)

The look has changed! Some of the puzzles that people list for the public get indexed by the search engines (like Google). Some people find those puzzles and cannot figure out how to make a puzzle of their own. So this page now has the navigation sidebar.

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!




Google
 
Web armoredpenguin.com

Copyright information Privacy information Contact us Blog