Olete.in – MCQs, Mock Tests & Government Job Prep | Data Base Management System (DBMS) Data Base Management System (DBMS) Mcq set 1

What is a fast way to adjust the width of a column?

1. Right click the left side of the column heading
2. Double click the left side of the column heading
3. Double click the right side of the column heading
4. Select tools>adjust column width from the menu

✅ Correct Answer: 3

In a large DBMS

1. each user can “see” only a small part of the entire database
2. each user can access every subschema
3. each subschema contains every field in the logical schema
4. none of the above is true

✅ Correct Answer: 1

The following command is used for inserting records

1. INSERT
2. ADD
3. Both of the above
4. None of the above

✅ Correct Answer: 1

If you are entering data in a form, a quick way to copy a value from the previous record is to press

1. Ctrl+’
2. F6
3. Ctrl+D
4. None of the above

✅ Correct Answer: 1

Which of the following is NOT a type of Microsoft Access database object?

1. Queries
2. Workbooks
3. Forms
4. Tables

✅ Correct Answer: 2

What are the columns in a Microsoft Access table called?

1. Rows
2. Fields
3. cells
4. Records

✅ Correct Answer: 2

When you save an Access project, what file format do you use?

1. adp
2. xm
3. mdb
4. All of above

✅ Correct Answer: 1

A command that lets you change one or more fields in a record is

1. Insert
2. Modify
3. Look up
4. All the above

✅ Correct Answer: 1

Users who store data about real people for marketing purposes must register the data and its potential use with

1. The computer misuse controller
2. The data protection controller
3. HM customs and excise
4. None of the above

✅ Correct Answer: 1

The purpose of the Add-in Manager is to

1. Create macros and automate data processing
2. Add or remove data in an existing database
3. Add or remove templates, macros, and wizards
4. All the above

✅ Correct Answer: 3

Examples of centralized multi-user databases are

1. Barclays’ Bank customer accounts
2. Supermarket stock control, organ donor database, client database
3. Airline reservations and other national global booking systems
4. None of the above

✅ Correct Answer: 3

It examines a small portion or sample of your data in a report before printing it.

1. Datasheet view
2. Design view
3. Print preview
4. Layout preview

✅ Correct Answer: 4

Which field allow to select items from drop down list?

1. An OLE field
2. An OLE field
3. A lookup Field
4. A hyperlink field

✅ Correct Answer: 3

DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer

1. Database management approach
2. Database administrator
3. DBBMS uses
4. Query language

✅ Correct Answer: 4

A subset of characters within a data field is known as

1. Record
2. File
3. Data string
4. Byte

✅ Correct Answer: 3

In a relational schema, each tuple is divided into fields called

1. Relations
2. Domains
3. Queries
4. All of the above

✅ Correct Answer: 2

A field that uniquely identifies a record is called a

1. Main field
2. Header
3. Key field
4. None of the above

✅ Correct Answer: 3

The arranging of data in a logical sequence is called

1. Sorting
2. summarizing
3. summarizing
4. summarizing

✅ Correct Answer: 1

Records are deleted using

1. DELETE command followed by pack
2. DELETE command without pack
3. DELETE command followed by zap
4. DELETE command without zap

✅ Correct Answer: 1

Auto Report allows you to

1. View a subset of your data
2. Create a simple report
3. Create a data entry form
4. Enter records

✅ Correct Answer: 2

What do you mean by one to many relationship between Teacher and Class table?

1. One class may have many teachers
2. One teacher can have many classes
3. Many classes may have many teachers
4. Many teachers may have many classes

✅ Correct Answer: 2

What are the different view to present a Table ?

1. Datasheet View
2. Design View
3. Pivote TableView
4. All Of Above

✅ Correct Answer: 4

In one-to-many relationship the table on 'many' side is called _______

1. Parent
2. Child
3. Sister
4. Master

✅ Correct Answer: 2

In which state one gathers and list all the necessary fields for the database design project.

