DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
52. One of the cause of the failure of file system
- Data availability
- Fixed records
- Sequential records
- Lack of security
53. Data concurrency means
- Accessing multiple table records
- Access by multiple users
- Doing sequential multiple deletes
- Doing sequential multiple inserts
54. Main cause of failure of network model
- Impossible modification of data design
- Failure to explain the many-many relation
- Failure to explain the one-many relation
- Failure to explain the many-all relation
55. What among is not implemented by CODD
- Existence of data is not in the table
- Defining the constraints separately
- Both the above
- None of these
56. Normalization main important aim is
- to remove the data redundancy between the columns
- to have least redundancy dependency on primary key
- to more flexible access
- All the above
57. De-Normalization is required when
- To make strict data redundancy
- To make all column dependency on primary key
- To create as many related tables
- To more flexible access in order to avoid lengthy joins
58. Chose the correct sequence regarding select clause
- Where-group by-having
- Where
- Group by
- Having - order by
59. The function greatest/least works on
- List of same field values
- Set of different datatyped columns
- Set of same datatyped columns
- None of these