Q5: Exporting and Importing Data: • Design and develop SQL DML statements to demonstrate exporting tables to external files of different file formats such as CSV, XLSX, TXT, etc. • Design and develop SQL DML statements to demonstrate importing data from external files of different file formats such as CSV, XLSX, TXT, etc.

Other Questions in Database Management System

See All Available Questions

Q1: SQL Queries: • Design and Develop SQL DDL statements which demonstrate the use of SQL objects such as Table, View, Index, Sequence, Synonym, different constraints etc. • Write at least 10 SQL queries on the suitable database application using SQL DML statements. Note: Instructor will design the queries which demonstrate the use of concepts like Insert, Select, Update, Delete with operators, functions, and set operator etc.
Q2: SQL Queries – all types of Join, Sub-Query and View: Write at least 10 SQL queries for suitable database application using SQL DML statements. Note: Instructor will design the queries which demonstrate the use of concepts like all types of Join, Sub-Query and View.
Q3: MongoDB Queries: Design and Develop MongoDB Queries using CRUD operations. (Use CRUD operations, SAVE method, logical operators etc.)
Q4: Unnamed PL/SQL code block: Use of Control structure and Exception handling is mandatory. Suggested Problem statement: Consider Tables: 1. Borrower (Roll_no, Name, Date_of_Issue, Name_of_Book, Status) 2. Fine (Roll_no, Date, Amt) • Accept Roll_no and Name_of_Book from user. • Check the number of days (from Date_of_Issue). • If days are between 15 to 30 then fine amount will be Rs 5 per day. • If no. of days > 30, per day fine will be Rs 50 per day and for days less than 30, Rs. 5 per day. • After submitting the book, status will change from I to R. • If condition of fine is true, then details will be stored into fine table. • Also handles the exception by named exception handler or user define exception handler. OR MongoDB – Aggregation and Indexing: • Design and Develop MongoDB Queries using aggregation and indexing with suitable example using MongoDB. MongoDB – Map-reduce operations: • Implement Map-reduce operation with suitable example using MongoDB.
Q6: Cursors (All types: Implicit, Explicit, Cursor FOR Loop, Parameterized Cursor): Write a PL/SQL block of code using parameterized Cursor that will merge the data available in the newly created table N_Roll_Call with the data available in the table O_Roll_Call. If the data in the first table already exists in the second table then that data should be skipped. Note: Instructor will frame the problem statement for writing PL/SQL block using all types of Cursors in line with above statement.
Q7: Database Connectivity: Write a program to implement MySQL/Oracle database connectivity with any front-end language to implement Database navigation operations (add, delete, edit etc.)