Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
In a Microsoft Access table, what is one complete row containing all information about a single item or entity called?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• In an Access table, each row is called a record.
• A record contains related field values describing one item, such as one employee or one product.
• Columns are fields, while rows are records.
• A record contains related field values describing one item, such as one employee or one product.
• Columns are fields, while rows are records.
వివరణ:
Question 2
ప్రశ్న 2
In an Access Employees table, columns named EmployeeID, Name, Department and Salary are examples of what?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A field represents one particular item or category of information about the records in a table.
• EmployeeID, Name, Department and Salary are therefore separate fields.
• Each record contains a value, where applicable, for these fields.
• EmployeeID, Name, Department and Salary are therefore separate fields.
• Each record contains a value, where applicable, for these fields.
వివరణ:
Question 3
ప్రశ్న 3
Which statement correctly describes a primary key in an Access table?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A primary key uniquely identifies each record in a table.
• Access requires every record to have a value in its primary-key field or field combination, and primary-key values must be unique.
• A well-chosen primary key enables Access to distinguish one record reliably from all others.
• Access requires every record to have a value in its primary-key field or field combination, and primary-key values must be unique.
• A well-chosen primary key enables Access to distinguish one record reliably from all others.
వివరణ:
Question 4
ప్రశ్న 4
When a new table is created in Datasheet view in current Microsoft Access, what does Access normally create automatically as its primary key?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access normally creates an ID field automatically when a new table is created in Datasheet view.
• That ID field uses the AutoNumber data type and is assigned as the table's primary key.
• AutoNumber values provide a convenient unique identifier for individual records.
• That ID field uses the AutoNumber data type and is assigned as the table's primary key.
• AutoNumber values provide a convenient unique identifier for individual records.
వివరణ:
Question 5
ప్రశ్న 5
Which Access data type is appropriate for storing relatively short alphanumeric entries such as a person's name, code or address component, with a maximum field size of 255 characters?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Short Text is intended for text or combinations of text and numbers that do not require more than 255 characters.
• Its Field Size property can be set from 1 through 255 characters.
• Longer blocks of textual information are better suited to the Long Text data type.
• Its Field Size property can be set from 1 through 255 characters.
• Longer blocks of textual information are better suited to the Long Text data type.
వివరణ:
Question 6
ప్రశ్న 6
A table needs a field for detailed remarks that may contain considerably more than 255 characters. Which Access data type is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Long Text is designed for long blocks of textual information exceeding the normal Short Text limit.
• It is suitable for descriptions, comments, narratives and detailed remarks.
• Short Text is intended for entries of up to 255 characters.
• It is suitable for descriptions, comments, narratives and detailed remarks.
• Short Text is intended for entries of up to 255 characters.
వివరణ:
Question 7
ప్రశ్న 7
A field named Quantity must store numerical values that will later be used in arithmetic calculations. Which Access data type is normally appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Number data type stores numeric values that may be used in mathematical calculations.
• Access provides different Number Field Size settings depending on the required range and precision.
• Text-oriented data types are not the normal choice when the values must participate in numerical calculations.
• Access provides different Number Field Size settings depending on the required range and precision.
• Text-oriented data types are not the normal choice when the values must participate in numerical calculations.
వివరణ:
Question 8
ప్రశ్న 8
Which Access data type should normally be chosen for a field that stores an employee's DateOfBirth?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Date/Time is designed for storing valid date and time information.
• Date values can then be sorted, filtered and used in date-related calculations appropriately.
• Storing dates in a dedicated Date/Time field is preferable to treating them merely as ordinary text.
• Date values can then be sorted, filtered and used in date-related calculations appropriately.
• Storing dates in a dedicated Date/Time field is preferable to treating them merely as ordinary text.
వివరణ:
Question 9
ప్రశ్న 9
A table contains a field named AmountPaid that stores monetary amounts. Which Access data type is specifically intended for such values?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Currency is specifically designed for monetary data.
• Access stores Currency values with four decimal places of precision.
• It is therefore an appropriate choice for monetary fields such as fees, prices and amounts paid.
• Access stores Currency values with four decimal places of precision.
• It is therefore an appropriate choice for monetary fields such as fees, prices and amounts paid.
వివరణ:
Question 10
ప్రశ్న 10
Which Access data type is most appropriate for a field named IsVerified that needs to store only a Boolean state such as Yes/No?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Yes/No data type stores Boolean information representing two logical states.
• Depending on formatting, such a value can be displayed as Yes/No, True/False or On/Off.
• It is well suited to fields such as IsVerified, IsActive or Completed.
• Depending on formatting, such a value can be displayed as Yes/No, True/False or On/Off.
• It is well suited to fields such as IsVerified, IsActive or Completed.
వివరణ:
Question 11
ప్రశ్న 11
Which Access data type automatically generates a value for a field when each new record is first saved and is therefore commonly used for unique record identifiers?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• AutoNumber automatically generates a value for each new record.
• This makes it useful for creating artificial identifiers when no suitable natural primary key exists.
• Access commonly uses an AutoNumber ID field as a primary key in newly created tables.
• This makes it useful for creating artificial identifiers when no suitable natural primary key exists.
• Access commonly uses an AutoNumber ID field as a primary key in newly created tables.
వివరణ:
Question 12
ప్రశ్న 12
An Evidence table must allow supported files such as photographs, documents or spreadsheets to be associated with individual records. Which Access data type is designed for this purpose?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Attachment data type is designed to associate supported files with database records.
• Attachments can include files such as pictures, documents, spreadsheets and charts.
• An Attachment field can support multiple attachments for a record subject to the database's storage limits.
• Attachments can include files such as pictures, documents, spreadsheets and charts.
• An Attachment field can support multiple attachments for a record subject to the database's storage limits.
వివరణ:
Question 13
ప్రశ్న 13
Which Access data type is intended for storing an address that can function as a link to a web page, file, network location or similar resource?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Hyperlink is intended for storing hyperlink addresses.
• Such links can point to resources on the Internet, an intranet, a local network or the local computer.
• A Hyperlink field is therefore different from an ordinary numeric or Boolean field.
• Such links can point to resources on the Internet, an intranet, a local network or the local computer.
• A Hyperlink field is therefore different from an ordinary numeric or Boolean field.
వివరణ:
Question 14
ప్రశ్న 14
An Access table contains Quantity and UnitPrice fields. A new field must display the result of an expression based on values from other fields in the same table. Which data type is designed for this?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Calculated data type stores a result produced by an expression.
• Its calculation can refer to other fields in the same table.
• It is therefore suitable for a derived value such as Quantity multiplied by UnitPrice.
• Its calculation can refer to other fields in the same table.
• It is therefore suitable for a derived value such as Quantity multiplied by UnitPrice.
వివరణ:
Question 15
ప్రశ్న 15
In Access Table Design view, 'Lookup Wizard' appears as a choice in the Data Type column. Which statement about it is technically correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Lookup Wizard is an entry that starts a wizard for defining a lookup field.
• Microsoft specifically notes that Lookup Wizard is not itself a data type.
• The resulting lookup field's underlying data type can be Short Text or Number depending on how the lookup is configured.
• Microsoft specifically notes that Lookup Wizard is not itself a data type.
• The resulting lookup field's underlying data type can be Short Text or Number depending on how the lookup is configured.
వివరణ:
Question 16
ప్రశ్న 16
Which Access field property is used to control the maximum number of characters permitted in a Short Text field?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Field Size controls the permitted size of a Short Text field.
• For Short Text, the property can specify a limit from 1 through 255 characters.
• Field Size also has an important role for Number fields, where it determines the numeric storage subtype.
• For Short Text, the property can specify a limit from 1 through 255 characters.
• Field Size also has an important role for Number fields, where it determines the numeric storage subtype.
వివరణ:
Question 17
ప్రశ్న 17
A database designer wants to ensure that a value must be supplied in the EmployeeID field and that the field cannot simply be left Null. Which field property should be set to Yes?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Setting Required to Yes requires a value to be entered in the field.
• The field cannot be left Null when a record requiring that field is saved.
• Required controls whether data must be supplied; Format merely controls how data is displayed.
• The field cannot be left Null when a record requiring that field is saved.
• Required controls whether data must be supplied; Format merely controls how data is displayed.
వివరణ:
Question 18
ప్రశ్న 18
A Marks field must accept only values from 0 through 100. Which Access field property is most directly used to specify an expression that valid entries must satisfy?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Validation Rule contains an expression that entered values must satisfy.
• A rule such as >=0 And <=100 can restrict a Marks field to the required range.
• Validation Text can be used separately to display a helpful message when an entered value violates that rule.
• A rule such as >=0 And <=100 can restrict a Marks field to the required range.
• Validation Text can be used separately to display a helpful message when an entered value violates that rule.
వివరణ:
Question 19
ప్రశ్న 19
A field named RegistrationNumber must be indexed and duplicate registration numbers must not be allowed. Which Indexed property setting directly meets this requirement?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Indexed = Yes (No Duplicates) creates a unique index on the field.
• The index can improve relevant searching, sorting and grouping operations while preventing duplicate values in that field.
• Yes (Duplicates OK) creates a non-unique index and therefore would not satisfy the uniqueness requirement.
• The index can improve relevant searching, sorting and grouping operations while preventing duplicate values in that field.
• Yes (Duplicates OK) creates a non-unique index and therefore would not satisfy the uniqueness requirement.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Primary Key
(b) Required
(c) Validation Rule
(d) Default Value
List II
1. Automatically supplies a specified value when a new record is created
2. Specifies an expression that entered data must satisfy
3. Uniquely identifies each record in a table
4. Requires a value to be entered rather than allowing the field to remain Null
Choose the correct matching code.
List I
(a) Primary Key
(b) Required
(c) Validation Rule
(d) Default Value
List II
1. Automatically supplies a specified value when a new record is created
2. Specifies an expression that entered data must satisfy
3. Uniquely identifies each record in a table
4. Requires a value to be entered rather than allowing the field to remain Null
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A Primary Key uniquely identifies a record, giving (a)-3.
• Required forces a field to contain a value, giving (b)-4, while Validation Rule specifies a condition that entered values must satisfy, giving (c)-2.
• Default Value automatically supplies the specified initial value for a field in a new record, giving (d)-1.
• Required forces a field to contain a value, giving (b)-4, while Validation Rule specifies a condition that entered values must satisfy, giving (c)-2.
• Default Value automatically supplies the specified initial value for a field in a new record, giving (d)-1.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: C. Record సమాధానం: C.
-
Question 2 ప్రశ్న 2Answer: A. Fields సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: D. It uniquely identifies each record and its key value cannot be Null. సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. An AutoNumber field named ID సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. Short Text సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: C. Long Text సమాధానం: C.
-
Question 7 ప్రశ్న 7Answer: A. Number సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: D. Date/Time సమాధానం: D.
-
Question 9 ప్రశ్న 9Answer: C. Currency సమాధానం: C.
-
Question 10 ప్రశ్న 10Answer: B. Yes/No సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: A. AutoNumber సమాధానం: A.
-
Question 12 ప్రశ్న 12Answer: D. Attachment సమాధానం: D.
-
Question 13 ప్రశ్న 13Answer: B. Hyperlink సమాధానం: B.
-
Question 14 ప్రశ్న 14Answer: D. Calculated సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: C. It is a wizard that helps create a lookup field; it is not itself an underlying Access data type. సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: A. Field Size సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: D. Required సమాధానం: D.
-
Question 18 ప్రశ్న 18Answer: C. Validation Rule సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: B. Yes (No Duplicates) సమాధానం: B.
-
Question 20 ప్రశ్న 20Answer: A. (a)-3, (b)-4, (c)-2, (d)-1 సమాధానం: A.