MicroSoft Access Question & Answer

D.N COMPUTER CENTRE (GHATAKPUKUR, 24 PGS (SOUTH))

MicroSoft Access Question & Answer

1.Windows Logo Key + R - ....... - Ok.

A) powerpnt
B) winword
C) msaccess
D) None of these

... Answer is C)
Windows Logo Key + R msaccess - Ok.

2. DBMS stands for ...............

A) Data Management System
B) Data Basic Management System
C) Database Management System
D) None of these

... Answer is C)
DBMS stands for Database Management System.

3. RDBMS stand for ............

A) Relational Database Management System
B) Relation Database Management System
C) Real Database Management System
D) None of these

... Answer is A)
RDBMS stand for Relational Database Management System.

4. Primary key is .........identity of each record.

A) double
B) multiple
C) unique
D) None of these

... Answer is C)
Primary key is unique identity of each record.

5. Primary key must......... allowed duplicate entity.

A) to be
B) not be
C) only one be
D) None of these

... Answer is B)
Primary key must not be allowed duplicate entity.

6. .......... Primary key can be assign on a field of a table.

A) Only two
B) Multiple
C) Double
D) None of these

... Answer is D)
Only one Primary key can be assign on a field of a table.

7. MS Access 2007 file extension is .......... .

A) .mdb
B) .accdb
C) .doc
D) MS-Excel

... Answer is B)
MS Access 2007 file extension is .accdb.

8. In database table,the category of information is called .............

A) record
B) table
C) field
D) none of these

... Answer is C)
In database table,the category of information is called field.

9.Which of the following is not a database object ?.

A) Table
B) From
C) Report
D) Relationship

... Answer is D)
Relationship of the following is not a database object.

10. The size of YES/NO field is always......

A) 1 bit
B) 1 byte
C) 1 kilobyte
D) 1 megabyte

... Answer is A)
he size of YES/NO field is always 1bit.

11. Which of the following database object produces the final result to present ?

A) From
B) Report
C) Queries
D) None of these

... Answer is B)
Report of the following database object produces the final result to present.

12. What are the columns in a Microsoft Access called ?

A) Table
B) Report
C) Query
D) None of these

... Answer is D)
Fields are the columns in a Microsoft Access called.

13. Which field type can stores photos ?

A) OLE
B) DATE/TIME
C) TEXT
D) MEMO

... Answer is A)
OLE field type can stores photos.

14. ..........is the maximum length a TEXT field.

A) 256
B) 257
C) 255
D) None of these

... Answer is C)
255 is the maximum length a TEXT field.

15. Microsoft Access is .........

A) RDBMS
B) ORDBMS
C) OODBMS
D) None of these

... Answer is A)
Microsoft Access is RDBMS.

16. The complete information about an entity in a database is called...........

A) Field
B) Information
C) Record
D) None of these

... Answer is C)
The complete information about an entity in a database is called Record.

17. The task from arranging data in order is called ............

A) Ordering
B) Searching
C) Sorting
D) None of these

... Answer is C)
The task from arranging data in order is called Sorting.

18. In a datasheet, what does each row represent ?.

A) Database
B) Record
C) Field
D) None of these

... Answer is B)
In a datasheet, each row represent Record.

19. What do you call a Primary Key field included in another table ?

A) Composite Key
B) Parent Key
C) Child Key
D) Foreign Key

... Answer is D)
Foreign Key call a Primary Key field included in another table.

20. What is the Full from of SQL ?.

A) Structured Question List
B) Structured Query Language
C) Struggle Question Language
D)A1048575

... Answer is B)
Structured Query Language Full from of SQL.