MIS 2113 Final OU EXAM QUESTIONS WITH CORRECT ANSWERS.

MIS 2113 Final OU EXAM QUESTIONS WITH
CORRECT ANSWERS


SQL (Structured Query Language) - CORRECT ANSWER✔✔-Used to
| | | | | | | |



create and manipulate databases
| | |




MyEducator - CORRECT ANSWER✔✔-application/front end to access
| | | | | | |



data


DBMS (Database Management System) - CORRECT ANSWER✔✔-a
| | | | | | |



program used to create, process, and administer a database (ex. "town
| | | | | | | | | | |



where many houses (databases) can be built)
| | | | | |




data - CORRECT ANSWER✔✔-Facts, figures, and other evidence
| | | | | | | |



gathered through observations.
| |




Schema - CORRECT ANSWER✔✔-a concept or framework that organizes
| | | | | | | |



and interprets information
| | |




Attributes - CORRECT ANSWER✔✔-pieces of information about a
| | | | | | | |



person/thing that are relevant for a particular database
| | | | | | |

, ERD (Entity Relationship Diagram) - CORRECT ANSWER✔✔-document
| | | | | | |



that shows data entities and attributes and relationships among them
| | | | | | | | |




Entities - CORRECT ANSWER✔✔--collect data about attributes
| | | | | | |




-primary keys |




-nouns


Relationships - CORRECT ANSWER✔✔--foreign keys
| | | |




-verbs
-made by matching primary keys to foreign keys
| | | | | | |




Query - CORRECT ANSWER✔✔-to ask, request, and get an answer in
| | | | | | | | | | |



SQL


SELECT statement - CORRECT ANSWER✔✔-The SELECT statement is
| | | | | | | |



used to select data from a database. Syntax:
| | | | | | |




SELECT column_name, column_name
| |




FROM table_name;
|




SELECT * FROM table_name;
| | |