. What is the use of Referential Integrity in MS Access?
Options: a. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
b. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
c. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
d. None of above
Options: a. Foreign key fields don’t allow duplicate values
b. In primary key field you can enter duplicate value
c. In an indexed field you may or may not enter duplicate value depending upon setting
d. All statements are true
Options: A) Mechanical analog computers have existed for thousands of years
B) There are mechanical analog computers and electronic analog computers.
C) All electronic computers are digital computers
D) All of above are false
Options: Database – File – Record – Fields – Bytes – Bit
B. Database – File – Record – Fields – Bit – Bytes
C. Database – Record – File – Fields – Bytes – Bit
D. Database – Record – Fields – File – Bytes – Bit
Ans:– A ,
The highest level in the hierarchy of data organization is called
Options: a. data bank b. data base c. data file d. data record
After coding a document into a digital signal, it can be sent by telephone, telex or satellite to the receiver where the signal is decoded and an exact copy of the original document is made. What is it called?
Options: Telex, Word processor, Facsimile, Electronic mail
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Options: Each vendor desiring to be ODBC-complaint provides an ODBC driver., Requires certain criteria to be met in order to establish an ODBC connection., Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed., All of the above.
Use of a supertype/subtype relationship is necessary when which of the following exists?
Options: An instance of a subtype participates in a relationship that is unique to that subtype., An instance of a subtype participates in a relationship that is the same as the other subtypes., Attributes apply to all of the instances of an entity type., No attributes apply to any of the instances of an entity type.