UTA INSY 3304

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) A _______ is anything about which data are to be collected and stored. entity A ________ is bidirectional. relationship Database designers determine the data and information that yield the required understanding of the entire business. False In an SQL-based relational database, each table is dependent on every other table. False An operational database is sometimes referred to as an enterprise database. False ...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) components of a DB System (Database System) (4) hardware, software, data, procedure, and database access language. Functions Of DBMS (Database management system) data dictionary management, data integrity management, data storage management, data security management Types of Database Systems (location and # of users) - Centralized database. - Distributed database - near its greatest demand - Enterprise database -...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) Relational adv structural independence is promoted by use of independent tables -tabular view improves simplicity -ad hoc query based on SQL Relational disadv requires substantial hardware and system software overhead -simplicity makes it easy for untrained people to use tools poorly, and produce data anomalies -may promote island of info problems because ind and departments can easily develop own apps entity r...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) Components of DB System 1)Hardware (comp, storage, printers) 2)Software (OS, DBMS software, apps) 3)People (all users, admin, end users, programmers) 4)Procedures (rules, enforce standards) 5)Data (collection of facts stored) Functions of DBMS 1) Data Dictionary management (stores definition of data elements and their relationships) 2) Data storage management (creates/ manages complex structures required for da...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) First normal form (1NF) Table format, no repeating groups, and PK identified Second normal form (2NF) 1NF and no partial dependencies Third normal form (3NF) 2NF and no transitive dependencies Functional dependence Attribute A determines attribute B (that is, B is functionally dependent on A) if all (generalized definition) of the rows in the table that agree in value for attribute A also agree in value for attr...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) Normalizations (3) -evaluating and correcting table structures to minimize data redundancies -1nf -2nf -3nf 1NF (First Normal Form) Table Format. No repeating groups and a primary key identified. 2NF (Second Normal Form) 1NF and no partial dependencies 3NF (Third Normal Form) 2NF and no transitive dependencies Dependencies (4) -Functional Dependency -Full Functional Dependency -Partial Dependency -Transi...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) Create the databases Requires the creation of special storage-related constructs to house the end-user tables Load or convert the data Requires aggregating data from multiple sources Full backup/dump All database objects are backed up in their entirety Differential backup Only modified/updated objects since last full backup are backed up Transaction log backup Only the transaction log operations that are not r...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) Data definition language DDL Data manipulation language DML CREAT SCHEMA AUTHORIZATION Creates a database schema CREATE TABLE Creates a new table in the user's databse schema NOT NULL Ensures that a column will not have null values UNIQUE Ensures that a column will not have duplicate values PRIMARY KEY Defines a primary key for a table FOREIGN KEY Defines a foreign key for a table DEFAULT Defines a ...

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+) Transaction A logical unit of work that must be entirely completed or aborted Atomicity All operations of a transaction must be completed; if not the transaction is aborted Consistency Permanence of database's consistent state Isolation Data used during transaction cannot be used by second transaction until the first is completed Durability Ensures that once transactions are committed they cannot be undone ...