A relational database developer refers to a record as
Answer: C
Correct answer: a tuple
In relational terminology a row is a tuple, a column is an attribute, and the table as a whole is a relation.
Please log in or register to report this question.
An advantage of the database management approach is
Answer: C
Correct answer: data is integrated and can be accessed by multiple programs
The point of the database approach is that data is held once, in one place, and shared: many programs read the same integrated store instead of each keeping its own file. Redundancy falls rather than rises, and the data becomes independent of the programs.
Please log in or register to report this question.
Enterprise Resource Planning (ERP) is an example of a single user database.
Answer: B
Correct answer: False
ERP is the standard example of a multi-user application: an entire organisation working in one system at once. That is what makes concurrency control, locking and transaction management essential to it.
Please log in or register to report this question.
The users who use easy-to-use menu are called
Answer: B
Correct answer: Naïve users.
Naive (or parametric) users interact through a prepared interface - menus, forms, a screen with a few fields - and never write a query. A bank teller is the standard example. Sophisticated users write their own SQL; stand-alone users work with a personal database of their own.
Please log in or register to report this question.
The method of access which uses key transformation is known as
Answer: B
Correct answer: Hash
Hashing applies a transformation to the key value to compute the address of the record directly, so a lookup takes one access with no index to search. The price is that a hash file supports no range queries and needs a strategy for collisions.
Please log in or register to report this question.
A database has a built-in capability to create, process and administer itself.
Answer: B
Correct answer: False
A database is the stored data; it has no capabilities of its own. Creating, processing and administering it is the work of the DBMS, a separate program. The distinction is easy to lose because products such as Access present both as one thing.
Please log in or register to report this question.
A primary key combined with a foreign key creates
Answer: A
Correct answer: Parent-Child relationship between the tables that connect them
A foreign key holds values that must exist as a primary key in another table, which makes that other table the parent and this one the child. The arrangement gives a one-to-many relationship and lets the DBMS enforce referential integrity - no child row may point at a parent that does not exist.
Please log in or register to report this question.
In an E-R diagram a derived attribute is represented by
Answer: D
Correct answer: Dashed ellipse
A dashed (broken) ellipse marks a derived attribute - one computed from other data rather than stored, such as age derived from date of birth. A plain ellipse is an ordinary attribute, a double ellipse a multivalued one, and a rectangle an entity set.
Please log in or register to report this question.
The method in which records are physically stored in a specified order according to a key field in each record is
Answer: A
A method in which records are physically stored in a specified order according to a key field in each record is hash. (In hash method, a hash function is performed on the key value to determine the unique physical address of the record to store or retrieve)
Please log in or register to report this question.
The following are components of a database except ________ .
Answer: C
Correct answer: reports
A database holds user data, metadata describing its own structure, indexes and other overhead structures, and application metadata. A report is produced from the database by an application; it is output, not a component of the database itself.
Please log in or register to report this question.
