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 combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table






2. The area of memory in MySQL that stores the most recently entered command






3. A delete option in which related records are automatically deleted






4. A characteristic or property of an entity






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






6. An index built on more than one field






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






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






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






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






11. A characteristic or property of an entity






12. An instruction by a user that directs a database to perform a certain way






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






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






15. The SQL command used to make changes to existing table data






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






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






18. A combination of criteria in which at least on the criteria must be true






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






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






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






22. The SQL command used to add new data to a table






23. An association between entities






24. What type of an operator is >= ?






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






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






27. The prevention of unauthorized access to a database






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






29. Combination of criteria in which both criteria must be true






30. A word that is part of the SQL language






31. The most common form of a join






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






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






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






35. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities






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






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






38. A punctuation mark - such as a semicolon - that separates pieces of data






39. The SQL command used to delete a table






40. A collection of relations






41. The most common form of a join






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






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






44. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms






45. What type of an operator is >= ?






46. In an Access query the line drawn between tables to indicate how they are related






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






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






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






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