1. Which of the following is not a valid data type in star base?
a) Character b) Boolean c) Picture d) Real
2. Which field is used to uniquely identity a record in a database table?
a) Many key b) Primary key c) Common key d) Key
3. Which database type contains single data table?
a) Hierarchical b) Relational c) Flat - file d) Network
4. Which of the following option is used to remove the filter?
a) Remove filter b) delete filter c) Remove filter / sort d) Delete filter / sort
5. What is the name of the process for joining data from two or more tables?
a) Joining b) Editing c) Merging d) Adding
6. What is the name of the screen that displays the fields of record in a well spaced our
manner? a) Report b) Form c) Query d) Filter
7. Which of the following are two types of reports? a) Static and Dynamic
b) Static and primary c) Primary and Secondary d) Dynamic and primary
8. What is the name of a set of data for each database entry?
a) Field b) File c) record d) Table.
9. Which language is used to query the database? a) C++ b) SQL c) HTML d) C
10. SQL stands for___. a) Structured Query language b) Sorted Query language
c) Sorted Question language d) Structured Question language.
11. The field type that is not allowed by star base is ____. a) Text b) Binary c) Project
d) Image.
12. The computer that primary use the hierarchical database are ____.
a) Super b) Mainframe c) personal d) Mini
13. The team data is derived from the word_____.
a) Datum b) datem c) Datas d) Datus.
14. A column in a star base table represents a ___.
a) Structure b) File c) Field d) record.
15. The process used to select the desired and specific data from a database is ___.
a) Merging b) Sorting c) Editing d) Searching
16. In set of processed data is called ___.
a) Data b) datum c) Information d) Database
17. Each row in a database table represents ____.
a) File b) Record c) Field d) Table.
18. A database that contains of a single data table is ____.
a) Relational b) Flat - file c) Hierarchical d) Network
19. Which is a type of query? a) Table b) Forms c) Filter d) Report
20. How many steps are there in the report wizard window?
a) 6 b) 7 c) 8 d) 9
21. What is a way of limiting the information that appears on screen?
a) Searching b) Filtering c) Merging d) Report
22. Hierarchical database was primarily used on ______ computers
a) Super b) Personal c) Micro d) mainframe
23. Which icon is used to remove the sorting in star base?
a) Delete Filter / sort icon b) Delete sort icon c) Remove sort / filter icon d) none.
24. In star base, which is printed information that is assembled by gathering data based on
user Supplied criteria? a) Filter b) Query c) Form c) Report
25. Which of the following are users constructed statements in star base?
a) Filters b) queries c) Forms d) Report
26. DBMS is an acronym for ___.
a) Database maintaining system b) Database management system
c) Database manipulating system d) Database merging system
27. Which of the following is also a special type of query?
a) Form b) report c) Filter d) Question
28. Which of the following is not a step in data processing?
a) Collection b) Verification c) Computation d) Validation
29. The number of field types used in star base is ____. a) 20 b) 30 c) 12 d) 13
30. The filter used with a condition is called ___ filter.
a) Auto b) Sort c) Default d) Remove.
31. In database, which option is used to define the maximum size of a field?
a) Default value b) Length c) Type d) Value
32. Which involves data collection, verification, validation and report generation?
a) Data b) Data processing c) Database d) Table
33. In which computers Hierarchical database structures were used?
a) Mini b) Micro c) Mainframe d) Super
34. The numeric data type can be ___. a) integer b) float c) Date d) All the above
35. Users can define their own data types called __ data type.
a) Built - in b) System defined c) user defined d) primitive
36. ___ is a set of processed data that convey the relationship between data considered.
a) Information b) Data c) Datum d) Program
37. If we use a computer to prepare, store, process and print the data, we call it as ___
data Processing. a) Data b) manual c) Hand d) Computerized
38. The processing speed is fast in __ data processing.
a) Computerized b) Manual c) Both a & b d) either a or b
39. In computerized data processing, it is easy to edit the data including ___.
a) Correction b) Change c) Modification D) All the above
40. Manipulating of a database includes ____.
a) Sorting b) Merging c) Editing d) All the above
41. Editing is the process of ____. a) Adding new data b) Deleting the existing data
c) changing the format d) all the above
42. Based on the conceptual structures, the data bases can be classified into ___ types.
a) 3 b) 2 c) 4 d) 5
43. The ____ database structure is the most prevalent database in today’s business
organizations.
a) Flat - file b) relational c) Hierarchical d) Object oriented
44. In ____ databases, records are organized in a tree like structure by type.
a) Hierarchical b) Relational c) Network d) Flat file.
45. ____ database is useful for certain single user or small group situations.
a ) Relational b) Flat file c) Hierarchical d) Flat file.
46. The ____ database is similar to the hierarchical structure excepts that any one type can
relate To any number of types.
a) Network b) Object oriented c) flat file d) relational
47. An object is defined by its _____.
a) Attributes b) Characters c) Procedures d) all the above.
48. The data management tasks in a DBMS fall into one of the ___ categories.
a) 2 b) 3 c) 4 d) 5
49. The data management tasks in a DBMS involves____.
a) Entering data into the database b) Reordering records in the database.
c) Obtaining subsets of the data d) All the above.
50. __ provides the means for multiple users to access and share data in the same database
by way Of networked systems.
a) Star calc b) Star base c) DBMS d) Ms - office
51. In star base window, the ____ pane displays tables, queues, forms, and report.
a) Right b) Left c) Top d) Bottom
52. In star office base window, on the right top is ____ pane.
a) Tables b) Forms c) Tasks d) Reports.
53. Once the database is created, the next step is to create the _____.
a) Data b) Tables c) Related tables d) Reports
54. Using tables, star office base allows us to ______.
a) Design forms b) Query the database c) Prepare reports d) All the above.
55. We can also give a brief description of the contents of the _____.
a) Table b) Record c) Field d) database
56. Star base allows us to use ____ different field types.
a) 5 b) 10 c) 20 d) any number
57. ____ accepts small integer’s upto a few thousands.
a) Integer b) Small integer c) Tiny integer d) Big integer
58. ____ Data type accepts only whole numbers.
a) Integer b) Decimal c) Real d) Image.
59. Single precision decimal values are accurate upto a length of ___ places.
a) 5 b) 7 c) 9 d) 14.
60. Double precision decimal values are accurate upto a length of ___ places.
a) 7 b) 14 c) 28 d) 56.
61. While designing the table we enter values for the ____.
a) Field name b) Field type c) Description d) All the above
62. ____ option is used to specify the maximum characters that can be entered in that field.
a) Entry required b) Length c) Default value d) Size of the field.
63. ____ menu is used to modify the table design.
a) File b) Format c) Edit d) Insert
64. After entering the records into the table star base allows you rearrange them by ____.
a) Merging b) Filtering c) Searching d) Sorting.
65. To display the records in the original order, click on___.
a) Unsort icon b) Filter icon c) Remove sort/filter icon d) any of the above
66. The language, supported by DBMS is____. a) C++ b) Java c) SQL d) ADA
67. ___ are special views of the data in a table.
a) Database b) Sorting c) Queries d) Reports
68. The output from a____ does not affect the original table.
a) Table b) Sort c) Query d) Data
69. The first step of query wizard is ____.
a) Field selection b) Sorting order c) Sort wizard d) Query wizard
70. A ____ ia a type of query. a) Sort b) Filter c) Report d) Search
71. ___ is used to select and display records which match a certain condition.
a) Filter b) Sort c) Report d) Search
72. Filters ____ be saved for later use. a) Can b) Cannot c) May d) may not
73. Star office allows you to use the filters of ____ types. a) 2 b) 3 c) 4 d) many
74. Filter used with a condition is called ____ filter.
a) Auto b) Conditional c) Default d) filter
75. The filter window is very similar to the one used for specify condition in a ___.
a) Sort b) Report c) Form d) Query
76. To remove the filter, click on ____ icon.
a) Remove filter b) Remove filter/sort c) Remove sort d) Remove default filter
77. A _____ is a screen that displays the fields of a record in a well spaced out manner.
a) Query b) Filter c) Form d) Report
78. Select the ___ check box in the set up a subform window to insert another form within
this form. a) Add subform b) add form c) Insert form d) insert subform.
79. ___ helps us to generate report.
a) report wizard b) report auto pilot c) report temple d) report window.
80. Select ____ in the paste special dialog box, to see the data automatically changes in the
Document, when it is modified in the spread sheet.
a) OLE b) Link c) Link and paste d) DDE link.
81. Field types include ____. a) Text b) Numeric c) Logical d) all the above.
82. __ and ___ are conceptual model for older systems.
a) Flat file, Network b) Hierarchical, network c) relational, object oriented d) none.
83. Select ____ option on the tasks pane to create a query. a) Create query in SQL view
b) Create query in design view c) Use wizard to create query d) Create query.
84. ____ is defined by its characteristics, attributes and procedures.
a) Form b) record c) Object d) File.
85. Data’s are of ____ types. a) 3 b) 5 c) 12 d) 10
86. Star base window is divided into how many panes? a) 2 b) 3 c) 4 d) 5
No comments:
Post a Comment