Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
1
What is the primary purpose of the Microsoft Access software application?
Answer:
Data Base
Microsoft Access is a relational database management system (RDBMS) developed by Microsoft.
2
In Microsoft Access, how many primary keys can be assigned to a single database table?
Answer:
One
In relational database design, specifically within Microsoft Access, a table is restricted to having exactly one primary key.
3
Which of the following components are considered standard objects within a Microsoft Access database?
Answer:
All the above
Microsoft Access databases are built using several distinct object types.
4
Which desktop database management application is included in the Microsoft Office suite?
Answer:
MS Access
Microsoft Access is the relational database management system included in the Microsoft Office suite.
5
To organize a database so that all records for 'white cats' are grouped together, which sorting strategy should be applied?
Answer:
Pet Type, then Color
To group specific records effectively, you must sort by the primary category first, followed by the specific attribute.
6
Which button is used to modify, add, or remove records within a Data Source?
Answer:
‘Edit Data Source’ button
In various database and mail merge applications, the 'Edit Data Source' button provides the interface necessary to manage the underlying data.
7
Which field type will you select when creating a new table if you require to enter long text in that field?
Answer:
Currency
The source answer is option C (Currency). Review the stem and options, then update the correct answer in Question Bank if the source key is wrong.
8
In Microsoft Access, which data type is best suited for storing large amounts of text and numeric data?
Answer:
Memo
In older versions of Microsoft Access, the Memo data type was specifically designed to store long blocks of text and numbers that exceeded the character limit of the standard Text data type.
9
Which of the following is not a valid data type in Microsoft Access?
Answer:
' Picture
In Microsoft Access, data types are used to define the kind of information stored in a field. Valid data types include Memo (Long Text), Currency, and AutoNumber.
10
The Command Center Of Access File That Appears When You Create Or Open The Ms Access Database File.
Answer:
Database Window”
The source answer is option A (Database Window”). Review the stem and options, then update the correct answer in Question Bank if the source key is wrong.