Question Detail

Attribute of one table matching to the primary key of other table, is called as

foreign key
secondary key
candidate key
composite key

Answer: Option A

Similar Questions :

1. Fragmentation of a file system

Can always be prevented
occurs only is file is not used properly
Can be temporarily removed by compaction
None of above

Answer: Option C

2. Which normal form is considered adequate for normal relational database design

2NF
5NF
3NF
4NF

Answer: Option C

3. Allocation map

Used to store program data
specifies which blocks are used by which file
is updated by application programs
allow programs to erase files

Answer: Option B

4. In order to use a DBMS, it is important to understand

the physical schema
all subschemas
one sub schema
none of above

Answer: Option C

5. Two basic types of record access methods are

sequential and random
direct and immediate
sequential and indexed
online and real time

Answer: Option A

Read more from - Database Question Answers - Chapter 1