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.
Helping people keep track of things is the purpose of a(n) ________ .
Answer: A
Correct answer: database
The purpose of a database is to keep track of things - and the “things” may be of many kinds, with relationships among them. A table holds one kind of thing, an instance is one particular database, and a relationship connects two tables; none of them is the purpose.
Please log in or register to report this question.
A primary key if combined with a foreign key creates
Answer: A
Correct answer: Parent-Child relationship between the tables that connect them.
A foreign key must match a primary key in another table, which makes that table the parent and this one the child. The result is a one-to-many relationship, and it lets the DBMS enforce referential integrity: no child row may refer to a parent that does not exist.
Please log in or register to report this question.
