IMT-37 DBMS (ORACLE)
PART– A
1. a. Describe what metadata are and what value they provide to the database system.
b. What are the advantages of having the DBMS between the end user’s applications and the database?
c. Discuss some considerations when designing a database.
2. a. List and briefly describe the different types database maintenance activities.
b. Database backups can be performed at different levels. List and describe these.
c. What are the classical approaches to database design?
3. a. Explain the differences between a centralized and decentralized approach to database design.
b. Explain how database designers design and normalize databases.
c. Explain the BCNF. How is it related to other normal forms?
4. a. What is a schema? How many schemas can be used in one database?
b. What command is used to save changes to the database? What is the syntax for this command?How do you delete a table from the database? Provide an example.
c. What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?
5. a. Explain normalization and its different forms.
b. Describe the need for convenient and safe backup storage.
c. Explain user requirements gathering as part of the DBA's end‐user support services.
PART– B
1. a. Explain heterogeneous distributed database systems.
b. A fully distributed database management system must perform all of the functions of a centralized DBMS. Do you agree? Why or why not?
c. Describe the five types of users identified in a database system.
2. a. Describe the DBA’s managerial role.
b. What are the three basic techniques to control deadlocks?
c. How does a shared/exclusive lock schema increase the lock manager’s overhead?
3. a. Describe a conceptual model and its advantages. What is the most widely used conceptual model?
b. What is a key and why is it important in the relational model? Describe the use of nulls in a database.
c. Explain single‐valued attributes and provide an example. Explain the difference between simple and composite attributes. Provide at least one example of each.
4. a. Describe specialization and generalization.
b. Explain the different types of join operations. What are they and how do they work?
c. What are SQL functions and when are they used? Provide a couple of examples of situations in which they are necessary.
5. a. Describe the characteristics of an Oracle sequence.
b. Triggers are critical to proper database operation and management. What are some of the ways that triggers are used?
c. Describe query optimization.
IMT CDL Assignments
Dear Student,
As per your last email you requested a solved assignment which is always available with us. We ensure you that the answer quality would be the best and you will get up to 90% to 100% marks in the assignments purchased from us. We have an expert on every subject working with us. The subject matter experts are highly qualified and deliver their best for you over and over again.
Please have a look at the price list mentioned below and send us a reply on this e-mail to let us know which assignment you want from us.
Type A- Rs. per subject – This assignment is ready to use assignment for every student. (The content of this assignment is the same for every student. You may risk getting your marks deducted by the university due to plagiarism.)
Type B- Rs.per subject - This assignment is personalized and customized just for you. The answers of this assignment would not be shared with any other student. The content of this assignment would be unique and we will delete it from our database after sending it to you exclusively. (This assignment would have 0% plagiarism)
Type C - Rs. per Subject-Handwritten Assignment
If you want that your assignment should be written manually rather than being sent to you in a MS Word file or uploaded on the internet then we can do that for you. We will do your assignment manually and every answer would be created just for you. You only have to pay Rs._ per subject for handwritten assignments and we will make sure it gets to you on time every time. We can courier the assignment at your preferred address and you just have to receive it. This assignment will be delivered within a week’s time due to the fact that it needs more time to write down an answer than to type it. This assignment would also help you get around 90% to 100% marks because it would be done by our subject matter experts.
Type C- Rs. per subject Online assignment– This assignment is done by our staff members on your behalf. We will do it online by using your e-mail id and password. The answers we provide would be unique and will not be shared with any other student. (This assignment would also have 0% plagiarism)
Please note that you have to pay us in advance. All payment should be made in INR. As soon as we receive your payment, we will send your Type A assignment within 10 minutes only. If you have opted for Type B, we will send the assignment within 5 hours of receiving your payment. If you have opted for Type C, we will send your assignment within 24 hours of receiving the payment. Type B and Type C assignment submission takes more time because we customize each and every word of the assignment just for you. So we request you to be patient.
Pay Online
Now you can also make the payment online by the below mentioned link. We accept payments through Credit Card, Debit Card and Net Banking too.
Pay Offline
You can also pay us via NEFT / RTGS by visiting the nearest branch of your bank.
You can also deposit Cash by visiting the nearest branch of ICICI Bank.
Our process
After you have made the payment please email us your payment details with Assignment Name and Type Preference at solvezone@gmail.com. We will revert asap.
Note: For better response time, kindly use e-mail communication and avoid calling us. Our office timings are 9 AM to 6 PM.
Year: 2015