2024 - BCA [4th Semester] Relational Database Management System and Oracle - Purnea University

 

 PU-4 BCA-3
BCA (IV-SEMESTER)
EXAMINATION, JUNE-2024
RELATIONAL DATABASE MANAGEMENT
SYSTEM AND ORACLE

Time : 3 Hours                                                                              Full Marks : 70

Note: The questions are equal value.
Answer any five questions.

Q1. Multiple Choice Questions.

    i.)     Which component of an RDBMS is responsible for managing data storage and retrieval?

  1. Data Dictionary
  2. Kernel
  3. Client/Server
  4. System Process
    ii)    What is the primary role of a Database Administrator (DBA) in an Oracle database environment?
  1. Writing Application Code
  2. Managing Oracle files and processes
  3. Designing user interfaces
  4. Creating end-user reports
    iii)    Which Oracle component manages the execution of SQL queries and transactions?
  1. Oracle Memory
  2. User Process
  3. System Process
  4. Oracle Files
    iv)    Which SQL command is used to remove a table from the database?
  1. DELETE TABLE
  2. DROP TABLE
  3. REMOVE TABLE
  4. TRUNCATE TABLE
    v)    What type of constraint ensures that a column in a table must have a unique value across all rows?
  1. Default Key
  2. Foregin Key
  3. Unique Key
  4. Check Constraint
    vi)    Which SQL clause is used to combine rows from multiple tables based on a related column?
  1. UNION
  2. JOIN
  3. INTERSECT
  4. MINUS
    vii)    In PL/SQL, what is used to handle errors that occur during the execution of a block?
  1. GOTO Statement
  2. Error Handling Block
  3. RAISE_APPLICATION_ERROR Procedure
  4. Exception Block
    viii)    What is the purpose of a view in SQL?
  1. To update database records
  2. To create a virtual table based on a query
  3. To manage user permission
  4. To perform data backup
    ix)    Which command is used to grant permissions on an object created by a user?
  1. GRANT
  2. REVOKE
  3. PERMIT
  4. ALLOW
    x)    What is the key difference between a procedure and a function in PL/SQL?

  1. Procedures can return values, but functions cannot
  2. Functions can return values, but procedures cannot
  3. Procedures cannot be called from other procedures
  4. Functions cannot be called within SQL statements

Q2.  Explain how the Oracle Database Administrator (DBA) manages these components to ensure database integrity and performance.

Q3.  Discuss the various types of data constraints in SQL, including column-level and table-level constraints. Provide examples of how to define constraints such as NOT NULL, UNIQUE, DEFAULT, and FOREIGN KEY in table creation statements.

Q4.  Detail the process of joining multiple tables in SQL. Explain the different types of joins, including INNER JOIN, LEFT JOIN, and RIGHT JOIN.

Q5.  Discuss error handling in PL/SQL. Explain how to use built-in exceptions and user-defined exceptions to manage errors in PL/SQL programs.

Q6.  Describe the concepts of procedures and functions in PL/SQL. Explain their creation, execution, and advantages.

Q7.  Explain the use of triggers in Oracle databases. Describe the different types of triggers (e.g.,BEFORE INSERT, AFTER UPDATE) and their applications.

Q8.  Provide an example of a simple PL/SQL block that includes variable declaration, assignment, and a basic SQL query.

Q9.  Discuss how the relational model's components (tables, keys, relationships) contribute to data management in an RDBMS.

Q10. Explain how the Oracle Database Administrator (DBA) manages these components to ensure database integrity and performance.

--x--

Related Topics: 2024 4th Semseter BCA Purnea University RDBMS
Home Papers Notes