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
61
In the Microsoft Access table design view, what is the primary function of the indicator buttons located in the first column?
Answer:
Both of above
The row selector column in Design View serves two main purposes: it displays a small arrow to indicate the currently selected row (the current row) and, if a primary key has been assigned to a field, it displays a key icon to denote that specific field's role.
62
Which of the following is not a standard method for creating a new table within Microsoft Access?
Answer:
Layout View
In Microsoft Access, tables can be created using Datasheet View, Design View, or by utilizing pre-built templates. Layout View is primarily used for designing forms and reports to adjust their appearance and layout, rather than for the structural creation of database tables.
63
Which of the following is not a standard data type supported by Microsoft Access?
Answer:
Picture
In Microsoft Access, data types define the kind of information a field can hold. While Memo (now Long Text), Currency, and AutoNumber are built-in data types, 'Picture' is not a native data type. Images are typically stored using the OLE Object data type or the Attachment data type.
64
What is the primary interface or command center that appears upon opening or creating a Microsoft Access database file?
Answer:
Database window
In traditional versions of Microsoft Access, the Database window serves as the central hub or command center. It provides an organized view of all database objects, such as tables, queries, forms, and reports, allowing users to manage and navigate the various components of their database project efficiently.
65
Which form layout displays multiple records simultaneously, with each record appearing in its own row within the window?
Answer:
Datasheet
The Datasheet view in Microsoft Access presents data in a grid format similar to a spreadsheet. It allows users to view multiple records at once, with each record occupying a single row and each field occupying a column, facilitating easy data entry and navigation.
66
Which of the following options represents a valid data type supported by Microsoft Access?
Answer:
All of the above
Microsoft Access supports a wide variety of data types to accommodate different kinds of information. Text, Number, and Date/Time are all fundamental data types used to define the nature of the data stored within a table field, ensuring proper formatting and calculation capabilities.
67
Which of the following Microsoft Access field data types occupies exactly 8 bytes of storage space?
Answer:
Date/Time
In Microsoft Access, the Date/Time data type is designed to store date and time values and is stored internally as an 8-byte floating-point number. This allows for precise calculation and sorting of temporal data within the database environment.
68
In Microsoft Access, which property should be configured to mask text input with asterisks during data entry?
Answer:
Input Mask
The Input Mask property in Microsoft Access is used to control the format of data entered into a field. By using specific characters, such as the password mask, you can ensure that characters typed into the field are displayed as asterisks, which is essential for protecting sensitive information like passwords during the data entry process.
69
Which Microsoft Access data type is best suited for storing extensive amounts of text and numerical data?
Answer:
Long Text
In modern versions of Microsoft Access, the Long Text data type is designed to store large amounts of alphanumeric data, replacing the older Memo data type. It is the appropriate choice when a field requires more than the 255-character limit imposed by the Short Text data type.
70
What is the maximum character limit for a standard Short Text field in Microsoft Access?
Answer:
255
In Microsoft Access, the Short Text data type (formerly known as Text) is designed for small amounts of data. It has a default and maximum limit of 255 characters per field. For longer text entries, the Long Text data type should be used instead.