Font size
Worksheets1-20 data
Total questions: 20
Worksheet time: 20mins
In which type of below normal forms each determinant in relation is possible key?
3NF
2NF
1NF
BCNF
4NF
The scientific method of splitting complex table structures to simple table structures according to certain rules is:
Normalization
Denormalization
Generalization
Concretization
What is the relation type of functional dependencies?
1:1
1:M
M:1
M: M
What is used for normalization reducing?
Bottom-up method
Decomposition without redundancy
Generalization
E/R scheme
What is the type of NF, if the table is in previous NF and doesn't have multi-value dependencies?
There is no such NF
BCNF
DKNF
4NF
5NF
What is the reason of the anomalies insertion in the database
Relations between entities
Concretization
Functional dependency
Normalization
Redundancy
What functional dependency requires for functional definition of the other attributes?
Doesn't require the attribute not to be the key
Doesn't require the attribute to be the key
Requires the attribute to be the key
Requires the attribute not to be the key
There is no any relation between key and functional dependency
What is the type of NF, when and only when the determinant in the table is possible key?
4NF
BCNF
3NF
1NF
Record - "Descendant" can not have any number of records, "ancestors" in the data model:
other
hierarchical
Which of the actions in the design of a relational database is not included in the stage of deployment?
other
Testing and maintenance of the database
Which functional component controls matches in the database?
database file
file manager
file controller
file director
What is ther reason of the anomalies insertion in the database?
Redundancy
Functional dependency
Normalization
Relations between entities
Concretization
What does the TRUNCATE statement do?
Removes the table
Removes all rows from a table
Removes all columns from a table
Shortens the table to 10 rows
Which of the following are true about normalization?
Eliminate redundant data
Normalization can remove redundant data from the database
Normal forms speed up all queries
Normalization can be used to speed up maintenance tasks
When is a trigger fired?
All transactions, except non-logged operations.
Before constraint vallidation
After constraint validation but before the transaction commits
After the transaction completed
What is the model database used for?
A template for making application
To see databases scheme
A template for creating all new databases
In client/server architechture, what is the normal purpose of a server?
Handle data storage
Enforce data integrity
Format data for displaying to the end user
Control the graphical user interface
If Paula is a member of the user-defined database groups Sales and Accounting, which of the following SQL batches will allow her to have SELECT permissions on the table MyStuff?
other
Revoke select on MyStuff to salesGrant all on MyStuff to sales
Which of the following statements about this INSERT statement is true? (Check all correct answers) INSERT DISCOUNTS (store_id, lowqty, discount, discount_type) VALUES (6380, 10, 20, 'MyDiscount')
The column highqty will be set to NULL
It will insert one row into the table discount if the store_id 6380 exists in the stores table
The column highqty will be set to 20
Part of program which consists of T-SQL instructions, activated in response to definite actions, is :
procedure
Trigger
Table
