Database-MySQL [3i Infotech Placement]: Sample Questions 40 - 41 of 162
Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.
Question 40
Explanation
- A Checkpoint is like a snapshot of the DBMS state.
- The DBMS can reduce the amount of work to be done during restart in the event of subsequent crashes, by taking checkpoints,
Checkpoint automatically occurs at:
- Checkpoint automatically occurs at a log switch.
- When we will specify the parameter fast_start_mttr_target =< No of Second > .
- When normally forced by the administrator.
- If the data file is offline checkpoint will occur.
Question 41
Explanation
- DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
- CREATE - to create database and its objects like (table, index, views, store procedure, function and triggers)
- ALTER - alters the structure of the existing database
- DROP - delete objects from the database
- TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
- COMMENT - add comments to the data dictionary
- RENAME - rename an object