C.U.SHAH UNIVERSITY Winter Examination-2015 Subject Name: Advanced Database Management System Subject Code: 4CS05BDB1
Branch: B. C. A.
Semester: 5 Date: 02/12/2015 Time: 02:30 To 05:30 Marks: 70 Instructions: (1) Use of Programmable calculator & any other electronic instrument is prohibited. (2) Instructions written on main answer book are strictly to be obeyed. (3) Draw neat diagrams and figures (if necessary) at right places. (4) Assume suitable data if needed. Q-1 Attempt the following questions: [14] (1) The ‘Relational Model’ of database was introduced by: A) Dr. E. F. Codd B) Dr. K. J. Morgan C) Dr. K. V. Roger D) None of above (2) The Query is processed by: A) Client B) Server C) Network D) All of above (3) SQL commands can be written in mixed case (Upper Case + Lower Case) A) True B) False C) Always Capital D) Always Small (4) In Oracle, ORDER BY clause can arrange data using one column only A) True B) False C) Cannot Say D) None of above (5) The aggregate function is: A) Min B) Count C) Sum D) All of above (6) Which is the DML Statements? A) Create User B) Create Table C) Create Database D) Update (7) Total number of Foreign Key in the table: A) 0 (Zero) B) One C) More than one D) All of above (8) Inner Join is also called: A) Self Join B) Equi Join C) Non Equi Join D) Cross Join (9) The Sub Query appears usually: A) Inside SELECT clause B) Inside WHERE clause C) Inside FROM clause D) None of above (10) The sequence object always generates: A) Character Value B) Data Value C) Numerical Values D) Any Value (11) Which part of PL/SQL block is Mandatory? A) Declaration Section B) Exception Section C) Execution Section D) All of above Page 1 || 3
(12) %ROWCOUNT returns: A) Total rows Fetched by Cursor B) Total no. of rows in Cursor C) Total rows processed by Cursor D) None of above (13) Which type of trigger will be fired first – when event occurs? A) Before – Row Level B) Before – Statement Level C) Both of above D) Cannot Say (14) Which of the following is the implicit cursor attributes? A) %FOUND B) %ROWCOUNT C) %ISOPEN D) All of above
Attempt any four questions from Q-2 to Q-8 Q-2 Attempt all questions a) What is RDBMS? Differentiate: DBMS with RDBMS [05] b) List various types of SQL Statement. Explain DDL statement in detail [05] c) Write all possible differences between SQL with SQL * Plus [04] Q-3 Attempt all questions a) What is Join? Explain Inner and Outer Join with example [05] b) What is Constraint? Explain Primary Key and Foreign Key constraints. [05] c) Explain SELECT statement with GROUP BY and ORDER BY clause with an example [04] Q-4 Attempt all questions a) Discuss View with suitable example [05] b) Explain Index in detail [05] c) Explain Rollback and Savepoint with an example [04] Q-5 Attempt all questions a) What is cursor? Explain Implicit Cursor with example [05] b) Explain PL/SQL block structure with example [05] c) What is Lock? Explain Lock Types [04] Q-6 Attempt all questions a) What is a Trigger? Explain with example [05] b) Explain Package with example [05] c) Differentiate : Procedure with Function [04] Q-7 Attempt all questions a) Explain Oracle Instance Architecture in detail [05] b) Explain Cold Backup and Hot Backup [05] c) Explain Control Files in detail [04]
Page 2 || 3
Q-8 Write the query in SQL for the following: a) Create the following tables: Emp_Master (Emp_no, Emp_name, Designation, Salary, City, Branch _no) Branch_Master (Branch _no, Branch _name) b) Display all the employee names who work in Branch name ‘Ahmedabad’ c) Display all the employee names who is having as ‘sh’ as last two character in their name
5.9 Distributed Serializability. 5.10 Classification of Concurrency Control Techniques ... 7.5 Global Query Optimization Algorithms. 7.6 Distributed Database Security. 7.7 View Management ... Laboratory Work with oracle latest version: Page 3 of 6. I
Give distinction between spanned and un-spanned file organization by giving. suitable examples. 2. Discuss about clustering index. 3. Who is DBA? Which are ...
Give distinction between spanned and un-spanned file organization with suitable. example. 05. b. Which are the different database system utilities? 05. c.
(c) What is XML ? How is it different from. HTML ? What are the advantages of XML ? Create an XML schema for list of students and. their marks 70. MCS-043 ...
issue no. and name. Any member can only. read the journal/magazine in library itself. i.e Journal/Magazine cannot be issued. CS-06 1 P.T.O.. Page 1 of 4 ...
1. What are the responsibilities of the DBA ? 3. 2. Explain program â data Independence. 3. 3. What do you mean by domain of an attribute ? Give one example.
2. a) Give an ER diagram for student database, with all essential ER concepts. 12. b) Write the ... b) Explain the ORACLE languages and interfaces briefly. 10. 8.
We might choose to identify a dependent by name alone in this situation, since it is ..... Each song is performed by one or more musicians, and a musician may ...
c) Discuss the classification of DBMS. 5. 2. a) What are the different types of attributes ? Explain with examples. 10. b) Explain the ER-to-relational mapping ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Main menu.