UGC NET EXPERTS

DBMS Test 4

Email address *

Q.1. If a piece of data is stored in 2 places in the database, then *

1 point

storage space is wasted

changing the data will cause data inconsistency

easily accessible

both A and B

Q.2. The modify operation is done after *

1 point

delete

insert

look up

all of the above

Q.3. Data security threats includes *

1 point

privacy invasion

hardware failure

wrong manipulation of data

none of the above

Q.4. Queries to a database *

1 point

are written in English

can use aggregate functions like SUM and COUNT

both A and B

all of the above

Q.5. In a large DBMS *

1 point

each user can see only a small part of the entire database

each user can access every subschema

each subschema contains every field in the logical schema

all of the above

Q.6. The DBA function includes *

1 point

application programming

computer operations management

database access planning

all of the above

Q.7. Data encryption techniques are useful for *

1 point

reducing storage space requirements

improving data integrity

protecting data communication systems

all of the above

Q.8. Which normal form is considered adequate for relational database design? *

1 point

2NF

3NF

4NF

BCNF

Q.9. The concept of locking can be used to solve the problem of *

1 point

lost update problem

dirty read problem

unrepeatable problem

all of the above

Q.10. Students and courses enrolled is an example of *

1 point

one-to-one relationship

one to many

many-to-one

many-to-many

Submit

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms