PPSC DBMS , Data Structures Quiz No 12 A.J. Bhatti October 29, 2020 Welcome to your PPSC DBMS Quiz No 12 name Email 1. The following term applies to a collection of related records in a database (A) File (B) Layout (C) File (D) Field 2. This set of related data items is known as a (A) File (B) Record (C) Table (D) None of the above 3. The framework for storing records in database is a (A) Form (B) Report (C) Query (D) Table 4. The following command is used to search the record that satisfies the specified criteria (A) FOUND (B) SEARCH (C) GET (D) LOCATE 5. The data in a record is of the following types (A) four text fields and three numeric fields (B) two integer fields and five text fields (C) three text fields and four numeric fields (D) none of the above 6. A treelike structure of records in a database. Select the best fit for answer (A) Hierarchical database structure (B) Relational database structure (C) Multidimensional database structure (D) Sequential database access 7. The following language used by most of the DBMSs for helping their users to access data (A) High level language (B) Query language (C) SQL (D) 4GL 8. What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book. (A) Information Processing (B) Spreadsheet (C) Operating system (D) Database 9. Which command is used to replace ? (A) REPLACE (B) REPLACE ALL (C) Add record from edit menu (D) All of above 10. The following part of a database that holds only one type of information (A) Report (B) Query (C) Record (D) Field 11. All of the following terms are related to computerized databases except which one? (A) Search (B) Sort (C) Field names (D) Record grab 12. Need to see all the information from two tables on one form. Insert (A) A page break (B) A subform (C) A linked command button (D) None of the above 13. What is the primary difference between a pivot table report and a cross tab query? (A) A pivot table report can contain sums, counts, and averages while a cross tab query cannot. (B) You can’t pivot a cross tab query (C) A cross tab query lets you group similar items. A pitot table report does not (D) None of above 14. The largest unit of a database is (A) A record (B) A field (C) A subfield (D) None of above 15. What’s the best Access object for an invoice you’ll mail to customers? (A) A report (B) A form (C) A table (D) All of the above 16. What is a Grouped Report? (A) A type of report that can be generated by the Report Wizard (B) A report that displays data that has been sorted in ascending or descending order (C) A report that displays data grouped by fields you specify (D) None 17. Which field allow to select items from drop down list? (A) An OLE field (B) A Memo Field (C) A lookup Field (D) A hyperlink field 18. What did the first Table Analyzer do? (A) Analyze the data in a set of flat files and automatically create a relational database system from that information (B) Provide a graphic way to design relational databases (C) Automate process of connecting tables to SQL Server (D) None 19. Pivot Table reports are good for (A) Analyzing large amounts of data (B) Turning tables upside down (C) Breaking spreadsheet data into multiple worksheet (D) None of above Which of the following are common ways to enforce data validation when entering data into an Access form? (A) Create an input mask to restrict the kind of value that can be entered in positions across the field. (B) Define a validation rule for that field (C) A and B (D) none of the above 21. The purpose of the Add-in Manager is to (A) Create macros and automate data processing (B) Add or remove data in an existing database (C) Add or remove templates, macros, and wizards D. None of These 22. Sub-schema can be used to (A) Create very different, personalized views of the same data (B) Present information in different formats (C) Hide sensitive information by omitting fields from the subschema’s description (D) All of the above 23. If you are entering data in a form, a quick way to cpy a value from the previous record is to press (A) Ctrl+’ (B) F6 (C) Ctrl+D (D) None of the above 24. DBMS is (A) Collection of data (B) Set of programs to access those data (C) Set of programs to update those data (D) All of the above 25. COPY STRUCTURE command is used to (A) Copy contents of an active database to a new file (B) Copy all records of an active database to disk (C) Copy contents of an active database to disk (D) Copy structure of an active database to a new file 26. COUNT command is used to (A) Count the number of data fields in an active database file (B) Count the number of data files which are active (C) Count the records which are updated (D) Count the number of records in an active database file 27. What is the term to ask the computer to pt information in order numerically or alphabetically ? (A) Crop (B) Report (C) Sort (D) Organize 28. The raw facts are called (A) Data (B) Programs (C) Commands (D) Responses 29. The term refers to a collection of related information (A) Database (B) List (C) Outline (D) Record 30. A form that is used to collect data in a structured manner for entry to a database is called a (A) Database deign form (B) Systems flowchart (C) Data capture form (D) None of above 31. The following command is used for inserting records (A) INSERT (B) ADD (C) Both of the above (D) None of the above 32. The Query is a statement requesting for (A) Insertion of information (B) Deletion of information (C) Update of information (D) Retrieval of information 33. The activity of a file (A) Is a low percentages of number of records added or deleted from a file (B) If high, reduces processing efficiency for sequential and non sequential files (C) Is a measure of the percentage of existing records updated during a run (D) Refers to how closely the files fit into the allocated 34. The following statement is not valid about indexing (A) it stores the index fields (B) it stores the corresponding record number (C) it maintains the alphabetically order (D) it duplicate the database file 35. The following devices can be used to input data into a database (A) Keyboard, fax roller ball (B) Mouse, keyboard, monitor (C) Mouse, keyboard, touch screen (D) None of the above 36. The following command is used for sorting (A) list (B) browse (C) index (D) sort 37. List command is used to get (A) List of database contents (B) List of database contents (C) List of variables used in database file (D) None of the above 38. A field that uniquely identifies a record is called a (A) Main field (B) Header (C) Key field (D) None of above 39. Corrupted index file is corrected using (A) Modifyindex (B) Recreateindex (C) Reindex (D) None of the above 40. The navigation buttons enable you to ( A) move from record to record in a table or form (B) move from page to page in report (C) (A) and (B) both (D) None of the above 41. Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by (A) Password (B) User id’s (C) Status (D) None of the above 42. You can switch back and forth between design and datasheet view by clicking the (A) queries object tab (B) switch command on the view menu (C) view button (D) select query title bar 43. The table wizard (A) Quickly creates a default report (B) Displays a subset of the data in a database (C) Contains sample tables and fields you can use to create a table (D) Automati (C) Contains sample tables and fields you can use to create a table (D) Automatically edits your data as you enter it cally edits your data as you enter it 44. The names, address, and account balance of all of your customers, select the best fit for answer (A) record (B) file (C) database (D) key field 45. An integrated collection of all of the data about your customers. Select the best fit for answer (A) Record (B) File (C) Database (D) Key field 46. An identification field in a record. Select the best fit for answer (A) Record (B) File (C) Database (D) Key field 47. What is part of database that holds all of the information about one item or subject? (A) Record (B) File (C) Query (D) Chart 48. What is a stored question about information in a database? (A) Record (B) Field (C) Report (D) Query 49. RDBMS stands for (A) Relational Database Management System (B) Relation Data Module System (C) Right Data Base Management System (D) None of the above 50. Pack command is used to (A) Remove records permanently (B) Remove records temporarily (C) Restore records permanently (D) Restore records temporarily 1. In SQL, which command is used to select data in rows and column from one or more tables? A) CHOOSE B) SELECT C) LIST D) BROWSE E) None of the above 2. A scheme describes A) data elements B) records and files 194 C) record relationships D) All of the above E) None of the above 3. A report form A) appears on the computer monitor during data entry B) is used during report generation to format data C) both (a) and (b ) D) All of the above E) None of the above 4. A computer file can be best described as A) a single data item B) a general collection of data items C) an orderly collection of data items D) a random collection of data items E) None of the above 5. A good query system A) can accept English language commands B) allows non-programmers to access information stored in a database C) can be accessed only by data processing professionals D) both (a) and (b) E) None of the above 6. If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it. A) Delete B) Update C) Sort Key D) Index E) None of the above 7. The modify operation is likely to be done after A) Delete B) Look-up C) Insert D) All of the above E) None of the above 8. One data dictionary software package is called A) DB/DC dictionary B) TOTAL C) ACCESS D) any of the above E) None of the above 9. One approach to standardizing storing of data A) MIS B) structured programming C) CODASYL specifications D) All of the above E) None of the above 10. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory? A) Special purpose packages B) Custom made programs C) Single function application packages D) Data management packages E) None of the above 11. A multiple-form file management system A) lets you define different forms for different operations B) lets you create a look-up form with an associated read-only password to prevent access by unauthorized users C) both (a) and (b) D) allow you to entry data in all the forms E) None of the above 12. The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types. A) Database B) Table C) Flat file D) Data structure E) None of the above 13. A _____ Contains fields of data about one entity. A) Record B) File C) Fields D) Document E) None of the above 14. A condition that led to the development of databases was A) a demand for more data to support information needs B) an increase in the amount of data handled by organizations C) the proliferation of data files D) All of the above 15. The _____ command is used to allocates an extent for the table in SQL A) MODIFY ALLOCATES B) MODIFY TABLE C) ALTER TABLE D) REDEFINE TABLE E) None of the above 16. Embedded pointer provide A) a secondary access path B) a physical record key C) an inverted index D) All of the above 17. Which of the following is a type of DBMS software? A) database manipulation language B) query language C) utilities D) report writer 18. Data items grouped together for storage purposes are called a A) record B) title C) list D) string 19. The activity of a file A) is a low percentages of number of records added or deleted from a file B) if high, reduces processing efficiency for sequential and nonsequential files C) is a measure of the percentage of existing records updated during a run D) refers to how closely the files fits into the allocated 20. Versatile report generators can provide A) Columnar totals B) Subtotals C) Calculations D) All of the above 21. Related fields in a data base are grouped to form A) data file B) data record C) menu D) bank 22. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa. A) One-to-one relationship B) One-to-many relationship C) Many-to-one relationship D) Many-to-many relationship 24. A list in alphabetical order A) is in descending order B) is in ascending order C) is the result of a sort operation D) both (b) and (c) 25. If a piece of data is stored in two places in the database, then A) storage space is wasted B) changing the data is one spot will cause data inconsistency C) it can be more easily accessed D) both (a) and (b) 26. A data dictionary is a special file that contains A) the names of all fields in all files B) the data types of all fields in all files C) the widths of all fields in all files D) All of the above 27. A file that is organized in uniform format is formally referred to as a _____ or a database file. A) Document B) Database 196 C) Record D) Structured data file 28. A form can be used to A) modify records B) delete records C) format printed output D) All of the above 29. Which language has recently become the defacto standard for interfacing application programs with relational database system? A) Oracle B) SQL C) dBASE D) 4GL 30. In SQL, the CREATE TABLE is used A) to create a table, defining its columns, integrity constrains, and storage allocation B) to add a column/integrity constraint to a table C) to redefine a column D) to change a table's storage characteristics Vitamin C prevent which disease: Hepatitis Scurvy Fever Color Bliondness Soft drink contains which gas? O2 H2O CO2 CO The thinking part of brain is: Cereblum Cerebrum Cerebelum Celebrum Gallbladder is part of which system: Respiratory System Digestive System Examining System Small intestine Chemical name of Table salt is: Carbon Dioxide Sodium Chloride Hydrogen Per Oxide None of these Which material conduct heat and electricity: Liquid Gas Solid Evaporation The source of energy for brain is : Fats Proteins Glucose Sugar How many times, newspaper can be recycled? 4-7 times 3-7 times 5-7 times 1-8 times Sulfuric acid was invented by? Aristotle Ibn ul Haitum Jabir Bin Hayan Noor ud Din The ready source of energy for athletes is: Fats Protiens Carbohydrates All of these Protein content of edible part of egg: Yolk Whitening Both A & B None of These The composition of sun is 90 % Hydrogen and Helium and Heavy metals ratio is: 8.8 % 9.8 % 6.8 % 7.8 % Plaster of Paris is made up by? Lime Copper Gypsum Iron Core RADAR captures which rays ? Radio Rays Electric rays Magnetic Rays All of these Blood clots in? Kidney Liver Bladder Heart . Ozone layer is present in ? Troposphere Mesosphere Stratosphere all of these Hydrometer used to Measure ? Relative density of liquids Relative pressure density of liquids Relative pressure of liquids Relative depth of liquids The function of the heart pacemaker? It increase the Heartbeat . it regulate the Heartbeat . it increases the Heartbeat . it accelerates blood supply to the heart . HDI (Human development index) as an indicator of the well-being free was the brainchild of? Amrita Sen . paradigm Villa . Adam Smith . Mahbub Ul Haq Zimbabwe was Earlier known as southern Rhodesia . Gold Coast . burkina faso . Belgian Congo Author: A.J. Bhatti
