Operating System - MCQ Questions

Operating System (147 টি প্রশ্ন )

Back to Subject Page All Topics

Q91. It is an association established between common

ক) Line

খ) Relationship

গ) Primary key

ঘ) Records

Q92. This is the stage in database design where one gathers and list all the necessary fields for the database project.

ক) Data definition

খ) Data refinement

গ) Establishing relationship

ঘ) None of the above

Q93. Which of the field has width 8 bytes?

ক) Memo

খ) Number

গ) Date/time

ঘ) Hyperlink

Q94. Which of the following statement is true?

ক) Foreign key fields don\’t allow duplicate values

খ) In primary key field you can enter duplicate value

গ) In an indexed field you may or may not enter duplicate value depending upon setting

ঘ) All statements are true

Q95. Following is not a database model

ক) Network database model

খ) Relational database model

গ) Object oriented database model

ঘ) None

Q96. Microsoft Access is a

ক) Rdbms

খ) Oodbms

গ) Ordbms

ঘ) Network database model

Q97. Dcl provides commands to perform actions like

ক) Change the structure of tables

খ) Insert, update or delete records and data values

গ) Authorizing access and other control over database

ঘ) None of above

Q98. The database language that allows you to access or maintain data in a database

ক) Dcl

খ) Dml

গ) Ddl

ঘ) None of above

Q99. What is the maximum length a text field can be?

ক) 120

খ) 255

গ) 265

ঘ) 75

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

ক) Tables

খ) Queries

গ) Relationships

ঘ) Reports

Q101. A __________ enables you to view data from a table based on a specific criterion

ক) Form

খ) Query

গ) Macro

ঘ) Report

Q102. What are the columns in a Microsoft Access table called?

ক) Rows

খ) Records

গ) Fields

ঘ) Columns

Q103. Which of the following is not a type of Microsoft Access database object?

ক) Table

খ) Form

গ) Worksheets

ঘ) Modules

Q104. Which of the following database object hold data?

ক) Forms

খ) Reports

গ) Queries

ঘ) Tables

Q105. Which of the following store command to retrieve data from database?

ক) Forms

খ) Reports

গ) Queries

ঘ) Tables

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

ক) Forms

খ) Reports

গ) Queries

ঘ) Tables

Q107. What is the difference between ‘open’ and ‘open exclusively’

ক) Open statement opens access database files and open exclusively opens database files of other program like oracle

খ) Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed

গ) Both open and open exclusively are same

ঘ) Open exclusive command does not exist in MS Access

Q108. Which of the following is a method to create a new table in MS Access?

ক) Create table in design view

খ) Create table using wizard

গ) Create table by entering data

ঘ) All of above

Q109. In table design view, which key can be used to switch between the field names and properties panels?

ক) F3

খ) F4

গ) F5

ঘ) F6

Q110. The default and maximum size of text field in access

ক) 50 and 255 characters

খ) 8 and 1 gb

গ) 266 characters & 64000 characters

ঘ) None of above

Q111. Which of the following is not a field type in access

ক) Memo

খ) Hyperlink

গ) Ole object

ঘ) Lookup wizard

Q112. Which field type can store photos?

ক) Hyperlink

খ) Ole

গ) Both of these can be used

ঘ) Access tables can’t store photos

Q113. When entering field name, how many characters you can type in maximum?

ক) 60

খ) 64

গ) 68

ঘ) Any number of character

Q114. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

ক) You need to delete the whole table. There is no method to remove a particular field only.

খ) Delete all the fields from third downwards and reenter the required fields again.

গ) Select the third column in datasheet view then delete

ঘ) Select the third row in table design view then delete

Q115. Queries in access can be used as

ক) View, change and analyze data in different ways

খ) A source of records for forms and reports

গ) Only a

ঘ) Both a and b

Q116. To create queries in access

ক) You can drag and drop fields on query builders

খ) You can type the sql command in sql view

গ) You can use query wizard or design view

ঘ) All of above

Q117. What is a form in MS Access

ক) It is a printed page where users will write their data to fill it up

খ) It is an input screen designed to make the viewing and entering data easier

গ) This is an important part of database used by analysts to draw conclusions

ঘ) All of above

Q118. Which of the following statement is true

ক) Reports can be used to retrieve data from tables and calculate

খ) Queries can be printed in well formatted manner and presented as the information

গ) Queries can include calculated fields that do not exist in table

ঘ) Reports and forms are similar but forms are use to print but reports to display on screen only

Q119. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command

ক) File menu

খ) View menu

গ) Database menu

ঘ) Tools menu

Q120. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

ক) A doctor’s sign

খ) Thin + sign

গ) Outline rectangle

ঘ) None of above

সঠিক উত্তর: 0 | ভুল উত্তর: 0