Misy 5300 - Study guides, Class notes & Summaries

MISY 5300 Oracle Academy DP Section 3 Quiz questins and answers verified 2024

MISY 5300 Chapter 8application DBA - correct answer A role that focuses on database design and the ongoing support and administration of databases for a specific application or set of applications within a business. archives - correct answer A place where a record of certain corporate data is kept. Data that is no longer needed in a corporate database but must be retained for future reference is removed from the database and placed in the archive. Also called a data archive. Authentication...

MISY 5300Steps in information level design - correct answer Describing the attributes needed for each entity as well as the relationships between the entities based on business rules. This process typically involves creating an entity-relationship (E-R) diagram to visually represent the database design User views - correct answer The specific data needed by a person or process for a particular task One-to-Many Relationship - correct answer Means one record in the table on the "one side of...

Chapter 5 - MISY 5300 1NF (First Normal Form) - correct answer table is in this form when it does not contain repeating groups, each column contains atomic values and no duplicate records 2NF - correct answer is a progression beyond 1NF that organizes the columns into smaller relation, no partial dependencies 3NF - correct answer include rules of 2NF but also exclude transitive dependencies. - No transitive dependencies exist 4NF - correct answer all requirements meet of 3NF Further ...

Chapter 3 - MISY 5300 & operator - correct answer combine the contents of two text fields aggregate function - correct answer calculate on groups of records (also called built in functions). EX. can average values n a numeric field using avg sql keywords alias - correct answer the name assigned to a new computed field. can be applied to any field. Uses the AS keyword American National Standards Institute (ANSI) - correct answer An organization that oversees the development of voluntar...

misy 5300 exam questions & answers 2023/2024 algorithm - ANSWER-a defined set of steps to solve a problem attribute - ANSWER-a characteristic property of an entity: also called a column or field big data - ANSWER-the large volume of data produced by every digital process system, sensor, mobile device, and even social media exchange column - ANSWER-a characteristic or property of an entity; also called an attribute or field data analyst - ANSWER-a job title for a person who uses ...

MISY 5300 Oracle Academy DP Section 3 QuizWhat will be the results of the following selection? SELECT *FROM employees WHERE last-named NOT LIKE 'A%' AND last name NOT LIKE 'B%' - correct answer No rows will be returned. There is a syntax error All rows will be returned *A=All last names that do not begin with A or B All last names that begin with A or B Which statement about the logical operators is true? - correct answer The order of operator precedence is AND, NOT, and OR. ...

Midterm Misy 5300algorithm - correct answer set of rules, calculations, and assumptions used to solve a problem big data - correct answer describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange data independence - correct answer a quality that allows you to change the structure of a database without requiring you to make major changes to the programs that access the database data redundancy - correct answer the ...