Quiz Questions Flashcards
In access you can save a definition of an import to be used again, oui or non
Oui this is true!!!
In access an id column is always the primary key and cannot be removed. True or false
False
In access the column you create an index on must have unique values, yes or no?
Negative
Sql stands for
Structured query language
T or f: in sql server, the order of the column is very important and is reflected in how they are physically stored.
False!
In both access and sql every table MUST have a unique column that is the primary key!
Absolutely
What is the name of a join that only the same values are placed in the joining column?
Inner join
A table with 19 columns tagged as a BIT uses __________ space to store them.
Is it 1, 2, 3, or 4 bytes
3
The char data type uses _______ bytes per character?
One
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
1 byte with 2 bytes for overhead
Nvarchar data type uses ______ per character
1 byte? 2?
1 byte with 2 bytes for overhead
Or 2 bytes with 2 bytes for overhead
2 bytes with 2 bytes for overhead
To remove a table from the database you use the\_\_\_\_\_\_\_\_\_\_\_ sql statement. Is the answer: delete Alter Drop Or remove
Drop
To remove a row from a table you use the\_\_\_\_\_\_\_\_\_\_\_ sql statement. Is the answer: delete Alter Drop Or remove
Delete
The alter command only works on databases and not tables?
False
There can only be one database per sql instance
Negative
All column take up the same space on a database
False
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
Control where the files are stored
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
page is split evenly and the record is inserted
Tables can be created using (chose all that apply) A) ssms B) t-sql C)dos D)java
A) ssms
B) t-sql
A database must have at least one file group?
Yes? No?
Correct
Databases can only have one file group!
Yes? No? Maybe so?
No they can have many
Database files must be on the same device and cannot be spread over other devices!
True or false?
False
There is only one log file for each file group within a database?
Yes or no?
No
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
on a different drive than the log file
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
Which file group is used for each range in the partition function
What order is the partition table created A) scheme, function, table B) Table, function, scheme C) Function, table, sheme D) function, scheme, table 100
function, scheme, table 100
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
True
[ ] is used to delimit names with spaces in it: t or f
True. Very true
The go statement is used to tell sql to execute the code from the last point to this point: t or f
True
All tables must have a column thaf is used as the primary key. T or F
False
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
Master, msdb, model
Tables with a non clustered index are stored in: A) binary table format B)heap format C) b-tree format D) basic tree format
Heap
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) how the data is to be accessed
C) how the data will get in the table
Other types of indexes are? Spatial Filtered Xml Crosswise
Spatial
Filtered
Xml
A relationship is classifies as a constraint in sql?
Yes
Can you only have two partitions on any table?
No
A table with 10% fragmentation should be reorganized
Absolutly
Do tables each have their own log files?
No they do not
There can be ______ clustered indexesnon a table?
One
All indexes must be based on the primary key of the table
no!
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
The actual roe
How many accepted forms of normalization are there
5
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
heap or b-tree
Order the partition table steps A) load the data B) partitioned function C) partitioned scheme D) partitioned table
B) partitioned function
C) partitioned scheme
D) partitioned table
A) load the data
