Data items grouped together for storage purposes are called a
Answer: A
Correct answer: record
A record is a group of related data items stored together as a unit - the fields of one row taken as a whole. A string is a single value and a list is an arrangement, not a storage unit.
Please log in or register to report this question.
A top-to-bottom relationship among the items in a database is established by a
Answer: A
Correct answer: Hierarchical schema
A hierarchical model arranges records in a tree, so each child has exactly one parent and the structure reads from top to bottom. A network model allows several parents, and a relational model has no such ordering at all.
Please log in or register to report this question.
The ______ approach reduces the time and effort required for design and carries less risk in database management.
Answer: B
Correct answer: Multiple databases
Splitting the design into several smaller databases means each can be designed, tested and changed on its own, so less has to be got right at once and a mistake affects less. A single global database has to be designed as one piece, which is both slower and riskier.
Please log in or register to report this question.
____ table store information about database or about the system.
Answer: B
Correct answer: System
System tables, also called the catalogue or data dictionary, hold the database's description of itself - the tables, columns, indexes, users and permissions that exist. They are how the DBMS knows what it is managing.
Please log in or register to report this question.
HSAM stands for .
Answer: B
Correct answer: Hierarchic Sequential Access Method
HSAM is Hierarchic Sequential Access Method, one of the IMS access methods, in which the segments of a hierarchical database are stored in sequential order.
Please log in or register to report this question.
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Answer: C
Correct answer: Schema
A schema is the description of a relation's structure: its attributes and the domain of each. An instance is the set of tuples present at a given moment, which changes while the schema stays fixed.
Please log in or register to report this question.
SQL Server stores index information in the ______ system table.
Answer: C
Correct answer: sys indexes
Index information is held in the system table sysindexes, one of the catalogue tables whose names all begin with sys.
Please log in or register to report this question.
_____clause is an additional filter that is applied to the result.
Answer: D
Correct answer: Having
HAVING filters the groups produced by GROUP BY, after aggregation. WHERE filters rows before they are grouped, which is why a condition on an aggregate such as \( \text{COUNT}(*)>5 \) must go in HAVING and not in WHERE.
Please log in or register to report this question.
The one guideline to be followed while designing the database is
Answer: B
Correct answer: It should avoid/reduce the redundancy.
Redundancy is the source of most update problems: the same fact stored twice can be changed in one place and not the other. Reducing it is what normalisation is for. The other three options each describe a fault rather than a guideline.
Please log in or register to report this question.
A logical schema
Answer: C
Correct answer: is a standard way of organizing information into accessible parts
The logical schema describes the data as tables, attributes and relationships - the structure a user or programmer works with. How those tables are actually laid out on disk is the physical schema, which is a separate description.
Please log in or register to report this question.
