CGS2060 QUIZ 11 1 Which of the following kinds of values is the one that a DBMS initially displays in a field Default 2 Which of the following kind of checks is a validity check performed on data like that in the accompanying figure which ensures users enter only alphabetic data into a field Alphabetic 3 Which of the following is a window on the screen that provides areas for entering or changing data in a database Form 4 Many database programs perform which of the following in order to analyze entered data to help ensure that it 5 is correct Validity check In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period Backward 6 Which kind of database stores data in dimensions Multidimensional 7 The developer of a relational database refers to a record as which of the following Tuple 8 Which of the following is an advantage of a multidimensional database It can consolidate data much faster 9 Object oriented and object relational databases often use a query language to manipulate and retrieve data than a relational database What is the name of this query language OQL 10 In a database such as that pictured in the accompanying figure users can set up a relationship between tables at any time but the tables must have which of the following in common A column 11 As shown in the accompanying figure which of the following is a query language that allows users to manage update and retrieve data SQL 12 A user of a database such as that pictured in the accompanying figure refers to a field as what Column 13 Which of the following privileges for data involve establishing who can enter new data change existing data delete unwanted data and view data Access 14 Which of the following identifies the quality of data in a database Data integrity 15 Which of the following is a process designed to ensure the data within the relations tables contains the least amount of duplication Normalization 16 Which of the following is a database that stores data in tables that consist of rows and columns Relational 17 Which of the following is a program with which users interact that generally has a more user friendly interface than a DBMS Front end 18 The developer of a relational database refers to a file as which of the following Relation 19 Which of the following is an item that contains data as well as the actions that read or process the data Object 20 In managing a company s database which of the following roles requires a technical inside view of data Administrator 21 Which of the following refers to the procedures that keep data current File maintenance 22 Which of the following is a number s or character s that is appended to or inserted into a primary key field 23 Which of the following is a huge database that stores and manages the data required to analyze historical and Check digit current transactions Data warehouse store unstructured information less efficiently 24 Compared with relational databases which of the following is NOT true of object oriented databases They 25 A user of a database such as that pictured in the accompanying figure refers to a file as what Table 26 Which of the following is true in a relational database Each row has a primary key and each column has a unique name 27 What is the process of comparing data with a set of rules or values to find out if the data is correct Validation 28 Which of the following kind of checks is a validity check performed on data like that in the accompanying figure which ensures users enter only numeric data into a field Numeric 29 A form that sends entered data across a network or the Internet is called which of the following terms E form 30 Most DBMSs include a feature as shown in the middle image within the accompanying figure which has a graphical user interface to assist users with retrieving data What is this feature called QBE 31 Which of the following kinds of backup are used by organizations such as hospitals communications companies and financial institutions Continuous 32 Most of this kind of database products for servers and mainframes include SQL an example of which is shown in the accompanying figure What kind of database product is this Relational 33 In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup Forward 34 An application that supports a front end program sometimes is called which of the following Back end 35 A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them What is this level of privileges called Read only 36 A user of a database such as that pictured in the accompanying figure refers to a record as what Row 37 Which of the following is a collection of related records as shown in the accompanying figure stored on storage 38 Which of the following languages consists of simple English like statements that allow users to specify the data media such as a hard drive or optical disc File to display print or store Query 39 Which of the following is a request for specific data from a database Query 40 Which of the following is a collection of data organized in a manner that allows access retrieval and use of that 41 Which of the following kinds of programs interacts with a DBMS which in turn interacts with the database data Database Front end 42 In a relational database where does the only data redundancy exist In the fields 43 A DBMS uses which of the following to perform validation checks Data dictionary 44 Which of the following consists of rules and standards that define how a database organizes data Data model 45 Which of the following kind of checks is a validity check on data like that in the accompanying figure which determines whether a number is within a specified group of numbers Range
View Full Document
Unlocking...