After establishing the connection to fetch the data from the table of a database in SQL into a DataFrame, which of the following function will be used?
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()
Show Hint
- (A), (B) and (D) only
- (A), (B) and (C) only
- (A), (B), (C) and (D)
- (B), (C) and (D) only
The Correct Option is A
Solution and Explanation
Pandas provides multiple functions to fetch data from SQL into DataFrames:
pandas.read__sql__query(): Used when you want to run a SQL query string and get the result as a DataFrame.
pandas.read__sql__table(): Directly reads an entire SQL table into a DataFrame.
pandas.read__sql(): A flexible function that can take either a query or a table name as an argument.
Step 2: Checking validity of each option.
- Option (A): Correct. Commonly used for executing queries.
- Option (B): Correct. Used for fetching the entire table.
- Option (C): Incorrect. \texttt{read__sql__query__table()} does not exist in pandas.
- Option (D): Correct. A flexible option for both queries and tables.
Step 3: Conclusion.
Hence, correct functions are (A), (B) and (D).
Final Answer: \[ \boxed{(A), (B) \text{ and } (D) \text{ only}} \]
Top Questions on SQL
Give the output of the query: SELECT MONTH("2010-03-05");
- Match List-I with List-II.
List-I List-II (A) SUBSTR() (II) To extract a substring from a string. (B) TRIM() (IV) To remove spaces from both sides of the string. (C) INSTR() (I) To find the position of a substring in a string. (D) LEFT() (III) To extract characters from the left side of the string. Given the following table:
ENO SALARY A101 4000 B109 NULL C508 6000 A305 2000 State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
- Match List-I with List-II:
List-I List-II (A) group by (III) having (B) mid() (IV) text function (C) count() (II) aggregate function (D) mod() (I) math function - State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]
Questions Asked in CUET exam
- Five people—A, B, C, D, and E—are sitting in a row facing north. A is to the immediate right of D. B is at one of the ends. C is sitting between E and A. Who is sitting exactly in the middle?
- CUET (UG) - 2025
- Ordering and Ranking
A consumer experiences the following total utility from consuming a certain good:
If the price per unit is ₹4, at what quantity does the consumer stop purchasing under the equilibrium condition where M U m = 5?
- CUET (UG) - 2025
- Consumer Behavior
The Darsanams of the Gosangi
Over the costumes, Gosangi wears various objects made up of leather, shells, metal and threads as ornaments. Traditionally, the prominent among them is known as Darsanam-s, which literally means vision or suggesting that which is visible. There are altogether seven Darsanams, which can be neither considered as costumes nor ornaments. But, for an outsider, they may look like ornaments. The first Darsanam that Gosangi wears,cover chest and the back. This is traditionally identified as Rommu Darsanam or Sanku Darsanam. The second one is tied around the neck and called as Kanta Darsanam. The third and fourth ones are tied around the arms of left and right hands. The fifth and sixth ones are tied to the left and right wrists. (For these specific names are mentioned by the performers). The seventh one is known as Siro Darsanam, and it is tied around the already tied hair (koppu). The performers also know all these Dasanam except the Rommu Darsanam and Dasthavejulu (records).- CUET (UG) - 2025
- Major Folk Dances of India
Percussive Musical Instruments of India
India is very rich in the number and variety of musical instruments. From time immemorial, musical instruments have been connected with various Gods and goddesses according to mythol ogy. Musical Instruments have been classified into Thata, Avanadha, Ghana and Sushira. We came across this classification first in Natyashastra. Thata variety, is an instrument with strings and played by plucking or bowing. The instruments like Veena, Sitar, violin, Sarangi etc. come under this category. The Avandha variety are instruments with skin-covered heads, and are played by beating on both sides or one side. Mridangam, Pakhawaj, Tabla etc. come under this category. Ghana vadyas are those made with metal content. Manjira, Ghatom etc. are some of the examples of Ghana Vadya. Sushira Vadya are those instruments with holes and make the sound by blowing air through the holes. Flute, Nagaswaram, Saxophone, Clarinet are some of the examples.- CUET (UG) - 2025
- Indian Music
Mohiniyattam
Mohiniyattam, literally Dance of the Enchanttress, has its seeds in the deep past of Kerala. Its present form, designed exclusively for the female dancer, is however, a recent creation inspired by the living matrix of Kerala’s social ensemble dances performed on festive occa sions like Kaikottikali and Thiruvathirakali, and Nangyar Kootu, The female component of the highly stylized Kudiyattam, a souviour of Sanskrit theatre. The word, Mohini, occurs in an eighteenth-century Malayalam commentary of the Vyavah¯aram¯ala composed two hundred years earlier by Mazhamangalam Narayanan Nambudiri. Much later, the creator of Ottam Thullal, Kunjan Nambiar in his Goshayatra mentions Mohiniyattam. Reformer Vallathol traced the dance right down to the days of the Silappadikaram because of the definite reference to Ker ala’s Chakyars while scholars like Pisharoti believed the dance had a six hundred-year-old history. Kalyanikuttyamma, Kunjukuttyamma, Kanak Rele are some of the great dancers of Mohiniyattam.- CUET (UG) - 2025
- Indian Classical Dance