Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Computers > DBMS > Flashcards

DBMS Flashcards

1
Q

Give an Example of flat file data base

A

Ms excel

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Give an example of relational database

A

SQL, oracle, mysql

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

tables are the ________ of a data base

A

building blocks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

rows and columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

all columns in a table are called _______

A

fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

all the tables in a row are called ______

A

records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

what is data

A

a set of characters that represents valid value is called data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

unfiltered

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

DELETING UPDATING

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

interface-friendly, entering data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

reports are used to _________ the data in a ________

A

display , printable format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

reports collect the _________ data from one or ore _________

A

summarized, tables or queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

full form of DBMS

A

data base management system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Full form of RDBMS

A

Rational database management system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

duplication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

where is the title bar located

A

at the top of the window

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

what does the title bar display

A

the name of the current database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

where is the quick access toolbar located

A

top left

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

what does the quick access toolbar contain

A

save undo redo (common command button)

21
Q

a ribon has various _____

A

tabs

22
Q

what are contextual tabs

A

tabs that appear when you work with certain objects like forms

23
Q

The navigation pane is present on the ________ of the window

A

left hand side

24
Q

how to open a new database

A

click on blank database

25
Q

how to open a database after u have already opened one

A

go to file> new> blank database

26
Q

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

A

file icon, file name text box

27
Q

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

A

create

28
Q

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

A

Table 1 , title bar

29
Q

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

A

table tools < title bar

30
Q

name the two views of a table

A

datasheet and design view

31
Q

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

A

2, field grid pane , field properties pane

32
Q

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

A

field names, data types and description

33
Q

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

A

different properties

34
Q

________ view is used to enter data

A

datasheet

35
Q

the fields names are listed as ______

A

column header

36
Q

how do you switch views in DBMS

A

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

37
Q

what views can you switch to

A

design view or datasheet view

38
Q

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

A

design or datasheet

39
Q

how do you create a table in design view

A

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

40
Q

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

A

field name, data type

41
Q

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

A

description column

42
Q

what is a query?

A

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

43
Q

how do you create a query using query wizard

A

clic on the create tab

select query wizard button in the queries group

the new query dialog box appears. the simple

44
Q
A
44
Q

the __________ query wizard is selected by default

A

simple

45
Q

what is short text

A

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

46
Q
A
46
Q
A

Computers (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions