HTET & PGT Computer Teacher's Exam Question 2017 Part- 4th

1. Name the database management System from MS Office suite ?
a. Microsoft access
b. MS-Fox Pro
c. Oracle
d. MS- File Maker

2. Which process arranges the data in a proper sequence ?
a. Data Sorting
b. Data Summarizing
c. Data Redundancy
d. Data Storing

3. Name the term which is used to get the Synopsis of data on the basis of some criteria.
a. Data Sorting
b. Data Summarizing
c. Data Redundancy
d. Data Storing

4. Which key is used to uniquely identify each record in a database table ?
a. Secondary key 
b. Primary key
c. Temporary key
d. None of these

5. What is the extension of the database file in MS Office Access ?
a. .accdb
b. .xdx
c. .docx
d. .adbbc

6. Which type of database stores all the data in a single table ?
a. MS Excel
b. Oracle
c. MS SQL
d. MS Access

7. Which type of database are example of Relational Database ?
a. MS Excel
b. Fox Pro
c. MS Access
d. All of these

8. Student_ID     First Name       Last Name     Course_ID
         01             Ram            Sharma         C002
         02             Rajan          Kumar          P003
         03             Kamal          Sinha          C002

Identify the Primary key of the table.
a. Student_ID
b. Fist Name
c. Course_ID
d. Last_Name

9. Which type of key used in this diagram at the place of(?) ?
 

a. Candidate key
b. Primary Key
c. Secondary key

d. Foreign key

10.  Positive and negative integers occupies ____bytes in the memory ?
a. 1 bytes
b. 2 bytes
c. 4 bytes
d. 16 bytes