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.

UNION THE INTEGRITY THAT DOESN'T ALLOW AN ATTRIBUTRE OF A PRIMARY KEY TO BE NULL
UPDATE A RELATIONAL ALGEBRA OPERATION WHERE ALL TUPLES THAT ARE COMMON IN BOTH RELATIONS
COUNT AGGREGATE FUNCTION TO FIND THE TOTAL NUMBER OF VALUES OF AN ATTRIBUTE
DISTINCT A SUPERKEY WITH NO PROPER SUBSET
DELETEFROM USED TO ENTER A NEW TUPLE IN A TABLE(SQL)
ISNULL A VALUE THAT IS UNKNOWN OR NOT APPLICABLE
ORDERBY THE LANGUAGE TO CHANGE/MANIPULATE THE DATA
HAVING A DERIVED RELATION
SYBQUERY USED FOR SORTING RESULTS (SQL)
ENTERPRISE NOTE THE FOLLOWING EXPRESSION (SELECT A, SUM(B) FROM TABLE1), WHICH CLAUSE MUST WE USE
VIEW IT ELIMINATES DUPLICATES
DATABASE USED TO FIND WHETHER A VALUE IS NULL
SUPERKEY ATTRIBUTES THAT UNIQUELY IDENTIFY TUPLE IN A RELATION
DDL USED IN A MEMBERSHIP SEARCH CONDITION(SQL)
INSERTINTO NUMBER OF TUPLES
DML USED IN PATTERN MATCH SEARCH CONDITION(SQL)
CARDINALITY IT RESTRICTS THE VALUES IN ROWS(SQL)
DIFFERENCE THE LANGUAGE TO DESCRIBE THE DATA
NULL A RELATIONAL ALGEBRA OPERATION WHERE TUPLES THAT ARE IN RELATION R BUT NOT IN RELATION S
WHERE NUMBER OF ATTRIBUTES
ENTITY A COLLECTION OF LOGICALLY RELATED DATA
SEMIJOIN USED TO CHANGE THE VALUE IN AN ATTRIBUTE (SQL)
ALTERNATE NOT SELECTED AS A PRIMARY KEY
BETWEENAND USED TO ERASE DATA (SQL)
IN A RELATIONAL ALGEBRA OPERATION WHERE ALL TUPLES FROM BOTH RELATIONS DUPLICATES ELIMINATED
GROUPBY USED INSTEAD OF A JOIN
CANDIDATEKEY A RELATIONAL ALGEBRA OPERATION WHERE IT CONTAINS THE TUPLES OF R THAT PARTICIPATE IN THE JOIN OF R WITH S
DEGREE ADDITIONAL RULES SPECIFIED BY THE USER
INTERSECTION IT RESTRICTS THE VALUES OF GROUPS (SQL)
LIKE USED IN A RANGE SEARCH CONDITION (SQL)

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