दो तालिकाओं (tables) पर विचार करें: Professor और Department। सभी प्रोफेसरों के साथ-साथ उनके संबंधित विभाग के नाम प्राप्त करने के लिए, यह सुनिश्चित करते हुए कि किसी भी विभाग में असाइन नहीं किए गए प्रोफेसर भी आउटपुट में शामिल हों, किस SQL JOIN क्लॉज का उपयोग किया जाना चाहिए?

Given below are two statements: one is labelled as Assertion (A) and the other is labelled as Reason (R). Assertion (A): Data warehouses are designed to support strategic decision-making through integrated and historical data. Reason (R): Data warehouses primarily process day-to-day operational transactions in real time. In the light of the above statements, choose the most appropriate answer from the options given below:

Match LIST-I with LIST-II regarding NoSQL database types and their built-in primary indexing mechanisms: LIST-I (NoSQL Database Type) A. Key-Value Store B. Document Database C. Column-Family Store D. Graph Database LIST-II (Primary Indexing Mechanism) I. Partition key (hash) plus clustering columns II. Node labels with relationship types III. Hash-based index (O(1) lookup) IV. _id field (primary B-tree index) Choose the correct answer from the options given below: