Test your basic knowledge |

Database Management 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. Tally of how many rows meet criteria specified






2. Large structured set of persistent data






3. Three Basic Operations of SP - SR - SB: Publish - Find - ____






4. Responsible for technical implementation & maintenance of database on a design & physical level






5. Used in a SELECT clause in place of a column






6. Most valuable asset of a database system.






7. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed






8. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)






9. Data remains unchanged in database






10. Used with another comparison operator - values become inverted






11. Copies multiple records at the same time using a SELECT statement






12. Essentially a collection of services that communicate with eachother






13. Ensures functions are done efficiently






14. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities






15. SQL finds and retrieves date






16. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG






17. Combines rows from a SELECT statements result table into a group






18. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser






19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands






20. Large structured set of persistent data






21. Data stored by DAd






22. Has the highest precedence - followed by the AND - OR






23. Decides what data is stored in the databse and the manner it is stored






24. Used in a SELECT clause in place of a column






25. Data in database interacts & corresponds with other data






26. Table displayed in descending order






27. Practice of writing code into a webpage that is not directly visible to the user






28. SQL Commands: Define tables - views - _____ - delete or insert info






29. Practice of writing code into a webpage that is not directly visible to the user






30. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values






31. Columns containing numbers only






32. Three Basic Operations of SP - SR - SB: Publish - Find - ____






33. All Columns indicated and selected






34. Allows use of single or multiple character wildcards with the underscore or percent symbol






35. Straight implementation of raw data formatted into rows and columns






36. Identifies columns to appear in the result






37. Used to remove duplicates from result table






38. Copies multiple records at the same time using a SELECT statement






39. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values






40. Characterizes operation of a relational database






41. Some form of output - usually - printed - containing information






42. Identifies columns to appear in the result






43. Everything in enviroment becomes an object - expands on Priniples of relational databases






44. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________






45. Everything in enviroment becomes an object - expands on Priniples of relational databases






46. One huge database to hold all data; Access to data - and use of system to add - update & print records






47. Ongoing record of data reflecting the info defining the database






48. Characterizes operation of a relational database






49. Some form of output - usually - printed - containing information






50. = - < - > - <= - >= - <> - !