1. Data Definition
2. Data Refinement
3. Establishing Relationship
4. None Of The Above

✅ Correct Answer: 1

Which of the following enables us to view data from a table based on a specific criterion

1. Form
2. Query
3. Macro
4. Report

✅ Correct Answer: 2

Which database object is ideal to view, change, andanalyze datain different ways ?

1. Table
2. Form
3. Query
4. Report

✅ Correct Answer: 3

In one-to-many relationship the table in 'one' side is called _______

1. Child
2. Owner
3. Parent
4. Owner

✅ Correct Answer: 3

Which data type allows alphanumeric characters and special symbols to be entered?

1. Text
2. Memo
3. Auto number
4. Mixed

✅ Correct Answer: 1

It is used to establish an association between related tables.

1. Line
2. Relationship
3. Primary Key
4. Records

✅ Correct Answer: 2

This key that uniquely identifies each record is called :

1. Primary Key
2. Key Record
3. Unique Key
4. Field Name

✅ Correct Answer: 1

Which name must be unique within a database ? A.. C..

1. Table
2. Field
3. Record
4. Character

✅ Correct Answer: 1

The third stage of designing a database is when we create___________ between tables

1. Relationship
2. Join
3. Query
4. None of These

✅ Correct Answer: 1

Two tables can be linked with relationship to _____

1. .Ensure data entry
2. .Ensure data integrity
3. .Create Primary Key
4. .Ensure Foreign Key

✅ Correct Answer: 2

In a database Table, the each category of information Is called __________

1. Tuple
2. Field
3. Record
4. all of these

✅ Correct Answer: 2

Which of the following fields has width of 8 bytes?

1. Memo
2. Number
3. .Date/time
4. Hyperlink

✅ Correct Answer: 3

which of the following is not a database object?

1. Tables
2. Queries
3. Relationships
4. Reports

✅ Correct Answer: 3

Which one is the guideline of Referential integrity in a relationship ?

1. Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table
2. Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
3. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
4. Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table

✅ Correct Answer: 3

Which of the following is not a database model

1. Network Database Model
2. Relational Database Model
3. Object Oriented Database Model
4. None

✅ Correct Answer: 4

The overall description of a database is called______.

1. Data integrity
2. Data manipulation
3. Database schema
4. Data definition

✅ Correct Answer: 3

A data dictionary is a repository that manages _____

1. Memory
2. Metadata
3. Spell Checker
4. Data Validator

✅ Correct Answer: 2

A database is an organized collection of _______________.

1. data
2. Attributes
3. Record
4. none of the above

✅ Correct Answer: 1

Which of the following software is appropriate to store data about school students?

1. MS-Access
2. Writer
3. Calc
4. Impress

✅ Correct Answer: 1

Which of the following is not a database programs?

1. MySQL
2. Oracle
3. Writer
4. OObase

✅ Correct Answer: 3

________ store data in Single table.

1. Flat File
2. Relational
3. Single File
4. One File

✅ Correct Answer: 1

________ are dedicated computers that hold the actual databases and run only DBMS and related Software.

1. Main Server
2. Web Server
3. Database Server
4. Non Database Server

✅ Correct Answer: 3

GUI act as front end and database server act as _____

1. Container
2. Back End
3. End
4. none of the above

✅ Correct Answer: 2

Duplication of data is called _________

1. Inconsistency
2. Consistency
3. Redundancy
4. Foreign Key

✅ Correct Answer: 3

Which of the following is not the advantage of database?

1. Sharing of Data
2. Reduce Data Redundancy
3. . Increase Data Inconsistency
4. Data Security

✅ Correct Answer: 3

Which of the following will help to maintain unique record in the table?

1. Foreign Key
2. Primary Key
3. Composite Key
4. Alternate Key

✅ Correct Answer: 2

Which of the following field of table “Book” can act as primary key?

1. Book_number
2. Subject
3. price
4. Author_name

✅ Correct Answer: 1