सूची-I (SQL स्ट्रिंग फ़ंक्शन) को सूची-II (विवरण) के साथ सुमेलित कीजिए: सूची-I (A) SUBSTR() (B) TRIM() (C) INSTR() (D) LEFT() सूची-II (I) एक स्ट्रिंग में सबस्ट्रिंग की स्थिति (position) ज्ञात करना। (II) एक स्ट्रिंग से सबस्ट्रिंग निकालना (extract)। (III) स्ट्रिंग के बाईं ओर से वर्णों (characters) को निकालना। (IV) स्ट्रिंग के दोनों ओर से रिक्त स्थानों (spaces) को हटाना। नीचे दिए गए विकल्पों में से सही उत्तर चुनिए:

Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R. Assertion A: An SQL View does not physically store data, despite its ability to consolidate complex joins and aggregations into a reusable structure. Reason R: An SQL View is a virtual table defined by a stored SELECT query, meaning data is dynamically fetched from base tables each time the view is accessed. In the light of the above statements, choose the most appropriate answer from the options given below:

Consider the following statements regarding foundational database system definitions: Statement 1: A database is defined as the raw, unprocessed facts and figures without context that are collected for systematic retrieval. Statement 2: A Database Management System (DBMS) is the intermediary software managing the database, providing data abstraction and ensuring security and integrity. Which of the statements given above is/are correct?