Name______________________________________

T / F 1) A database has operations such as storing, displaying, and searching for records.

T / F 2) A file should be closed before it is opened again for another operation mode.

T / F 3) A file can be accessed sequentially as well as randomly.

T / F 4) The most efficient way to delete from a file is to copy the entire file, excluding deleted data.

T / F 5) Random access becomes faster if each record has a fixed length with a unique key.

T / F 6) Binary files store the binary value of a number instead of its ASCII value.

T / F 7) Modification is more difficult in arrays rather than in a sequential file.

T / F 8) It is better to store large amounts of data into an array rather than into a file.

T / F 9) Information in an array will be lost after the program terminates.

T / F 10) In sequential files, modification requires duplication of the existing file.

T / F 11) A data file is a file in which data is stored and from which data is retrieved.

T / F 12) In random access there is no need for duplication of the file when deleting a record.

T / F 13) When deleting a record from an array, the physical storage will be deleted.

T / F 14) It is necessary to shuffle an array upon deletion to make the insertion faster.

T / F 15) If the array is not shuffled after deletion, it is necessary to indicate that the record was deleted.

T / F 16) A Database is a collection of unrelated data.

T / F 17) One person having many credit cards is an example of a many-to-many relationship.

T / F 18) The most important function in a database is delete.

T / F 19) A database can have at most one table.

T / F 20) The importance of normalization of a database is to create more memory for redundancy of data.

 =====================================================================================

T / F 21) Simple file encryption can be done by changing ASCII values or by using an associate array.

T / F 22) Overtime pay computation is a function of select command and SQL reports are an example of database manipulation.

T / F 23) A database report is used by managers to enter new records to a database.

T / F 24) Add (append) , Delete (purge), Modify (update), and Search are all functions of operating systems.

T / F 25) The interaction between you and your computer is also known as an interface.

T / F 26) Three categories of data models are conceptual, physical, and implementation.

T / F 27) A database schema includes descriptions of the database structure and the constraints that should hold on the database.

T / F 28) C++ is an example of a DBMS language.

T / F 29) A primary key is necessary to uniquely identify a record in a table; two records may have the same value in the field designated as primary key.

T / F 30) Creating relationships between tables increases data redundancy and makes a database less efficient.

T / F 31)  When input data becomes large, it is necessary to work with a data file rather than typing it.

T / F 33) Unicode consists of 32 bits.

T / F 34) A database consists of infinite fields.

T / F 35) A load function will read all records from a file into an array and should be called at the start of a program.

T / F 36) ifstream fin(“data.txt”,ios::in); if(!fin) cout<<”NO FILE”;  will test the file’s existence.

T / F 37) A file can be opened for both input and output such as fstream fout(“data.dat”, ios::in|ios::out);

T / F 38) “del” and “rename” in C++ which are to delete and rename a file, are equivalent to “rm” and “mv” which are in Linux or Unix.

T / F 39) A binary search is fastest for searching a large unsorted data file.
 

T / F 40) Database validation of user input is necessary for fields such as phone number and social security to ensure data integrity.

T / F 41) Sequential search is preferred over hashing because of the speed.

T / F 42) The C++, system( ) function enables the programmer to use operating system commands.

T / F 43) In a random access file, seekg( ) is used for putting data and seekp( ) is used for getting data.

T / F 44) Most of today’s databases interact with the user and then access the data file to search and to perform the necessary operations.

T / F 45) A table in a relational database is a predefined format of rows and columns that define an entity.

T / F 46) Examples of databases are WindowsNT, UNIX, DB2, MYSQL, and Solaris.
 

T / F 47) You can create CGI web databases using the following programming languages: C/C++ and Perl.

T / F 48) The three example databases are Access, SQL, and Oracle.

T / F 49) In a database, a table contains records, records contain fields, fields contain characters, a character contains a byte or two.

T / F 50) Encryption is essential when working with databases to keep information unaccessible.

 =====================================================================================

T / F 51) A bite has a single binary value, either 0 or 1.
 

T / F 53)By using a linked list the deleted record will be physically deleted.

T / F 54)A relational database is a collection of organized data that are related between its

various data members.

T / F 55) A byte is the smallest addressable unit of data in a computer.

T / F 56) A database can be made in any language such as C++, Java, Visual Basic, or JavaScript.

T / F 57) The interaction between you and your computer is also known as an interface.

T / F 58) C++ is the foundation for the most popular database application on the Internet.

T / F 59) The three example databases are Adobe, PowerPoint, and Microsoft Word

T / F 60) An example of Data Manipulation\Reporting in a Payroll\Bank Database is an overtime pay report.

T / F 61) There have been as many as 9,000 deaths as a result of medical database errors each year.

T / F 62) Ingres is a database under windows operating systems.



T / F 63) Primary key is used in relational databases to uniquely identify records.

T / F 64) For a database security is more important than access.

T / F 65) Database Normalization is used to minimize duplication of information.

T / F 66) The main functions of the database are: create, read, update, duplicate, and delete.

T / F 67) A key feature of the computer is the ability to store information, and to retrieve it at a later time.

T/F 68) The important commands of SQL are select, update, and purge.

T/F 69) The Assignment for this class is to design a Web interface.

T/F 70) To create a database interface you must use Oracle.

T/F 71) In order to design a database with access it must be specified the length and type of each field.

T/F 72) In Unicode the value of 'A' is 65 and 'a' is 97.

T/F 73) It is possible to create a database on Web by using CGI.

T/F 74) The most important function of a database is the search function.

T/F 75) It is possible to retrieve deleted records from a database.