Contains data assisting day to day activities of the organization. May 15, 2022June 3, 2022 administrator Contains data assisting day to day activities of the organization.Operational databaseWell Done. Your Answer is Correct Keep it Up!Control databaseStrategic databaseSequential database
Data items grouped together for storage purposes are called a May 15, 2022May 15, 2022 administrator Data items grouped together for storage purposes are called arecordWell Done. Your Answer is Correct Keep it Up!titleliststring
SQL server stores index information in the ………… system table May 15, 2022June 3, 2022 administrator SQL server stores index information in the ………… system tablesys indexesWell Done. Your Answer is Correct Keep it Up!sysindsystem indexessyst indexes
The one guideline to be followed while designing the database is May 15, 2022May 15, 2022 administrator The one guideline to be followed while designing the database isIt should avoid/reduce the redundancy.Well Done. Your Answer is Correct Keep it Up!Unrelated data should be in the same table so that updating the data will be easy.A database design may be ambiguous.An entity should not have attributes
Is a preferred method for enforcing data integrity May 15, 2022May 15, 2022 administrator Is a preferred method for enforcing data integrityConstraintsWell Done. Your Answer is Correct Keep it Up!Stored procedureTriggersCursors
Which of the following is not a logical database structure? May 15, 2022May 15, 2022 administrator Which of the following is not a logical database structure?ChainWell Done. Your Answer is Correct Keep it Up!NetworkTreeRelational
Which if the following is not the type of data integrity. May 15, 2022May 15, 2022 administrator Which if the following is not the type of data integrity.Key integrityWell Done. Your Answer is Correct Keep it Up!Domain integrityEntity integrityReferential integrity
Which can be used to delete all the rows if a table? May 15, 2022May 15, 2022 administrator Which can be used to delete all the rows if a table?Delete * from table_nameWell Done. Your Answer is Correct Keep it Up!Delete from table_nameDelete table_nameall rows cannot be deleted at a time.
4NF stands for May 15, 2022May 15, 2022 administrator 4NF stands forFourth Normal FormWell Done. Your Answer is Correct Keep it Up!Fourth Normal FileFourth Normal FractionFourth Negative File
A ……………… allows to make copies of the database periodically to help in the cases of crashes & disasters. May 15, 2022May 15, 2022 administrator A ……………… allows to make copies of the database periodically to help in the cases of crashes & disasters.Backup UtilityWell Done. Your Answer is Correct Keep it Up!Recovery utilityMonitoring utilityData loading utility