DBMS

Question 1

Give an Example of flat file data base

Answer 1

Ms excel

Question 2

Give an example of relational database

Answer 2

SQL, oracle, mysql

Question 3

tables are the ________ of a data base

Answer 3

building blocks

Question 4

tables store the complete matter in the structure of ______ and _______

Answer 4

rows and columns

Question 5

all columns in a table are called _______

Answer 5

fields

Question 6

all the tables in a row are called ______

Answer 6

records

Question 7

a record consists of all the _______ that belong to a single person

Answer 7

fields

Question 8

what is data

Answer 8

a set of characters that represents valid value is called data

Question 9

to retrieve the _______ data from a data base queries are used

Answer 9

unfiltered

Question 10

queries are also used to perform actions such as _______ , ________, ETC

Answer 10

DELETING UPDATING

Question 11

forms provide a _________ that facilitates the procsess of _________ in tables and queries

Answer 11

interface-friendly, entering data

Question 12

reports are used to _________ the data in a ________

Answer 12

display , printable format

Question 13

reports collect the _________ data from one or ore _________

Answer 13

summarized, tables or queries

Question 14

full form of DBMS

Answer 14

data base management system

Question 15

Full form of RDBMS

Answer 15

Rational database management system

Question 16

a relation database allows the prevention of a _________ in the data

Answer 16

duplication

Question 17

where is the title bar located

Answer 17

at the top of the window

Question 18

what does the title bar display

Answer 18

the name of the current database

Question 19

where is the quick access toolbar located

Answer 19

top left

Question 20

what does the quick access toolbar contain

Answer 20

save undo redo (common command button)

Question 21

a ribon has various _____

Answer 21

tabs

Question 22

what are contextual tabs

Answer 22

tabs that appear when you work with certain objects like forms

Question 23

The navigation pane is present on the ________ of the window

Answer 23

left hand side

Question 24

how to open a new database

Answer 24

click on blank database

Question 25

how to open a database after u have already opened one

Answer 25

go to file> new> blank database

Question 26

if required , you can change the default location of the file by clicking on the ____________ placed next to the ________

Answer 26

file icon, file name text box

Question 27

a new database will be created when u click on the _______ button

Answer 27

create

Question 28

after creating a new database an empty file with the name _______ will be displayed on the ________

Answer 28

Table 1 , title bar

Question 29

after creating a database a new tab , _________ will now be visible on the ______

Answer 29

table tools < title bar

Question 30

name the two views of a table

Answer 30

datasheet and design view

Question 31

the design view is divided into ________ parts , __________ and _________

Answer 31

2, field grid pane , field properties pane

Question 32

in the field grid pane your can define the _______, __________ and _________

Answer 32

field names, data types and description

Question 33

field properties name is used to enter the ______________ for the fields defined in a table

Answer 33

different properties

Question 34

________ view is used to enter data

Answer 34

datasheet

Question 35

the fields names are listed as ______

Answer 35

column header

Question 36

how do you switch views in DBMS

Answer 36

click on the drop down arrow of the view option present in the views group either on the home tab or fields group

Question 37

what views can you switch to

Answer 37

design view or datasheet view

Question 38

you can add new tables to an existing data base using the ________ or __________ view

Answer 38

design or datasheet

Question 39

how do you create a table in design view

Answer 39

you create a table by clicking on the table design option in the table group in the create tab

Question 40

in each field of a table , you type the _________ and press the tab key to move to the ______ column and select a data type, such as a shortcut

Answer 40

field name, data type

Question 41

in the _____ you can add the description for each field , which is optional

Answer 41

description column

Question 42

what is a query?

Answer 42

a query is a database that allows you to retrieve information from one or more database tables that meet a specific condition or criteria

Question 43

how do you create a query using query wizard

Answer 43

clic on the create tab select query wizard button in the queries group the new query dialog box appears. the simple

Question 44

the __________ query wizard is selected by default

Answer 44

simple

Question 45

what is short text

Answer 45

short text is used to store a combination f numbers and letters