What are the various types of backup methods?
Full backup
Differential backup
Transactional backup
All of the above
Which of the following options is correct?
If you need to backup the copies of data only for the changes that have been committed since the
last complete backup was perform:
Full backup
Differential backup
Transactional backup
None of these
List various types of data base objects?
Tables, data item, Record ,data types
Stored procedures, user defined functions, triggers, views
Indexes, primary keys, foreign keys, constraints
All of the above
What is “SEQUEL”?
Structured English Query language
Sequential English Query language
Stated English Query language
None of the above
What is data base?
A data base a collection of files.
A data base is a collection of persistent data that is used by the application systems of some given enterprises.
A data base is a collection of records.
None of the above
SQL server uses a type of data base called a______.
Flat data base
Data base management system
Relational Data Base Management Systems
None of the above
What are the different steps in designing a data base?
Determine the purpose of your data base.
Determine the tables you need.
Determine the fields you need.
Identify the field or fields with unique values in each record.
Determine the relationship between tables.
Normalize the data into tables.
Refine your design.
Create the data base and tables.
All of the above.
What do you mean by normalization?
Normalization is basically a decomposition method in which a relation having undesirable dependency is split into two or more relations there by removing the undesirable effects of the existing dependencies.
Normalization is analyzing the data.
Normalization is splitting the data.
None of the above.