1. A(n) ____________________ in a hierarchical model is the equivalent of a record in a file system.
Answer
Correct Answer:
Segment
Note: This Question is unanswered, help us to find answer for this one
2. A(n) ____ relationship describes the connection or link between objects.
Answer
Correct Answer:
Association
Note: This Question is unanswered, help us to find answer for this one
3. The type of information collected on the survey form that describes how data is updated is ____.
Answer
Correct Answer:
Processing information
Note: This Question is unanswered, help us to find answer for this one
4. The two most common network access methods are ____ and token ring.
Answer
Correct Answer:
Bus
Note: This Question is unanswered, help us to find answer for this one
5. A ____, or requirements model, describes the information that a system must provide.
Answer
Correct Answer:
Business model
Note: This Question is unanswered, help us to find answer for this one
6. Ellipses in an Entity Relationship Diagram represent a:
Answer
Correct Answer:
Attributes
Note: This Question is unanswered, help us to find answer for this one
7. The process of adjusting the storage of data to suit the popularity rating is:
Answer
Correct Answer:
Data Migration
Note: This Question is unanswered, help us to find answer for this one
8. System implementation phase of SDLC entails:
Answer
Correct Answer:
a & b
Note: This Question is unanswered, help us to find answer for this one
9. A weak entity is an entity that
Answer
Correct Answer:
Has no key attributes
Note: This Question is unanswered, help us to find answer for this one
10. What is not true about the primary key?
Answer
Correct Answer:
It is one of the candidate keys
Note: This Question is unanswered, help us to find answer for this one
11. Which type of data access is done while using a stack?
Answer
Correct Answer:
LIFO
Note: This Question is unanswered, help us to find answer for this one
12. The major focus of system methods and procedures is to relate input data to a final output that is meaningful to the:
Answer
Correct Answer:
User
Note: This Question is unanswered, help us to find answer for this one
13. A relation is in 3NF if and only if:
Answer
Correct Answer:
The 2 NF and every non key attribute is non-transitively dependent on primary key
Note: This Question is unanswered, help us to find answer for this one
14. A language in which the user requests information from the database is
Answer
Correct Answer:
A query language
Note: This Question is unanswered, help us to find answer for this one
15. Ensuring that the updates are correct even during the failure period is referred to as
Answer
Correct Answer:
Data Integrity
Note: This Question is unanswered, help us to find answer for this one
16. The concept of a joined dependency is related to:
Answer
Correct Answer:
5 NF
Note: This Question is unanswered, help us to find answer for this one
17. Polymorphism is defined as:
Answer
Correct Answer:
Ability of methods to operate on objects of more than one class
Note: This Question is unanswered, help us to find answer for this one
18. The system that processes transactions as soon as they are entered is
Answer
Correct Answer:
On Line
Note: This Question is unanswered, help us to find answer for this one
19. The state while a transaction is executing is:
Answer
Correct Answer:
Active
Note: This Question is unanswered, help us to find answer for this one
20. The role of a DBA is to:
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
21. Which of the following refers to the hashing in which the number of disk accesses needed to locate a specific record is never more than two?
Answer
Correct Answer:
Extendable
Note: This Question is unanswered, help us to find answer for this one
22. A repository of information gathered from multiple sources stored under a unified schema at a single site is
Answer
Correct Answer:
Data Warehousing
Note: This Question is unanswered, help us to find answer for this one
23. Execution of a transaction in isolation preserves:
Answer
Correct Answer:
Consistency
Note: This Question is unanswered, help us to find answer for this one
24. Who gave the 12 rules for any RDBMS to be accepted as a full-fledged RDBMS?
Answer
Correct Answer:
Codd
Note: This Question is unanswered, help us to find answer for this one
25. A candidate key that involves more than one attribute is said to be:
Answer
Correct Answer:
Composite
Note: This Question is unanswered, help us to find answer for this one
26. Head Crash on the disk is:
Answer
Correct Answer:
Hardware Failure
Note: This Question is unanswered, help us to find answer for this one
27. A phase when a transaction may obtain locks but may not release any lock is:
Answer
Correct Answer:
Growing
Note: This Question is unanswered, help us to find answer for this one
28. If in relation r, values x and y are only dependent on the primary key and not on each other, then they are said to be:
Answer
Correct Answer:
Mutually Independent
Note: This Question is unanswered, help us to find answer for this one
29. After a transaction completes successfully, the changes made to the database are reflected even if there are system failures This is referred to as:
Answer
Correct Answer:
Durability
Note: This Question is unanswered, help us to find answer for this one
30. The two-phase commit protocol may introduce:
Answer
Correct Answer:
Blocking
Note: This Question is unanswered, help us to find answer for this one
31. Select the most appropriate statement from the following:
Answer
Correct Answer:
As the management level goes up the hierarchy, information becomes more and more summarized
Note: This Question is unanswered, help us to find answer for this one
32. The concept of a Multivalued Dependency is to be found in:
Answer
Correct Answer:
4 NF
Note: This Question is unanswered, help us to find answer for this one
33. Once a transaction commits, its update survives even if there is a subsequent system crash This is:
Answer
Correct Answer:
Durability
Note: This Question is unanswered, help us to find answer for this one
34. The cost of physically linking the sites in the system is:
Answer
Correct Answer:
Installation Cost
Note: This Question is unanswered, help us to find answer for this one
35. Rollback causes the current transaction to:
Answer
Correct Answer:
Abort
Note: This Question is unanswered, help us to find answer for this one
36. The candidate key which is not a primary key is said to be:
Answer
Correct Answer:
Alternate Key
Note: This Question is unanswered, help us to find answer for this one
37. Which timestamp is denoted by the W-timestamp (Q) of a transaction?
Answer
Correct Answer:
Largest that executes write(Q) successfully
Note: This Question is unanswered, help us to find answer for this one
38. The collection of information stored in a database at a particular moment is called:
Answer
Correct Answer:
View
Note: This Question is unanswered, help us to find answer for this one
39. Finding relevant information from a large volume of data is called:
Answer
Correct Answer:
Data Mining
Note: This Question is unanswered, help us to find answer for this one
40. Which of the following is used to create complex entities?
Answer
Correct Answer:
Aggregation
Note: This Question is unanswered, help us to find answer for this one
41. Shadow paging is:
Answer
Correct Answer:
Recovery technique
Note: This Question is unanswered, help us to find answer for this one
42. Projection operator
Answer
Correct Answer:
Causes vertical fragmentation
Note: This Question is unanswered, help us to find answer for this one
43. Normal forms are used to
Answer
Correct Answer:
Avoid logical inconsistencies from operations
Note: This Question is unanswered, help us to find answer for this one
44. If a transaction Ti has obtained a shared mode lock on item Q, then Ti:
Answer
Correct Answer:
Can read
Note: This Question is unanswered, help us to find answer for this one
45. A tree is composed of a hierarchy of elements called:
Answer
Correct Answer:
Nodes
Note: This Question is unanswered, help us to find answer for this one
46. A language that enables users to access or manipulate data is:
Answer
Correct Answer:
Data Manipulation
Note: This Question is unanswered, help us to find answer for this one
47. The database that is a unification of several data files with any redundancy wholly or partially eliminated is
Answer
Correct Answer:
Integrated
Note: This Question is unanswered, help us to find answer for this one
48. To decompose a relation into several smaller relations without duplicity is
Answer
Correct Answer:
Normalization
Note: This Question is unanswered, help us to find answer for this one
49. The level of data abstraction which describes how the data is actually stored is:
Answer
Correct Answer:
Physical level
Note: This Question is unanswered, help us to find answer for this one
50. Encapsulation implies:
Answer
Correct Answer:
Data Independence
Note: This Question is unanswered, help us to find answer for this one
51. A terabyte is:
Answer
Correct Answer:
1 million MB
Note: This Question is unanswered, help us to find answer for this one
52. Which of the following is not a part of SDLC?
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
53. Which of the following terms refers to either all or none of the operations being reflected properly in the database?
Answer
Correct Answer:
Atomicity
Note: This Question is unanswered, help us to find answer for this one
54. A character coding technique in which characters occur in the data with different frequencies is:
Answer
Correct Answer:
Huffman Coding
Note: This Question is unanswered, help us to find answer for this one
55. A catalogue of all the data types in the database is:
Answer
Correct Answer:
Data Dictionary
Note: This Question is unanswered, help us to find answer for this one
56. A menu driven system:
Answer
Correct Answer:
Presents options and allows the user to make selections
Note: This Question is unanswered, help us to find answer for this one
57. The term used to denote an overall chart of all the data item types and record types stored in a database is:
Answer
Correct Answer:
Schema
Note: This Question is unanswered, help us to find answer for this one
58. Conflicts between instructions correspond to
Answer
Correct Answer:
Non-compatibility of lock modes
Note: This Question is unanswered, help us to find answer for this one
59. Each time a transaction commits the database, pages containing the old version of the data become inaccessible Such pages are considered
Answer
Correct Answer:
Garbage
Note: This Question is unanswered, help us to find answer for this one
60. In a DBMS, two record types and their relationship is called:
Answer
Correct Answer:
Schema
Note: This Question is unanswered, help us to find answer for this one
61. A statement that is executed automatically by the system as a side effect of a modification to the database is:
Answer
Correct Answer:
Trigger
Note: This Question is unanswered, help us to find answer for this one
62. In the client server systems, the DBMS in the server is also known as
Answer
Correct Answer:
Backend
Note: This Question is unanswered, help us to find answer for this one
