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 SQL command used to delete a table






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






3. The individual who is responsible for a database or the head of database administration






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






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






6. An association between entities






7. The SQL clause that is used to enforce legal-values integrity






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






9. An update option in which related records are automatically updated






10. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.






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






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






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






14. The SQL statement that is used to grant different types of privileges to users of a dataabase






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






16. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types






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






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






19. A field whose value is computed from other fields in the database






20. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity






21. The SQL command used to describe the layout of a table. The word table is followed by the name of the table to be created and then by the names and data types of the column (fields) that comprise the table






22. 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






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






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






25. When sorting on two fields this is the more important field






26. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null






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






28. The portion of the system catalog that contains view information






29. The individual who is responsible for a database or the head of database administration






30. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE






31. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.






32. Two simple criteria in a query the are combined with the AND or OR operators






33. In relational algebra the operation in which two tables are connected on the basis of common data.






34. A data value meaning "unknown" or "not applicable"






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






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






37. When sorting on two fields this is the more important field






38. A person or place or object or event or idea for which you want to store and process data






39. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database






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






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






42. The prevention of unauthorized access to a database






43. A characteristic or property of an entity






44. A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to or at most one occurrence of the first entity






45. The part of an SQL SELECT command that indicates grouping






46. The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users






47. The plural of Criterion






48. The relational algebra command to select rows from a table






49. The field on which data are sorted






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests