Preparing for exams like the Odisha Sub-Ordinate Staff Selection Commission (OSSSC) Accountant and Data Entry Operator (DEO) requires a solid grasp of Computer fundamental skills. Computer fundamental is a crucial section in these exams, testing candidates on various aspects such as grammar, vocabulary, comprehension, and more. To aid in your preparation, here are the top 30 Computer fundamental Multiple Choice Questions (MCQs) tailored for OSSSC Accountant and DEO exams.
Top 30 Computer fundamental MCQS For OSSSC Accountant, DEO
Mastering Computer fundamental skills is essential for success in OSSSC Accountant and DEO exams. Regular practice with MCQs like the ones provided above will not only enhance your understanding but also improve your confidence in tackling the Computer fundamental section of the exam. Keep practicing and best of luck!
- ROLLBACK in a database is ________ statement?
A) TCL
B) DCL
C) DML
D) DDL
Answer: A) TCL
Explanation:
TCL (Transaction Control Language) statement. ROLLBACK is a TCL statement that is used to undo changes made in a transaction and to restore the database to its previous state before the transaction started. TCL statements are used to control the changes made by transactions in a database. The other TCL statements are COMMIT and SAVEPOINT. - Unlike filters queries can be saved as in a database?
A) objects
B) filters
C) database
D) Any of the above
Answer: A) objects
Explanation:
Queries can be saved in a database, unlike filters that are used to temporarily sort, filter or modify data. Therefore, the correct option is (a) objects. - Dr. E.F. Codd represented ______ rules that a database must obey if it has to be considered truly relational?
A) 10
B) 8
C) 12
D) 6
Answer: C) 12
Explanation:
Dr. E.F. Codd represented 12 rules that a database must obey if it has to be considered truly relational. Therefore, the correct option is (c) 12. - Periodically adding, changing and deleting file records is called file?
A) updating
B) upgrading
C) restructuring
D) renewing
Answer: A) updating
Explanation:
Periodically adding, changing and deleting file records is called file updating. - A tuple is a?
A) column of a table
B) two-dimensional table
C) row of a table
D) key of a table
Answer: C) row of a table
Explanation:
The correct answer is (c) row of a table. In database management systems, a tuple is a row of a table that represents a single record or instance of an entity. Each tuple contains a set of attributes, which are the columns or fields of the table that describe the characteristics of the entity being represented. - A collection of interrelated records is called a?
A) management information system
B) spreadsheet
C) database
D) text file
Answer: C) database
Explanation:
The correct answer is (c) database. A collection of interrelated records is called a database. In database management systems, data is organized into one or more tables, with each table containing a collection of related records or data entities. The purpose of a database is to provide a structured and organized way to store, manage, and retrieve data, allowing users to easily access and manipulate the data for a variety of purposes. - __________ represents raw facts, whereas __________ is data made meaningful?
A) Information, reporting
B) Data, information
C) Information, bits
D) Records, bytes
Answer: B) Data, information
Explanation:
Data represents raw facts, whereas information is data made meaningful. - A collection of unprocessed items is ________?
A) information
B) data
C) memory
D) reports
Answer: B) data
Explanation:
A collection of unprocessed items is data. - The ability to find an individual item in a file immediately?
A) sequential access
B) file allocation table
C) direct access
D) directory
Answer: C) direct access
Explanation:
The ability to find an individual item in a file immediately is called direct access. Therefore, the correct option is (c) direct access. - External database is?
A) Database created in EXCEL
B) Database created using DBMS package
C) Database created in MS-Word
D) All of the above
Answer: B) Database created using DBMS package
Explanation:
An external database refers to a database that is created using a DBMS (Database Management System) package. Therefore, the correct option is (b) Database created using DBMS package. - Attributes can be defined for:
a) entity
b) switch board
c) macro
d) pages
Answer: a) entity - Forms that are used to organize business data into rows and columns are called:
a) transaction sheets
b) registers
c) business forms
d) spreadsheets
Answer: d) spreadsheets - Grouping and processing all of a firm’s transactions at one time is called:
a) a database management system
b) batch processing
c) a real-time system
d) an on-line system
Answer: b) batch processing - _____ provides total solutions to reduce data redundancy, inconsistency, dependence, and unauthorized access of data:
a) DBMS
b) Tables
c) Database
d) Protection passwords
Answer: a) DBMS - _____ is one reason for problems of data integrity:
a) Data availability constraints
b) Data inconsistency
c) Security constraints
d) Unauthorized access of data
Answer: b) Data inconsistency - A collection of conceptual tools for describing data, relationships, semantics, and constraints is referred to as:
a) ER model
b) Database
c) Data Model
d) DBMS
Answer: c) Data Model - The simultaneous execution of two or more instructions is called:
a) sequential access
b) reduced instruction set computing
c) multiprocessing
d) disk mirroring
Answer: c) multiprocessing - When data changes in multiple lists and all lists are not updated, this causes:
a) data redundancy
b) information overload
c) duplicate data
d) data inconsistency
Answer: d) data inconsistency - The software that is used to create text-based documents are referred to as:
a) DBMS
b) suites
c) spreadsheets
d) word processors
Answer: d) word processors - What refers to a set of characters of a particular design?
a) keyface
b) formation
c) calligraph
d) typeface
Answer: d) typeface - What is a data warehouse primarily organized around?
A) Contains numerous naming conventions and formats
B) Is organized around important subject areas
C) Contains only current data
D) Can be updated by end users
Answer: B - Which method of file organization arranges data records in a specified order according to a key field?
A) Direct access method
B) Queuing method
C) Predetermined method
D) Sequential access method
Answer: D - In computing, what is a field?
A) Records
B) Files
C) Characters
D) Cables
Answer: C - How are files typically organized on a computer?
A) Archives
B) Folders
C) Indexes
D) Lists
Answer: B - How do businesses commonly protect their databases?
A) Security guards are hired to watch the databases at all times.
B) Databases are protected by file swapping.
C) Databases are naturally protected.
D) Databases are kept physically and electronically secure.
Answer: D - Which best describes the batch method of input?
A) Data is processed as soon as it is input
B) Data is input at the time it is collected
C) Data is collected in the form of source documents, placed into groups, and then input to the computer
D) Source documents are not used
Answer: C - Which search method is conducted for a specific title, domain, URL, or host?
A) Keyword
B) Field
C) Boolean
D) Miscellaneous
Answer: B - What is used by public and private enterprises to publish and share financial information across all computer platforms and the Internet?
A) Extensible Markup Language (EML)
B) Extensible Business Reporting Language (XBRL)
C) Enterprise Application Integration (EAI)
D) Sales Force Automation (SFA) software
Answer: B - Which of the following are examples of input?
A) Control
B) Output
C) Processing
D) Input
Answer: D - Which is considered an intelligent CASE tool?
A) Toolkit
B) Methodology companion
C) Workbench
D) Upper CASe
Answer: C