Data Base Management System (DBMS)/Data Base Management System (DBMS) Mcq set 1 Sample Test,Sample questions

Question:
	
A data dictionary is a repository that manages _____

1.Memory

2.Metadata

3.Spell Checker

4.Data Validator


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

1.Tuple

2.Field

3.Record

4.all of these


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

1.Child

2.Owner

3.Parent

4.Owner


Question:
	
It is used to establish an association between related tables.

1.Line

2.Relationship

3.Primary Key

4.Records


Question:
	
Which of the following fields has width of 8 bytes?

1.Memo

2.Number

3..Date/time

4.Hyperlink


Question:
	
which of the following is not a database object?

1.Tables

2.Queries

3.Relationships

4.Reports


Question:
 Duplication of data is called _________

1.Inconsistency

2.Consistency

3.Redundancy

4.Foreign Key


Question:
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


Question:
A database is an organized collection of _______________.

1.data

2.Attributes

3.Record

4.none of the above


Question:
A field that uniquely identifies a record is called a

1.Main field

2.Header

3.Key field

4.None of the above


Question:
A subset of characters within a data field is known as

1.Record

2.File

3.Data string

4.Byte


Question:
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


Question:
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


Question:
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


Question:
GUI act as front end and database server act as _____

1.Container

2.Back End

3.End

4.none of the above


Question:
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


Question:
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


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

1.Relations

2.Domains

3.Queries

4. All of the above


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

1.Parent

2.Child

3.Sister

4.Master


Question:
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


Question:
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


Question:
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


Question:
The arranging of data in a logical sequence is called

1.Sorting

2.summarizing

3.summarizing

4.summarizing


Question:
The following command is used for inserting records

1.INSERT

2.ADD

3.Both of the above

4.None of the above


Question:
The overall description of a database is called______.

1.Data integrity

2.Data manipulation

3.Database schema

4.Data definition


Question:
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


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

1.Relationship

2.Join

3.Query

4.None of These


Question:
This key that uniquely identifies each record is called :

1.Primary Key

2.Key Record

3.Unique Key

4.Field Name


Question:
Two tables can be linked with relationship to _____

1..Ensure data entry

2..Ensure data integrity

3..Create Primary Key

4..Ensure Foreign Key


Question:
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


Question:
What are the columns in a Microsoft Access table called?

1.Rows

2.Fields

3.cells

4.Records


Question:
What are the different view to present a Table ?

1.Datasheet View

2.Design View

3.Pivote TableView

4.All Of Above


Question:
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


Question:
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


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

1.adp

2.xm

3.mdb

4.All of above


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

1.Text

2.Memo

3.Auto number

4.Mixed


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

1.Table

2.Form

3.Query

4.Report


Question:
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


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

1.Table

2.Field

3.Record

4.Character


Question:
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


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

1.Book_number

2.Subject

3.price

4.Author_name


Question:
Which of the following is not a database model

1.Network Database Model

2.Relational Database Model

3.Object Oriented Database Model

4.None


Question:
Which of the following is not a database programs?

1.MySQL

2.Oracle

3.Writer

4.OObase


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

1.Queries

2.Workbooks

3.Forms

4.Tables


Question:
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


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

1.MS-Access

2.Writer

3.Calc

4.Impress


Question:
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


Question:
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


Question:
________ 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


Question:
________ store data in Single table.

1.Flat File

2.Relational

3.Single File

4.One File


More MCQS

  1. Data Base Management System (DBMS) Mcq set 1
  2. Data Base Management System (DBMS) Mcq set 2
  3. DBMS Multiple Choice Questions and Answers
  4. Basics of Database Management System (DBMS) Set 1
  5. Basics of Database Management System (DBMS) Set 2
  6. Basics of Database Management System (DBMS) Set 3
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!