Quiz Questions

Question 1

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

Answer 1

Oui this is true!!!

Question 2

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

Answer 2

False

Question 3

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

Answer 3

Negative

Question 4

Sql stands for

Answer 4

Structured query language

Question 5

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

Answer 5

False!

Question 6

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

Answer 6

Absolutely

Question 7

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

Answer 7

Inner join

Question 8

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

Answer 8

3

Question 9

The char data type uses _______ bytes per character?

Answer 9

One

Question 10

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

Answer 10

1 byte with 2 bytes for overhead

Question 11

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

Answer 11

2 bytes with 2 bytes for overhead

Question 12

To remove a table from the database you use the\_\_\_\_\_\_\_\_\_\_\_ sql statement. 
Is the answer:
 delete 
Alter
Drop
Or remove

Answer 12

Drop

Question 13

To remove a row from a table you use the\_\_\_\_\_\_\_\_\_\_\_ sql statement. 
Is the answer:
 delete 
Alter
Drop
Or remove

Answer 13

Delete

Question 14

The alter command only works on databases and not tables?

Answer 14

False

Question 15

There can only be one database per sql instance

Answer 15

Negative

Question 16

All column take up the same space on a database

Answer 16

False

Question 17

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

Answer 17

Control where the files are stored

Question 18

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

Answer 18

page is split evenly and the record is inserted

Question 19

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

Answer 19

A) ssms

B) t-sql

Question 20

A database must have at least one file group?

Yes? No?

Answer 20

Correct

Question 21

Databases can only have one file group!

Yes? No? Maybe so?

Answer 21

No they can have many

Question 22

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

Answer 22

False

Question 23

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

Answer 23

No

Question 24

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

Answer 24

on a different drive than the log file

Question 25

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

Answer 25

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

Question 26

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

Answer 26

function, scheme, table 100

Question 27

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

Answer 27

True

Question 28

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

Answer 28

True. Very true

Question 29

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

Answer 29

True

Question 30

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

Answer 30

False

Question 31

``` 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 ```

Answer 31

Master, msdb, model

Question 32

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

Answer 32

Heap

Question 33

``` 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 ```

Answer 33

A) how the data is to be accessed | C) how the data will get in the table

Question 34

``` Other types of indexes are? Spatial Filtered Xml Crosswise ```

Answer 34

Spatial Filtered Xml

Question 35

A relationship is classifies as a constraint in sql?

Answer 35

Yes

Question 36

Can you only have two partitions on any table?

Answer 36

No

Question 37

A table with 10% fragmentation should be reorganized

Answer 37

Absolutly

Question 38

Do tables each have their own log files?

Answer 38

No they do not

Question 39

There can be ______ clustered indexesnon a table?

Answer 39

One

Question 40

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

Answer 40

no!

Question 41

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

Answer 41

The actual roe

Question 42

How many accepted forms of normalization are there

Answer 42

5

Question 43

``` 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 ```

Answer 43

heap or b-tree

Question 44

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

Answer 44

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