Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Which statement correctly distinguishes data from information in the context of data processing?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data represents facts, observations or values before they have necessarily been interpreted for a particular purpose.
• Information results when data is processed, organized or placed in context so that it becomes meaningful and useful.
• The same stored values can serve as raw data for one operation and contribute to information after appropriate processing.
• Information results when data is processed, organized or placed in context so that it becomes meaningful and useful.
• The same stored values can serve as raw data for one operation and contribute to information after appropriate processing.
వివరణ:
Question 2
ప్రశ్న 2
Which of the following best defines a database?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A database is an organized collection of data related to a particular subject or purpose.
• Its organization supports operations such as storing, accessing, updating and retrieving required data.
• A database is distinct from the DBMS software that is used to manage the stored data.
• Its organization supports operations such as storing, accessing, updating and retrieving required data.
• A database is distinct from the DBMS software that is used to manage the stored data.
వివరణ:
Question 3
ప్రశ్న 3
A police station records the offence category of each of 60 complaints received during a day. After processing the entries, the system reports that 17 of the complaints belong to the property-offence category. Which item is information rather than merely raw data?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Individual complaint entries are data values recorded by the system.
• Counting and classifying those entries transforms the raw data into a meaningful result.
• The statement that 17 of 60 complaints belong to a specified category is therefore information derived from processing the data.
• Counting and classifying those entries transforms the raw data into a meaningful result.
• The statement that 17 of 60 complaints belong to a specified category is therefore information derived from processing the data.
వివరణ:
Question 4
ప్రశ్న 4
What is the primary role of a Database Management System (DBMS)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A DBMS is software that controls and facilitates the storage, organization and retrieval of database data.
• It provides an interface through which users and applications can work with the stored data.
• The DBMS is software; it is not itself the physical disk or a replacement for the operating system.
• It provides an interface through which users and applications can work with the stored data.
• The DBMS is software; it is not itself the physical disk or a replacement for the operating system.
వివరణ:
Question 5
ప్రశ్న 5
Which description most accurately represents a database system?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A database system is broader than the stored database alone.
• It commonly includes the database data, the DBMS that manages it and applications that interact with the data.
• Distinguishing a database from a DBMS and from the broader database system is an important terminology point.
• It commonly includes the database data, the DBMS that manages it and applications that interact with the data.
• Distinguishing a database from a DBMS and from the broader database system is an important terminology point.
వివరణ:
Question 6
ప్రశ్న 6
An office maintains separate customer files in the billing, service and dispatch sections. The same address is repeatedly stored in all three files, and corrections made in one file are often not made in the others. Which database benefit most directly addresses this problem?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Independent duplicate files can create redundant storage and inconsistent versions of the same fact.
• A properly managed database can reduce unnecessary duplication and provide better control over shared data.
• Database use does not imply that redundancy can never exist; the goal is to control unnecessary redundancy and improve consistency.
• A properly managed database can reduce unnecessary duplication and provide better control over shared data.
• Database use does not imply that redundancy can never exist; the goal is to control unnecessary redundancy and improve consistency.
వివరణ:
Question 7
ప్రశ్న 7
In database terminology, what is meant by data redundancy?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data redundancy refers to duplication of the same data in more than one place when that duplication is unnecessary or poorly controlled.
• Excessive redundancy can waste storage and increase the possibility of inconsistent values after updates.
• Some controlled redundancy may be deliberately used in particular systems, so redundancy should not be confused with simple data corruption.
• Excessive redundancy can waste storage and increase the possibility of inconsistent values after updates.
• Some controlled redundancy may be deliberately used in particular systems, so redundancy should not be confused with simple data corruption.
వివరణ:
Question 8
ప్రశ్న 8
A person's address is stored as 'Hyderabad' in one departmental file and 'Warangal' in another file that is supposed to represent the same current address. Which database problem is illustrated most directly?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data inconsistency occurs when different stored representations of what should be the same fact disagree with one another.
• Uncontrolled duplication can contribute to inconsistency when only some copies are updated.
• The problem described concerns conflicting values, not encryption, compression or sorting.
• Uncontrolled duplication can contribute to inconsistency when only some copies are updated.
• The problem described concerns conflicting values, not encryption, compression or sorting.
వివరణ:
Question 9
ప్రశ్న 9
Which database term means 'data about data', such as descriptions of field names, data types or database structures?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Metadata describes characteristics or structure of other data rather than representing the ordinary stored subject data itself.
• Examples can include field names, data types, lengths and structural definitions.
• Metadata helps a DBMS and its users understand how database data is organized.
• Examples can include field names, data types, lengths and structural definitions.
• Metadata helps a DBMS and its users understand how database data is organized.
వివరణ:
Question 10
ప్రశ్న 10
In basic database terminology, which description best represents a table?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A table organizes data in rows and columns and normally represents information about a particular subject or entity type.
• Rows are commonly referred to as records, while columns are commonly referred to as fields.
• Tables are fundamental structures in relational database systems.
• Rows are commonly referred to as records, while columns are commonly referred to as fields.
• Tables are fundamental structures in relational database systems.
వివరణ:
Question 11
ప్రశ్న 11
A STUDENT table contains Student_ID, Name, Date_of_Birth and Course. One row contains all these values for Student_ID 105. What does that complete row represent?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A record is a complete set of related field values describing one particular instance, such as one student.
• In a table, a record is normally represented by a row.
• Student_ID, Name and the other individual categories are fields, whereas their combined values for Student_ID 105 form the record.
• In a table, a record is normally represented by a row.
• Student_ID, Name and the other individual categories are fields, whereas their combined values for Student_ID 105 form the record.
వివరణ:
Question 12
ప్రశ్న 12
In an EMPLOYEE table, the column Employee_Name contains the name value for every employee record. Which database term describes Employee_Name?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A field represents one particular attribute or category of information about the subject represented by a table.
• In a tabular database representation, a field is normally associated with a column.
• Each employee record can therefore contain a different value in the Employee_Name field.
• In a tabular database representation, a field is normally associated with a column.
• Each employee record can therefore contain a different value in the Employee_Name field.
వివరణ:
Question 13
ప్రశ్న 13
Which database term is most closely associated with maintaining the accuracy, validity and consistency of stored data?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data integrity concerns maintaining data so that it remains accurate, valid and consistent.
• Integrity can be affected by incorrect entry, conflicting updates or improper modification of stored values.
• Data integrity should not be confused with redundancy, which refers to duplication of data.
• Integrity can be affected by incorrect entry, conflicting updates or improper modification of stored values.
• Data integrity should not be confused with redundancy, which refers to duplication of data.
వివరణ:
Question 14
ప్రశ్న 14
Consider the following statements about databases:
1. A database organizes data related to a defined subject or purpose.
2. A DBMS provides facilities for managing and retrieving stored database data.
3. Using a DBMS guarantees that duplicate data can never exist in a database.
4. A database can support efficient retrieval of required data.
Which statements are correct?
1. A database organizes data related to a defined subject or purpose.
2. A DBMS provides facilities for managing and retrieving stored database data.
3. Using a DBMS guarantees that duplicate data can never exist in a database.
4. A database can support efficient retrieval of required data.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statement 1 is correct because a database is an organized collection of data associated with a subject or purpose.
• Statements 2 and 4 are correct because DBMS facilities support management and retrieval of database data.
• Statement 3 is incorrect: a DBMS can help control unnecessary redundancy, but it does not guarantee that duplicate data can never exist.
• Statements 2 and 4 are correct because DBMS facilities support management and retrieval of database data.
• Statement 3 is incorrect: a DBMS can help control unnecessary redundancy, but it does not guarantee that duplicate data can never exist.
వివరణ:
Question 15
ప్రశ్న 15
A college separately stores each student's telephone number in admission, fee, attendance and hostel files. After a student changes the number, only the fee file is updated. Which approach best addresses the underlying data-management problem?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The scenario demonstrates the risks of maintaining uncontrolled copies of the same fact in independent files.
• A managed database can reduce unnecessary duplication and make updates to shared information more consistent.
• Creating still more independent copies would increase rather than solve the underlying redundancy and consistency problem.
• A managed database can reduce unnecessary duplication and make updates to shared information more consistent.
• Creating still more independent copies would increase rather than solve the underlying redundancy and consistency problem.
వివరణ:
Question 16
ప్రశ్న 16
Which of the following is NOT a valid general advantage or purpose of using a database management approach?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A database and DBMS can improve organization, retrieval, controlled sharing and management of stored data.
• Database techniques can also reduce problems associated with unnecessary duplication and inconsistent copies.
• No DBMS can guarantee immunity from every hardware failure or human error, so appropriate backup and recovery measures remain necessary.
• Database techniques can also reduce problems associated with unnecessary duplication and inconsistent copies.
• No DBMS can guarantee immunity from every hardware failure or human error, so appropriate backup and recovery measures remain necessary.
వివరణ:
Question 17
ప్రశ్న 17
Assertion (A): A DBMS can help enforce controlled access to stored database data.
Reason (R): A database can organize related data so that required information can be retrieved efficiently.
Choose the correct answer.
Reason (R): A database can organize related data so that required information can be retrieved efficiently.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Assertion is true because DBMS software can provide mechanisms for controlling access to database data.
• The Reason is also true because organized database storage supports efficient retrieval of required data.
• However, efficient organization and retrieval do not themselves explain access control, so the Reason is not the correct explanation of the Assertion.
• The Reason is also true because organized database storage supports efficient retrieval of required data.
• However, efficient organization and retrieval do not themselves explain access control, so the Reason is not the correct explanation of the Assertion.
వివరణ:
Question 18
ప్రశ్న 18
Match List I with List II:
List I
(a) Data
(b) Information
(c) Metadata
(d) Database
List II
1. Descriptive information about the structure or characteristics of other data
2. Organized collection of related data
3. Raw facts or observations
4. Meaningful result obtained after data is processed or organized
Choose the correct matching code.
List I
(a) Data
(b) Information
(c) Metadata
(d) Database
List II
1. Descriptive information about the structure or characteristics of other data
2. Organized collection of related data
3. Raw facts or observations
4. Meaningful result obtained after data is processed or organized
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data corresponds to raw facts or observations, giving (a)-3, while information is meaningful processed or organized data, giving (b)-4.
• Metadata describes other data or its structure, giving (c)-1.
• A database is an organized collection of related data, giving (d)-2.
• Metadata describes other data or its structure, giving (c)-1.
• A database is an organized collection of related data, giving (d)-2.
వివరణ:
Question 19
ప్రశ్న 19
A system records the numbers of complaints received on four consecutive days as 10, 12, 9 and 11. It then calculates that the average number received per day is 10.5. Which statement is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The daily counts 10, 12, 9 and 11 are the recorded input values and therefore serve as data for the calculation.
• Their total is 42, and 42 ÷ 4 = 10.5, so the average is a processed result derived from those values.
• The processed average provides additional meaning and is therefore information in this context.
• Their total is 42, and 42 ÷ 4 = 10.5, so the average is a processed result derived from those values.
• The processed average provides additional meaning and is therefore information in this context.
వివరణ:
Question 20
ప్రశ్న 20
Several departments need to use the same personnel information, search it frequently and update authorized details while avoiding uncontrolled independent copies. Which approach best satisfies these requirements?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A DBMS is designed to manage organized stored data and provide controlled facilities for retrieval and modification.
• Shared database management can reduce the inconsistencies that arise when departments maintain uncontrolled independent copies.
• The scenario illustrates major reasons for database use: organized storage, efficient retrieval, controlled sharing and better consistency.
• Shared database management can reduce the inconsistencies that arise when departments maintain uncontrolled independent copies.
• The scenario illustrates major reasons for database use: organized storage, efficient retrieval, controlled sharing and better consistency.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: D. Data consists of raw facts or observations, whereas information is data that has been processed or organized to convey meaning. సమాధానం: D.
-
Question 2 ప్రశ్న 2Answer: A. An organized collection of related data maintained so that it can be accessed and managed సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: C. The conclusion that 17 of the 60 complaints belong to the property-offence category సమాధానం: C.
-
Question 4 ప్రశ్న 4Answer: B. To provide software facilities for storing, organizing, retrieving and managing data in a database సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: C. The stored database data together with the DBMS and associated applications used to work with it సమాధానం: C.
-
Question 6 ప్రశ్న 6Answer: B. Managing shared data in an organized database so that unnecessary duplication and conflicting copies can be reduced సమాధానం: B.
-
Question 7 ప్రశ్న 7Answer: A. Unnecessary or repeated storage of the same data in multiple places సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: D. Data inconsistency సమాధానం: D.
-
Question 9 ప్రశ్న 9Answer: B. Metadata సమాధానం: B.
-
Question 10 ప్రశ్న 10Answer: C. A structure that organizes related data into rows and columns సమాధానం: C.
-
Question 11 ప్రశ్న 11Answer: D. A record సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: A. Field సమాధానం: A.
-
Question 13 ప్రశ్న 13Answer: A. Data integrity సమాధానం: A.
-
Question 14 ప్రశ్న 14Answer: D. 1, 2 and 4 only సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: B. Maintain the relevant student data under a managed database design so that departments use controlled, consistent stored information. సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: C. Guaranteeing that stored data can never be lost regardless of hardware failure, human error or the absence of backups సమాధానం: C.
-
Question 17 ప్రశ్న 17Answer: B. Both Assertion and Reason are true, but Reason is not the correct explanation of Assertion. సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: A. (a)-3, (b)-4, (c)-1, (d)-2 సమాధానం: A.
-
Question 19 ప్రశ్న 19Answer: C. The daily values are data, while the calculated average of 10.5 is information derived from those data. సమాధానం: C.
-
Question 20 ప్రశ్న 20Answer: D. Maintain the personnel data in an organized database managed through a DBMS with controlled access and update facilities. సమాధానం: D.