ch6.pdf

26 Pages
148 Views
Unlock Document

Department
Information Technology Management
Course
ITM 100
Professor
Catherine Middleton
Semester
Fall

Description
Exam Name TRUEFALSEWrite T if the statement is true and F if the statement is false1A grouping of characters into a word a group of words or a complete number is called a record1Answer TrueFalse2Each characteristic or quality describing a particular entity is called an attribute2Answer TrueFalse3Programdata dependence refers to the coupling of data stored in files and software programs 3that use this data such that changes in programs require changes to the dataAnswer TrueFalse4A bit represents the smallest unit of data a computer can handle4Answer TrueFalse5A group of bytes called a bit represents a single character which can be a letter a number or 5another symbol Answer TrueFalse6A group of related fields such as a students name the course taken date and grade comprises 6a fileAnswer TrueFalse7A group of records of the same type is called a file7Answer TrueFalse8A group of related files makes up a database8Answer TrueFalse9Each characteristic or quality describing a particular entity is called an attribute 9Answer TrueFalse10The use of a traditional approach to file processing encourages each functional area in a 10corporation to develop specialized applications Answer TrueFalse11Data redundancy is the presence of duplicate data in multiple data files so that the same data are 11stored in more than one place or location Answer TrueFalse12Data inconsistency is where the same attribute may have different values 12Answer TrueFalse13Programdata independence refers to the coupling of data stored in files and the specific 13programs required to update and maintain those files so that changes in programs require changes to the data Answer TrueFalse14A traditional file system can deliver routine scheduled reports after extensive programming in a ely efforts it can also deliver ad hoc reports or respond to unanticipated information requirements timfashion 14Answer TrueFalse15A more rigorous definition of a database is a collection of data organized to serve many 15applications efficiently by centralizing the data and controlling redundant data Answer TrueFalse16A database management system DBMS is software that permits an organization to centralize 16data manage them efficiently and provide access to the stored data by application programs Answer TrueFalse17A DBMS reduces data redundancy and inconsistency by maximizing isolated files in which the 17same data are repeated Answer TrueFalse18Microsoft Access is a relational DBMS for desktop systems18Answer TrueFalse19Microsoft SQL Server are relational DBMS for large mainframes and midrange computers 19Answer TrueFalse20Oracle Database Lite is a DBMS for small handheld computing devices20Answer TrueFalse21 Rows are commonly referred to as records or in technical terms as tulips21Answer TrueFalse22Rows are commonly referred to as records or in technical terms as tulips22Answer TrueFalse23A DBMS separates the logical and physical views of the data23Answer TrueFalse24The select operation creates a subset consisting of columns in a table permitting the user to create 24new tables that contain only the information required Answer TrueFalse25DBMS designed for organizing structured data into rows and columns are not well suited to 25handling graphicsbased or multimedia applicationsAnswer TrueFalse26An objectoriented DBMS stores the data and procedures that act on those data as objects that 26can be automatically retrieved and shared Answer TrueFalse27Most DBMS have a specialized language called a data manipulation language that is used to 27add change delete and retrieve the data in the databaseAnswer TrueFalse28The most prominent data manipulation language today is Structured Query Language SQL28Answer TrueFalse
More Less

Related notes for ITM 100

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit