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. Change order of rows in result table






2. SQL Commands - Two Things Specify data interested in - Indicate the ________






3. = - < - > - <= - >= - <> - !






4. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause






5. SQL finds and retrieves date






6. Averages the numeric values






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






8. Data stored by DAd






9. Everything between the start and end tag






10. SQL finds and retrieves date






11. Tally of how many rows meet criteria specified






12. Concatenated in SQL Server Database software using the addition symbol






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






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






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






16. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor






17. Identifies columns to appear in the result






18. Interact and manipulates the data in the database






19. Give the browser more specific information about that tag






20. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor






21. Data that has been processed into a format that is understandable by its audience






22. Uses relationships between independent entities






23. Specifies the tables or views from which rows and columns are retrieved






24. Begins an element






25. Identifies columns to appear in the result






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






27. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage






28. Uses relationships between independent entities






29. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.






30. Describe information in a tree styled format






31. Defines a new column






32. Characterizes operation of a relational database






33. Software system designed to support interface for a software asset that manages a specific set of tasks






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






35. Data in database has ability to be accessed and manipulated by several users






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






37. Everything between the start and end tag






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






39. Ensures data is correct casings






40. Create program files that include SQ after each command






41. Change order of rows in result table






42. Limits the rows that appear in the result mathcing a specified condition






43. Ensures functions are done efficiently






44. Flat File Examples: Excel Spreadsheets - _____






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






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






47. Finds the lowest ACII value in column






48. Ensures functions are done efficiently






49. Describe information in a tree styled format






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