Out of many types of DBMS users, ................ is responsible to determine the requirements of the end users and then develop specifications to meet the requirements.
Show Hint
- DBA
- Application Programmers
- System Analyst
- Tester
The Correct Option is C
Solution and Explanation
The System Analyst plays a key role in bridging the gap between end users and the technical team.
Their primary responsibility is to gather requirements from stakeholders and translate them into clear, technical specifications.
System analysts analyze user needs, evaluate feasibility, create requirement documentation, and help in system design.
They ensure the database system is user-friendly, efficient, and tailored to organizational goals.
Unlike a DBA who manages the database operations or programmers who write code, the system analyst focuses on requirement analysis and solution design.
Therefore, the correct answer is (C) System Analyst.
Top Questions on Database Management Systems
- If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more frequently in order to maintain the dependencies?
- GATE DA - 2025
- Computer Science and IT Engineering
- Database Management Systems
- Consider the following two relations, named Customer and Person, in a database:
\[ \text{Person} \left( \begin{array}{l} \text{aadhaar CHAR(12) PRIMARY KEY,} \\ \text{name VARCHAR (32);} \end{array} \right) \]
\[ \text{Customer} \left( \begin{array}{l} \text{name VARCHAR (32),} \\ \text{email VARCHAR(32) PRIMARY KEY,} \\ \text{phone CHAR(10),} \\ \text{aadhaar CHAR(12),} \\ \text{FOREIGN KEY (aadhaar) REFERENCES Person (aadhaar);} \end{array} \right) \]
Which of the following statements is/are correct?- GATE DA - 2025
- Computer Science and IT Engineering
- Database Management Systems
- Consider a database relation \( R \) with attributes \( A, B, C, D, E, F, G \), and having the following functional dependencies: \[ A \rightarrow BCEF \quad E \rightarrow DG \quad BC \rightarrow A \] Which of the following statements is/are correct?
- GATE DA - 2025
- Computer Science and IT Engineering
- Database Management Systems
Consider the following database tables of a sports league. player (\( pid \), \( pname \), \( age \)) coach (\( cid \), \( cname \)) team (\( tid \), \( tname \), \( city \), \( cid \)) members (\( pid \), \( tid \)) An instance of the table and an SQL query are given. Player table
coach table:
team table:
members table:
SQL query: \[ {SELECT MIN(P.age)} \] \[ {FROM player P} \] \[ {WHERE P.pid IN (} \] \[ { SELECT M.pid} \] \[ { FROM team T, coach C, members M} \] \[ { WHERE C.cname = 'Mark'} \] \[ { AND T.cid = C.cid} \] \[ { AND M.tid = T.tid)} \] The value returned by the given SQL query is __________. (Answer in integer)- GATE CS - 2025
- Computer Science and IT Engineering
- Database Management Systems
- Consider a relational schema team(name, city, owner), with functional dependencies \( \{ {name} \rightarrow {city}, {name} \rightarrow {owner} \} \). The relation team is decomposed into two relations, \( t_1({name}, {city}) \) and \( t_2({name}, {owner}) \). Which of the following statement(s) is/are TRUE?
- GATE CS - 2025
- Computer Science and IT Engineering
- Database Management Systems
Questions Asked in CBSE CLASS XII exam
- Two statements are given, one labelled Assertion (A) and the other labelled Reason (R). Select the correct answer from the codes (A), (B), (C), and (D) as given below.
Assertion (A): In double slit experiment, if one slit is closed, diffraction pattern due to the other slit will appear on the screen.
Reason (R): For interference, at least two waves are required.
- CBSE CLASS XII - 2025
- Wave optics
- Two small solid metal balls A and B of radii \(R\) and \(2R\) having charge densities 2 and 3 respectively are kept far apart. Find the charge densities on A and B after they are connected by a conducting wire.
- CBSE CLASS XII - 2025
- Electrostatics
Aakash and Baadal entered into partnership on 1st October 2023 with capitals of Rs 80,00,000 and Rs 60,00,000 respectively. They decided to share profits and losses equally. Partners were entitled to interest on capital @ 10 per annum as per the provisions of the partnership deed. Baadal is given a guarantee that his share of profit, after charging interest on capital, will not be less than Rs 7,00,000 per annum. Any deficiency arising on that account shall be met by Aakash. The profit of the firm for the year ended 31st March 2024 amounted to Rs 13,00,000.
Prepare Profit and Loss Appropriation Account for the year ended 31st March 2024.- CBSE CLASS XII - 2025
- Partnership
- In a Young’s double-slit experiment, the intensity at the central maximum in the interference pattern on the screen is \( I_0 \). Find the intensity at a point on the screen where the path difference between the interfering waves is \( \frac{\lambda}{6} \).
- CBSE CLASS XII - 2025
- Wave Optics
- Solve the following linear programming problem graphically: Maximise \( Z = x + 2y \) Subject to the constraints: \[ x - y \geq 0 \] \[ x - 2y \geq -2 \] \[ x \geq 0, \, y \geq 0 \]
- CBSE CLASS XII - 2025
- Linear Programming