Test your basic knowledge |

Database Fundamentals

Subject : it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. The relational algebra command to select rows from a table






2. A characteristic or property of an entity






3. What type of an operator is >= ?






4. The relational algebra command for performing the difference of two tables






5. A combination of two tables consisting of all records that are in either table






6. The individual or group that is responsible for a database






7. An index built on more than one field






8. A very popular relational data definition and manipulation language that is used in many relational DBMS's






9. The property that no record can exist in the database with a value in a field other than a legal value






10. The SQL command that creates an index in a table






11. A program or a collection of programs through which users interact with a database






12. A computer that provides services to the clients in a client/server system






13. A database has integrity if the data in it satisfies all established integrity constraints






14. The SQL command used to delete a table






15. When comparing tables an intersection is a new table containing all rows that are in both original tables






16. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database






17. An association between entities






18. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns






19. A statement the can be either true or false. Also called a condition






20. A message in Access that is displayed when a validation rule is violated






21. The process of creating collections of records that share some common characteristics






22. The field or fields on which an index is built






23. When comparing tables an intersection is a new table containing all rows that are in both original tables






24. The property that lets you change the structure of a database without requiring you to change the programs that access the database






25. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups






26. The portion of the system catalog the contains column information






27. A question the answer to which is found in the database






28. The table obtained by concatenating every row in the first table with every row in the second table






29. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.






30. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations






31. The prevention of unauthorized access to a database






32. The relational algebra command used to select columns from a table






33. When sorting on two fields - the less important field






34. A rule that must be followed by data in a database






35. A file used to store data about a single entity. Such a file can be thought of as a table.






36. A file used to store data about a single entity. Such a file can be thought of as a table.






37. The plural of Criterion






38. Duplication of data or the storing of the same data in more than one place.






39. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column






40. The SQL command that drops (deletes) and index from a table






41. The part of an SQL SELECT command that indicates a sort order






42. A screen object you use to maintain or view and print data from a database






43. The property that lets you change the structure of a database without requiring you to change the programs that access the database






44. An access tool that provides documentation about the objects in a database






45. The portion of the system catalog that contains table information






46. A collection of relations






47. The column on which two tables are joined






48. The rule that no column (attribute) that is part of the primary key may accept null values






49. A rule that must be followed by data in a database






50. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests