Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Bca - 305 (Old)

    Uploaded by

    bhurkamariya14
    305 bca file for practice

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Bca - 305 (Old)

    Uploaded by

    bhurkamariya14
    4 views2 pages
    305 bca file for practice

    Original Title

    BCA - 305(OLD)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    305 bca file for practice

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    4 views2 pages

    Bca - 305 (Old)

    Uploaded by

    bhurkamariya14
    305 bca file for practice

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    Dr.

    Babasaheb Ambedkar Open University


    Term End Examination March – 2021
    Course : BCA Date : 05-March-2021
    Subject Code : BCA - 305(OLD) Time : 10:00am to 12:00pm
    Subject Name : Relational Database Management Duration : 02 Hours
    System (RDBMS )
    Max. Marks : 50

    Section A
    Answer the following (Attempt any two) (20)
    1. Explain Codd's rules for relational database system?
    2. What is PL /SQL? Explain block of PL /SQL.
    3. Discuss the process of implementing triggers?
    4. Explain primary key, Foreeign key, Super key and Composite key.

    Section B
    Answer the following (Attempt any three) (15)
    1. Write short notes on: - SQL*Plus.
    2. .What is the function of Oracle?
    3. Write short notes on: - Interactive SQL
    4. What is a stored procedure? Explain how to create a stored procedure with suitable
    example?
    5. What is deadlock? Explain how deadlock is recoverd.

    Section C
    Part – A (Multiple Choice Questions) (10)
    1 What is the full form of SQL?
    A Structured Query Language B Structured Query List
    C Simple Query Language D None of the Mentioned
    2 A relational algebra operation annotated with instructions on how to evaluate it is
    called _______
    A Evaluation algebra B Evaluation plan
    C Evaluation primitive D Evaluation engine
    3 Which of the following data types does the SQL standard not support?
    A char(n) B String(n)
    C varchar(n) D float(n)
    4 The term attribute refers to a ___________ of a table.
    A Record B Tuple
    C Column D Key
    5 Address field of a person should not be part of primary key, since it is likely to
    A Dependent B Changed
    C Not changed D Too long
    6 By using which clause, the mode is OUT, so you cannot specify a parameter mode
    for output bind arguments?
    A USING Clause B RETURNING INTO Clause
    C Both A & B D None of the above
    7 Triggers are supported in
    A Delete B Update
    C Views D All of the mentioned
    8 Life cycle of typical cursor involves ______ steps in SQL Server
    A 2 B 3
    C 4 D 5
    9 In the PL/SQL block below, how many rows will be inserted in the messages table?
    DECLARE
    v_start_sales NUMBER := 2;
    v_end_sales NUMBER := 100;
    BEGIN
    FOR i IN v_start_sales..v_end_sales LOOP
    INSERT INTO messages(msgid)
    VALUES v_start_sales;
    END LOOP;
    END;
    A 0 B 99
    C 1 D 100
    10 What is the maximum number of ELSE clauses that can be included in an IF clause
    that is not nested?:
    A 1 B 0
    C 15 D Any number

    Part – B (Do as Directed) (05)


    State weather the following statement are True or False
    1 You can use Substitution variables anywhere in SQL and SQL*Plus commands.
    2 In semi colons comes the list defining each column in the table and what sort of data
    types it is.
    3 CEIL returns the next highest integer value regardless of the fraction.
    4 NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common
    errors found when executing a SELECT statement.
    5 Oracle predefined errors are not associated with specific error codes.

    *****

    You might also like