Question

Q.4 Answer any 5 out of given f questions (1*5= 5 marks)

(i) When primary key constraint is applied to one or more columnsthen it is known as: 1

(a) Primary Key

(b) Foreign Key

(C) Composite Primary Key

(D) None of the above

(i) data types in a database can be used forstoring photos,

music files etc.

(a) Binary data type

(b) Integer datatype

(C) Varchar datatype

(D) Boolean datatype

(ii) Arvind wants to modify records in a database. Which statementshould he use?

(a) Order By

(b) Change

(C) Update

(D) Select

(iv) if set yes then field will get the auto numeric value:

(a) Default value

(b) AutoValue

(C) Required

(D) Both (a) & (c)

helps to display the data in asummarized manner. 1

(v) In database, a

(a) Query

(b) Table

C)Report

(D) Subform

(vi) There are types of relationships in a table, in adatabase.

(a) 2 (b)3 )4 (d) 5​

Answer 1

Answer:

1 one option a 2 ka c 3 ka d 4 ka b