Disk File Records Notes Questions with Answers PDF Download – Test 107

In high level programs, the command which sets the pointer of file to the beginning of that file is classified as

1. modify command
2. open command
3. locate command
4. reset command

In unary relational operations, the symbol π is used to represent the operation called

1. OR operation
2. AND operation
3. TABLE operation
4. PROJECT operation

The number of entity types participating in the E-R diagrams is represented by

1. structure of relationship
2. instance of relationship
3. degree of relationship
4. role of relationship

The search value which is present on each node in search tree diagram of order 'p' is as

1. p - 1
2. p - 2
3. p + 1
4. p + 2

The system used by database administrators to specify restrictions of accounts and creation of new accounts is classified as

1. controlled redundancy subsystem
2. program dependence subsystem
3. security and authorization subsystem
4. program independence subsystem