MS Access (MS एक्सेस) - Question Bank

Q 1. एक टेबल के एक कॉलम में एक फील्ड को क्या कहते हैं

  1. Database
  2. Attribute
  3. Tuple
  4. Data

Q 2. एक रिलेशनल डेटाबेस में एक संग्रह होता है

  1. Tables
  2. Fields
  3. Records
  4. Keys

Q 3. ER Model का component है

  1. Entity
  2. Attributes
  3. Relationship
  4. सभी

Q 4. Column header के रूप में उल्लेख किया गया है

  1. Table
  2. Relation
  3. Attributes
  4. Domain

Q 5. Table में row को विशिष्ट रूप से पहचानने के लिए एक key एक से अधिक attribute में होते हैं जिसे कहते हैं |

  1. Composite key
  2. Candidate key
  3. Primary key
  4. Foreign key
(default) 5 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`url`, `Institution`.`sort_name`, `Institution`.`city_id`, `Institution`.`state_id`, `Institution`.`address`, `Institution`.`pincode`, `Institution`.`logo`, `Institution`.`cover_photo`, `Institution`.`title`, `Institution`.`description`, `Institution`.`keywords`, `Institution`.`content`, `Institution`.`contact_no`, `Institution`.`email`, `Institution`.`exams`, `Institution`.`exams_json`, `Institution`.`status`, `Institution`.`created`, `Institution`.`modified`, `MocktestUrl`.`url` FROM `fliqicom_education`.`institutes` AS `Institution` LEFT JOIN `fliqicom_education`.`mocktest_urls` AS `MocktestUrl` ON (`MocktestUrl`.`target_id` = `Institution`.`id` AND `MocktestUrl`.`type` = 'institution') WHERE 1 = 1110
2SELECT `Trending`.`title`, `Trending`.`url` FROM `fliqicom_education`.`trendings` AS `Trending` WHERE `Trending`.`status` = 1440
3SELECT `Topic`.`id`, `Topic`.`subject_id`, `Topic`.`name`, `Topic`.`slug`, `Topic`.`created`, `Topic`.`modified`, `Topic`.`title`, `Topic`.`meta_keyword`, `Topic`.`meta_description`, `Topic`.`content`, `Topic`.`og_banner`, `Topic`.`status`, `EduSubject`.`id`, `EduSubject`.`parent_id`, `EduSubject`.`name`, `EduSubject`.`title`, `EduSubject`.`description`, `EduSubject`.`content`, `EduSubject`.`thumb`, `EduSubject`.`created`, `EduSubject`.`modified`, `EduSubject`.`active`, `EduSubject`.`featured`, `EduSubject`.`is_home`, `EduSubject`.`og_banner` FROM `fliqicom_education`.`topics` AS `Topic` LEFT JOIN `fliqicom_education`.`edu_subjects` AS `EduSubject` ON (`Topic`.`subject_id` = `EduSubject`.`id`) WHERE `Topic`.`slug` = 'ms-access' LIMIT 1110
4SELECT `TopicQuestion`.`id`, `TopicQuestion`.`topic_id`, `TopicQuestion`.`question_hindi`, `TopicQuestion`.`option1_hindi`, `TopicQuestion`.`option2_hindi`, `TopicQuestion`.`option3_hindi`, `TopicQuestion`.`option4_hindi`, `TopicQuestion`.`option5_hindi`, `TopicQuestion`.`answer_hindi`, `TopicQuestion`.`solution_hindi`, `TopicQuestion`.`question_eng`, `TopicQuestion`.`option1_eng`, `TopicQuestion`.`option2_eng`, `TopicQuestion`.`option3_eng`, `TopicQuestion`.`option4_eng`, `TopicQuestion`.`option5_eng`, `TopicQuestion`.`answer_eng`, `TopicQuestion`.`solution_eng`, `TopicQuestion`.`created`, `TopicQuestion`.`modified`, `TopicQuestion`.`question_year`, `TopicQuestion`.`link_question` FROM `fliqicom_education`.`topics_questions` AS `TopicQuestion` WHERE `TopicQuestion`.`topic_id` = 42 ORDER BY `TopicQuestion`.`id` DESC LIMIT 5550
5SELECT COUNT(*) AS `count` FROM `fliqicom_education`.`topics_questions` AS `TopicQuestion` WHERE `TopicQuestion`.`topic_id` = 42111
(fliqi) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)