Brainscape's Knowledge GenomeTM

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


See full index

Database Systems > Quiz Questions > Flashcards

Quiz Questions Flashcards

1
Q

In access you can save a definition of an import to be used again, oui or non

A

Oui this is true!!!

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

In access an id column is always the primary key and cannot be removed. True or false

A

False

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

In access the column you create an index on must have unique values, yes or no?

A

Negative

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

Sql stands for

A

Structured query language

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

T or f: in sql server, the order of the column is very important and is reflected in how they are physically stored.

A

False!

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

In both access and sql every table MUST have a unique column that is the primary key!

A

Absolutely

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

What is the name of a join that only the same values are placed in the joining column?

A

Inner join

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

A table with 19 columns tagged as a BIT uses __________ space to store them.
Is it 1, 2, 3, or 4 bytes

A

3

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

The char data type uses _______ bytes per character?

A

One

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

Var char data type uses _________ per charactor. Is it:
1 byte? 2?
1 byte with 2 bytes for overhead
Or 2 bytes with 2 bytes for overhead

A

1 byte with 2 bytes for overhead

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

Nvarchar data type uses ______ per character
1 byte? 2?
1 byte with 2 bytes for overhead
Or 2 bytes with 2 bytes for overhead

A

2 bytes with 2 bytes for overhead

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q 
To remove a table from the database you use the\_\_\_\_\_\_\_\_\_\_\_ sql statement. 
Is the answer:
 delete 
Alter
Drop
Or remove
A

Drop

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q 
To remove a row from a table you use the\_\_\_\_\_\_\_\_\_\_\_ sql statement. 
Is the answer:
 delete 
Alter
Drop
Or remove
A

Delete

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

The alter command only works on databases and not tables?

A

False

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

There can only be one database per sql instance

A

Negative

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

All column take up the same space on a database

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q 
File groups are used to?
Ensure each database is unique
Control where the tables are stored
Help keep the names straight
File groups arent part of sql
A

Control where the files are stored

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

When you try to insert a record between two existing record and there is no room on the page then:
A) new page is used and pointers are put in place
B) page is split evenly and the record is inserted
C) an error is issued
D) the database is reorganized

A

page is split evenly and the record is inserted

19
Q 
Tables can be created using (chose all that apply)
A) ssms
B) t-sql
C)dos
D)java
A

A) ssms

B) t-sql

20
Q

A database must have at least one file group?

Yes? No?

A

Correct

21
Q

Databases can only have one file group!

Yes? No? Maybe so?

A

No they can have many

22
Q

Database files must be on the same device and cannot be spread over other devices!
True or false?

A

False

23
Q

There is only one log file for each file group within a database?
Yes or no?

A

No

24
Q

When using two physical drives, it is recommend that the production database be:
A) on the same drive as the log file
B) on a different drive than the log file
C) spread across both drives
D) be on a drive that is tune for high write and slow reads

A

on a different drive than the log file

25
Q

The partition scheme indicates
A) which partition function to use for which file group
B) which file group is used for each range in the partition function
C) ehich table to use for file group
D) which table to use

A

Which file group is used for each range in the partition function

26
Q 
What order is the partition table created
A) scheme, function, table
B) Table, function, scheme
C) Function, table, sheme
D) function, scheme, table 100
A

function, scheme, table 100

27
Q

The AS clause in a select statement is used to provide a differe t name for a column in the generated table: T OR F

A

True

28
Q

[ ] is used to delimit names with spaces in it: t or f

A

True. Very true

29
Q

The go statement is used to tell sql to execute the code from the last point to this point: t or f

A

True

30
Q

All tables must have a column thaf is used as the primary key. T or F

A

False

31
Q 
Besides the productuon database the following system databases need to tge backed up on a regular basis
A) master
B)msdb
C) adventure works
D) model
A

Master, msdb, model

32
Q 
Tables with a non clustered index are stored in:
A) binary table format
B)heap format
C) b-tree format
D) basic tree format
A

Heap

33
Q 
When normailizing a data base which have to be considered?
A) how the data is to be accessed
B) who created the data
C) how the data will get in the table
D) the size of each column
A

A) how the data is to be accessed

C) how the data will get in the table

34
Q 
Other types of indexes are?
Spatial
Filtered
Xml
Crosswise
A

Spatial
Filtered
Xml

35
Q

A relationship is classifies as a constraint in sql?

A

Yes

36
Q

Can you only have two partitions on any table?

A

No

37
Q

A table with 10% fragmentation should be reorganized

A

Absolutly

38
Q

Do tables each have their own log files?

A

No they do not

39
Q

There can be ______ clustered indexesnon a table?

A

One

40
Q

All indexes must be based on the primary key of the table

A

no!

41
Q

In a clustered index, the leaves of the tree are
A) the actual rows
B) a pointer to the rows
C) a pointer to the page that contains the row
D) a pointer to the non clustered index

A

The actual roe

42
Q

How many accepted forms of normalization are there

A

5

43
Q 
If tables are stored in HoBT format. What does that mean
A) half or binary
B) heap or binary
C) heap or b-tree
D) heap or basic tree
A

heap or b-tree

44
Q 
Order the partition table steps
A) load the data
B) partitioned function
C) partitioned scheme
D) partitioned table
A

B) partitioned function
C) partitioned scheme
D) partitioned table
A) load the data

Database Systems (8 decks)

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