1. The term data comes from the word
(a) Datus (b) Datum (c) Datem (d) Datas
2. A database is a repository of collections of related
(a) Row (b) Table (c) Data (d) Column
3. Which of the following is used to arrange data in some order?
(a) Sorting (b) Form (c) Query (d) Filter
4. How many field types are there in Star Office Base?
(a) 11 (b) 20 (c) 13 (d) 14
5. The entire collection of related data in one table is referred to as
(a) Query (b) File (c) Field (d) Record
6. Which key uniquely identifies a record in a database table?
(a) F1 key (b) Primary key (c) F5 key (d) Secondary key
7. Editing the data includes
(a) Deleting a record (b) Changing the format of the database
(c) All the other three choices (d) Appending a record
8. Which database file consists of a single data table?
(a) Relational (b) Flat-File (c) Network (d) Hierarchical
9. Which is a process of joining data from two table s of different databases?
(a) Filtering (b) Searching (c) Merging (d) Sorting
10. To edit a record, we have to select the record by clicking on
(a) Record pointer (b) Record button (c) Tab key (d) Record key
11. Process of performing correction on the existing data is called as
(a) Filtering (b) Editing (c) Searching (d) Sorting
12. Printed information that is assembled by gathering data is cal
(a) Table (b) Form (c) Query (d) Report
13. By clicking on the Delete Rows option the selected record will
(a) Appended (b) Changed (c) Deleted (d) Edited
14. Sorting on more than one field of a table at the same time is called
(a) Multi Sorting (b) Multiple sorting (c) Searching (d) Sorting
15. DBMS is an acronym for
(a) Data Base Management System (b) Data Base Maintaining System
(c) Data Binary Management System (d) Data Base Manipulating System
16. Which is simply a screen that displays fields of a record in a well spaced out manner?
(a) Filter (b) Table (c) Query (d) Form
17. In How many ways the Manipulation of database can be done?
(a) 7 (b) 6 (c) 10 (d) 8
18. Standard Filter is also called as
(a) Conditioned Filter (b) Complete Filter (c) Default Filter (d) AutoFilter
19. The process used to select a desired specific data from a database is
(a) Filtering (b) Sorting (c) Merging (d) Searching
20. The shortcut key used for saving a table in StarOffice Base is
(a) Ctrl + F (b) Ctrl + A (c) Ctrl + E (d) Ctrl + S
21. A Database is a collection of
(a) Fields (b) Columns (c) Rows (d) Tables
22. A repository of collections of related data or facts
(a) Program (b) Database (c) Data (d) Information
23. SQL stands for
(a) Standard Query Link (b) Structured Query Language
(c) Standard Query Language (d) Structured Query Link
24. The accurate length of decimal digits in a s ingle precision number is
(a) 7 (b) 14 (c) 13 (d) 8
25. Sorting is a process of
(a) Joining the data (b) Performing corrections
(c) Arranging the data (d) Selecting a desired specific data
26. Which one of the following databases is very powerful?
(a) Relational (b) Hierarchical (c) Network (d) Flat-File
27. Which command is used to create a new database in StarOffice Base?
(a) New_File_Database (b) File_New_Table (c) New_Database (d) File_New_Database
28. The collection of Tables, Queries, Forms and Reports are generally referred to
(a) Multimedia (b) Document (c) Database (d) Spreadsheet
29. What are the two types of report in StarOffice Base?
(a) Static and Dual (b) Static and Standard (c) Standard and Dynamic (d) Static and Dynamic
30. In case of double precision, decimal values are accurate upto the length of
(a) 8 Places (b) 6 Places (c) 14 Places (d) 7 Places
31. To send text outline into presentation, select
(a) File_Outline to Presentation (b) File_Presentation
(c) File_Send_Prsentation (d) File_Send_Outline to Presentation
32. The keyboard shortcut used to switch over from one software window to another window is
(a) Alt + Tab (b) Shift + Tab (c) Tab (d) Ctrl + Tab
33. DDE means
(a) Dynamic Data Exchange (b) Dynamic Data Exchange
(c) Dynamic Data Enrichment (d) Dynamic Data Environment
34. The Paste Special menu is available under the menu
(a) Insert (b) File (c) Edit (d) View
35. A row in a StarOffice Base table represents a _ ___ ___ _.
(a) File (b) Structure (c) Field (d) Record
36. In which database, records are organized in a tree like structure?
(a) Relational (b) Network (c) Hierarchical (d) Object oriented
37. Which is the defined screen to view data from a table or a query?
(a) Report (b) Form (c) Filter (d) Query
38. Which one of the following is a type of query?
(a) Table (b) Filter (c) Report (d) File
39. Which is the most prevalent database in today’s business organizations?
(a) Flat-File (b) Network (c) Relational (d) Hierarchical
40. Which of the following icons is used to remove the filter?
(a) Filter (b) Remove Filter (c) Remove Filter / Sort (d) Sort
41. Spreadsheet is an example for
(a) Flat-file (b) Network (c) Relational (d) Object Oriented
42. Which is used to browse through selected records to meet a set of criteria?
(a) Searching (b) Filter (c) Query (d) Sorting
43. Which database is very similar to hierarchical structure?
(a) Flat-file (b) Object-oriented (c) Relational (d) Network
44. Filter used with a condition is cal led
(a) Default Filter (Standard Filter) (b) Conditioned Filter (c) AutoFilter (d) Unconditioned Filter
45. Which one of the following can be saved for later use?
(a) Questions (b) Filters (c) Queries (d) Filters and Queries
46. Users can define their own more sophisticated data types are called as
(a) Primitive (b) System defined (c) Built-in (d) User-defined
47. Records that are organized in parent-child type relationship is
(a) Hierarchical (b) Flat File (c) Network (d) Relational
48. Which of the following limits the information on the screen of database?
(a) Viewing (b) Arranging (c) Sorting (d) Filtering
(a) Datus (b) Datum (c) Datem (d) Datas
2. A database is a repository of collections of related
(a) Row (b) Table (c) Data (d) Column
3. Which of the following is used to arrange data in some order?
(a) Sorting (b) Form (c) Query (d) Filter
4. How many field types are there in Star Office Base?
(a) 11 (b) 20 (c) 13 (d) 14
5. The entire collection of related data in one table is referred to as
(a) Query (b) File (c) Field (d) Record
6. Which key uniquely identifies a record in a database table?
(a) F1 key (b) Primary key (c) F5 key (d) Secondary key
7. Editing the data includes
(a) Deleting a record (b) Changing the format of the database
(c) All the other three choices (d) Appending a record
8. Which database file consists of a single data table?
(a) Relational (b) Flat-File (c) Network (d) Hierarchical
9. Which is a process of joining data from two table s of different databases?
(a) Filtering (b) Searching (c) Merging (d) Sorting
10. To edit a record, we have to select the record by clicking on
(a) Record pointer (b) Record button (c) Tab key (d) Record key
11. Process of performing correction on the existing data is called as
(a) Filtering (b) Editing (c) Searching (d) Sorting
12. Printed information that is assembled by gathering data is cal
(a) Table (b) Form (c) Query (d) Report
13. By clicking on the Delete Rows option the selected record will
(a) Appended (b) Changed (c) Deleted (d) Edited
14. Sorting on more than one field of a table at the same time is called
(a) Multi Sorting (b) Multiple sorting (c) Searching (d) Sorting
15. DBMS is an acronym for
(a) Data Base Management System (b) Data Base Maintaining System
(c) Data Binary Management System (d) Data Base Manipulating System
16. Which is simply a screen that displays fields of a record in a well spaced out manner?
(a) Filter (b) Table (c) Query (d) Form
17. In How many ways the Manipulation of database can be done?
(a) 7 (b) 6 (c) 10 (d) 8
18. Standard Filter is also called as
(a) Conditioned Filter (b) Complete Filter (c) Default Filter (d) AutoFilter
19. The process used to select a desired specific data from a database is
(a) Filtering (b) Sorting (c) Merging (d) Searching
20. The shortcut key used for saving a table in StarOffice Base is
(a) Ctrl + F (b) Ctrl + A (c) Ctrl + E (d) Ctrl + S
21. A Database is a collection of
(a) Fields (b) Columns (c) Rows (d) Tables
22. A repository of collections of related data or facts
(a) Program (b) Database (c) Data (d) Information
23. SQL stands for
(a) Standard Query Link (b) Structured Query Language
(c) Standard Query Language (d) Structured Query Link
24. The accurate length of decimal digits in a s ingle precision number is
(a) 7 (b) 14 (c) 13 (d) 8
25. Sorting is a process of
(a) Joining the data (b) Performing corrections
(c) Arranging the data (d) Selecting a desired specific data
26. Which one of the following databases is very powerful?
(a) Relational (b) Hierarchical (c) Network (d) Flat-File
27. Which command is used to create a new database in StarOffice Base?
(a) New_File_Database (b) File_New_Table (c) New_Database (d) File_New_Database
28. The collection of Tables, Queries, Forms and Reports are generally referred to
(a) Multimedia (b) Document (c) Database (d) Spreadsheet
29. What are the two types of report in StarOffice Base?
(a) Static and Dual (b) Static and Standard (c) Standard and Dynamic (d) Static and Dynamic
30. In case of double precision, decimal values are accurate upto the length of
(a) 8 Places (b) 6 Places (c) 14 Places (d) 7 Places
31. To send text outline into presentation, select
(a) File_Outline to Presentation (b) File_Presentation
(c) File_Send_Prsentation (d) File_Send_Outline to Presentation
32. The keyboard shortcut used to switch over from one software window to another window is
(a) Alt + Tab (b) Shift + Tab (c) Tab (d) Ctrl + Tab
33. DDE means
(a) Dynamic Data Exchange (b) Dynamic Data Exchange
(c) Dynamic Data Enrichment (d) Dynamic Data Environment
34. The Paste Special menu is available under the menu
(a) Insert (b) File (c) Edit (d) View
35. A row in a StarOffice Base table represents a _ ___ ___ _.
(a) File (b) Structure (c) Field (d) Record
36. In which database, records are organized in a tree like structure?
(a) Relational (b) Network (c) Hierarchical (d) Object oriented
37. Which is the defined screen to view data from a table or a query?
(a) Report (b) Form (c) Filter (d) Query
38. Which one of the following is a type of query?
(a) Table (b) Filter (c) Report (d) File
39. Which is the most prevalent database in today’s business organizations?
(a) Flat-File (b) Network (c) Relational (d) Hierarchical
40. Which of the following icons is used to remove the filter?
(a) Filter (b) Remove Filter (c) Remove Filter / Sort (d) Sort
41. Spreadsheet is an example for
(a) Flat-file (b) Network (c) Relational (d) Object Oriented
42. Which is used to browse through selected records to meet a set of criteria?
(a) Searching (b) Filter (c) Query (d) Sorting
43. Which database is very similar to hierarchical structure?
(a) Flat-file (b) Object-oriented (c) Relational (d) Network
44. Filter used with a condition is cal led
(a) Default Filter (Standard Filter) (b) Conditioned Filter (c) AutoFilter (d) Unconditioned Filter
45. Which one of the following can be saved for later use?
(a) Questions (b) Filters (c) Queries (d) Filters and Queries
46. Users can define their own more sophisticated data types are called as
(a) Primitive (b) System defined (c) Built-in (d) User-defined
47. Records that are organized in parent-child type relationship is
(a) Hierarchical (b) Flat File (c) Network (d) Relational
48. Which of the following limits the information on the screen of database?
(a) Viewing (b) Arranging (c) Sorting (d) Filtering
49. Based on the conceptual structures, the Star Office Base databases are classified into
(a) 7 (b) 5 (c) 2 (d) 8
50. How many options are there in the pane of StarOffice Base screen?
(a) 3 (b) 4 (c) 5 (d) 2
51. In StarOffice Base, each table column represents a
(a) Field (b) Record (c) Cell (d) File
52. Which database defines data characteristics, attributes, and procedures as complex objects?
(a) Relational Database (b) Object Oriented Database
(c) Flat-File Database (d) Hierarchical Database
53. In which database, one record type can be related to any number of other record types?
(a) Hierarchial (b) Relational (c) Flat-file (d) Network
54. Which of the following options is used to insert the field names of the database table as headings for each of the text table columns?
(a) Create column name (b) Create row only (c) Insert column name (d) Apply column name
55. Which of the following options is used to insert an empty heading line into the text table?
(a) Create row only (b) Create row name (c) Create empty row (d) Apply column name
56. Which dialog box is use d to select the option DDE link?
(a) Paste (b) Paste Data (c) Paste Link (d) Paste Special
57. Which of the following features is for displaying and browsing a selected list or subset of records from a table?
(a) Searching (b) Sorting (c) Filtering (d) Merging
58. Which database represents different approach for the data?
(a) Network database (b) Hierarchical database
(a) 7 (b) 5 (c) 2 (d) 8
50. How many options are there in the pane of StarOffice Base screen?
(a) 3 (b) 4 (c) 5 (d) 2
51. In StarOffice Base, each table column represents a
(a) Field (b) Record (c) Cell (d) File
52. Which database defines data characteristics, attributes, and procedures as complex objects?
(a) Relational Database (b) Object Oriented Database
(c) Flat-File Database (d) Hierarchical Database
53. In which database, one record type can be related to any number of other record types?
(a) Hierarchial (b) Relational (c) Flat-file (d) Network
54. Which of the following options is used to insert the field names of the database table as headings for each of the text table columns?
(a) Create column name (b) Create row only (c) Insert column name (d) Apply column name
55. Which of the following options is used to insert an empty heading line into the text table?
(a) Create row only (b) Create row name (c) Create empty row (d) Apply column name
56. Which dialog box is use d to select the option DDE link?
(a) Paste (b) Paste Data (c) Paste Link (d) Paste Special
57. Which of the following features is for displaying and browsing a selected list or subset of records from a table?
(a) Searching (b) Sorting (c) Filtering (d) Merging
58. Which database represents different approach for the data?
(a) Network database (b) Hierarchical database
(c) Object oriented database (d) Relational database
59. Which option of form designing is similar to creating a query using AutoPilot option?
(a) Default Filter (b) Remove Filter (c) AutoFilter (d) Auto Pilot
60. The language designed specifically for communicating with a database is
(a) PASCAL (b) SQL (c) OQL (d) BASIC
59. Which option of form designing is similar to creating a query using AutoPilot option?
(a) Default Filter (b) Remove Filter (c) AutoFilter (d) Auto Pilot
60. The language designed specifically for communicating with a database is
(a) PASCAL (b) SQL (c) OQL (d) BASIC
61. Entering new record at the end of the table is referred as
(a) Inserting a record (b) Changing a record (c) Creating a record (d) Appending a record
62. Multiple reports can be created and stored f or
(a) A table (b) A query (c) A table or a query (d) A filter
63. Which of the following is displayed in the lower part of the Table Design window?
(a) Field Properties pane (b) File Properties pane (c) Field pane (d) Properties pane
64. The filter used to display only the records, which match the value of the current field is
(a) Inserting a record (b) Changing a record (c) Creating a record (d) Appending a record
62. Multiple reports can be created and stored f or
(a) A table (b) A query (c) A table or a query (d) A filter
63. Which of the following is displayed in the lower part of the Table Design window?
(a) Field Properties pane (b) File Properties pane (c) Field pane (d) Properties pane
64. The filter used to display only the records, which match the value of the current field is
(a) Limiting Filter (b) Default Filter (c) Auto Filter (d) Query Filter
65. Which database concept is used to assemble information from data?
(a) Report (b) Table (c) DBMS (d) Query
66. What are user- constructed statements?
(a) Reports (b) Filters (c) Queries (d) Forms
67. Which data type can be integer, float, double precision, date, time, etc.,?
(a) User-defined (b) Non-numeric (c) Information (d) Numeric
68. Which of the following database structures were primarily used on Mainf rame computers?
(a) Relational (b) Flat-file (c) Hierarchical (d) Object Oriented
69. Which one of the following statements is incorrect?
(a) SQL is a structured query language (b) Collection of related fields is called a record
(c) StarOffice Base is a Spreadsheet software (d) Merging is a process of joining data
70. The option used to specify the maxi mum characters can be entered in a StarOffice Base field is
(a) Entry required (b) Format Example (c) Length (d) Default Value
71. Character, Number or Boolean are
(a) User-defined data types (b) Primitive data types (c) Data types (d) Information
72. The field type that is not allowed by StarOffice Base is
(a) Image (b) Project (c) Text (d) Binary Field
73. In StarOffice Base, Integer and Float data types are called as
(a) Primary data types (b) Primitive data types
65. Which database concept is used to assemble information from data?
(a) Report (b) Table (c) DBMS (d) Query
66. What are user- constructed statements?
(a) Reports (b) Filters (c) Queries (d) Forms
67. Which data type can be integer, float, double precision, date, time, etc.,?
(a) User-defined (b) Non-numeric (c) Information (d) Numeric
68. Which of the following database structures were primarily used on Mainf rame computers?
(a) Relational (b) Flat-file (c) Hierarchical (d) Object Oriented
69. Which one of the following statements is incorrect?
(a) SQL is a structured query language (b) Collection of related fields is called a record
(c) StarOffice Base is a Spreadsheet software (d) Merging is a process of joining data
70. The option used to specify the maxi mum characters can be entered in a StarOffice Base field is
(a) Entry required (b) Format Example (c) Length (d) Default Value
71. Character, Number or Boolean are
(a) User-defined data types (b) Primitive data types (c) Data types (d) Information
72. The field type that is not allowed by StarOffice Base is
(a) Image (b) Project (c) Text (d) Binary Field
73. In StarOffice Base, Integer and Float data types are called as
(a) Primary data types (b) Primitive data types
(c) Secondary data types (d) Computer data types
74. In database creation, which option of field property specifies the user should enter a value for that field?
(a) Entry Required (b) Default value (c) Format (d) Length
75. In StarOffice Base, field alignment is a par t of
(a) Query design (b) Form design (c) Insert_Table Design
76. The menu for creating a new table in Star Office Base is
(a) Tabel_Table Design (b) New_Table_Table Design
(c) Table design (d) Report design (d) New_Table
77. Which of the following is a program, or collection of programs that allows any number of users to access data?
(a) Table (b) Query (c) Report (d) DBMS
78 Which one of the following are special views of the data in a table?
(a) Reports (b) Tables (c) Queries (d) Forms
79. How many steps are available in Query wizard window?
(a) 2 (b) 4 (c) 8 (d) 6
80. The common fields of two or more tables of relational database is called as
(a) Primary Key (b) Cell (c) Key (d) Row
81. How many steps are available in Report wizard window?
(a) 4 (b) 8 (c) 6 (d) 2
82. Which of the following is not a valid field type in Star Office Base?
(a) Memo (b) Picture (c) Image (d) Date
83. To update data automatically in a text document which is copied from a spreadsheet, the option used is
(a) DDE link (b) RTF (c) GDI metafile (d) HTML
84. To transfer heading together with its accompanying paragraphs to presentation, select
(a) File_Send_AutoAbstract to Presentation (b) File_Send_Outline to Presentation
(c) File_Send_AutoHeading to Presentation (d) File_Send_Autoformat to Presentation86. To insert the Spreadsheet Calc cell in StarOfficeWriter, select
(a) Edit_Paste Special (b) Edit_Paste (c) Format_Paste (d) Tools_Paste Special
87. Which of the following is not a step in data processing?
(a) Validation (b) Verification (c) Collection (d) Computation
88. Which involves data collection, verification, validation and report generation?
(a) Data processing (b) Table (c) Database (d) Data
89. In which Computers Hierarchical Database were used?
(a) Super (b) Micro (c) Mainframe (d) Mini
90. Queries are_________ statements.
(a) user-defined (b) predefined (c) structural (d) user-constructed
91. The key combination used to save the database table is
(a) Ctrl + V (b) Ctrl + A (c) Ctrl + C (d) Ctrl + S
92. Which of the following is not a step in data processing?
(a) Computation (b) Validation (c) Collection (d) Verification
93. To sort the records in the ascending order, select the field and click on
(a) Sort icon (b) Sort Ascending icon (c) Ascending icon (d) Sort / Filter icon
94. Which icon is pressed to display the records in original order after sorting?
(a) Delete Sort/Filter (b) Exclude Filter/Sort (c) Remove Filter/Sorter (d) Delete Filter/Sort
95. The hierarchical database structures were primarily used for
(a) micro computers (b) super computers (c) mainframe computers (d) mini computers
96. A filter is also type of
(a) Form (b) Report (c) Query (d) Table
97. To copy the selected cell range in text document, which option in the paste special dialog box has to be selected?
(a) Link (b) OLE link (c) DDE link (d) Paste
98. A set of processed data is called
(a) Procedure (b) Information (c) Database (d) Datum
99. In StarOffice Base, which of the following icons is used to display the records in the original order?
(a) Standard Filter icon (b) Remove Filter/Sort icon
(c) Auto Filter icon (d) Default Filter icon
100. How many general categories are there in DBMS?
(a) 3 (b) 2 (c) 6 (d) 4
74. In database creation, which option of field property specifies the user should enter a value for that field?
(a) Entry Required (b) Default value (c) Format (d) Length
75. In StarOffice Base, field alignment is a par t of
(a) Query design (b) Form design (c) Insert_Table Design
76. The menu for creating a new table in Star Office Base is
(a) Tabel_Table Design (b) New_Table_Table Design
(c) Table design (d) Report design (d) New_Table
77. Which of the following is a program, or collection of programs that allows any number of users to access data?
(a) Table (b) Query (c) Report (d) DBMS
78 Which one of the following are special views of the data in a table?
(a) Reports (b) Tables (c) Queries (d) Forms
79. How many steps are available in Query wizard window?
(a) 2 (b) 4 (c) 8 (d) 6
80. The common fields of two or more tables of relational database is called as
(a) Primary Key (b) Cell (c) Key (d) Row
81. How many steps are available in Report wizard window?
(a) 4 (b) 8 (c) 6 (d) 2
82. Which of the following is not a valid field type in Star Office Base?
(a) Memo (b) Picture (c) Image (d) Date
83. To update data automatically in a text document which is copied from a spreadsheet, the option used is
(a) DDE link (b) RTF (c) GDI metafile (d) HTML
84. To transfer heading together with its accompanying paragraphs to presentation, select
(a) File_Send_AutoAbstract to Presentation (b) File_Send_Outline to Presentation
(c) File_Send_AutoHeading to Presentation (d) File_Send_Autoformat to Presentation86. To insert the Spreadsheet Calc cell in StarOfficeWriter, select
(a) Edit_Paste Special (b) Edit_Paste (c) Format_Paste (d) Tools_Paste Special
87. Which of the following is not a step in data processing?
(a) Validation (b) Verification (c) Collection (d) Computation
88. Which involves data collection, verification, validation and report generation?
(a) Data processing (b) Table (c) Database (d) Data
89. In which Computers Hierarchical Database were used?
(a) Super (b) Micro (c) Mainframe (d) Mini
90. Queries are_________ statements.
(a) user-defined (b) predefined (c) structural (d) user-constructed
91. The key combination used to save the database table is
(a) Ctrl + V (b) Ctrl + A (c) Ctrl + C (d) Ctrl + S
92. Which of the following is not a step in data processing?
(a) Computation (b) Validation (c) Collection (d) Verification
93. To sort the records in the ascending order, select the field and click on
(a) Sort icon (b) Sort Ascending icon (c) Ascending icon (d) Sort / Filter icon
94. Which icon is pressed to display the records in original order after sorting?
(a) Delete Sort/Filter (b) Exclude Filter/Sort (c) Remove Filter/Sorter (d) Delete Filter/Sort
95. The hierarchical database structures were primarily used for
(a) micro computers (b) super computers (c) mainframe computers (d) mini computers
96. A filter is also type of
(a) Form (b) Report (c) Query (d) Table
97. To copy the selected cell range in text document, which option in the paste special dialog box has to be selected?
(a) Link (b) OLE link (c) DDE link (d) Paste
98. A set of processed data is called
(a) Procedure (b) Information (c) Database (d) Datum
99. In StarOffice Base, which of the following icons is used to display the records in the original order?
(a) Standard Filter icon (b) Remove Filter/Sort icon
(c) Auto Filter icon (d) Default Filter icon
100. How many general categories are there in DBMS?
(a) 3 (b) 2 (c) 6 (d) 4
No comments:
Post a Comment