Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Procedure, The company wants to offer an incentive of free shipping to those customers who have not returned for two months. Create a procedure named PROMO_SHIP_SP that determines who these customers
Write an UPDATE statement to change the phone number of employee with EmployeeNumber 11 to 360-287-8810. Run this SQL statement.
Write SQL statements that will retrieve the following data from a database, using Subqueries and Joins. Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the f
Write a procedure which take SSN and final score which will change the final score of the student, write the old and new scores.
Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.
Write down a query to exhibit the ENAME, COMM, SAL, HIREDATE, NEW_SAL. The NEW_SAL will be computed by the following rule:
List all the names of people who work for the company Wipro all along with the cities they live in.
Write down an SQL DDL definition of this database.
Sketch the diagram of logical structure of oracle database and describe it in brief. Discuss and critically illustrate out the objectives of Query Processing.
The ADO (ActiveX Data Object) data control is the primary interface between the Visual Basic application and the database. Illustrate out the following properties associated with ADO data control:
The following is a sample report from UTM Restaurant demonstrating normalised data. You’re required to show the First, Second and Third Normal Forms of following:
List and briefly illustrate out five (5) potential benefits of database approach compared to conventional file systems.
Demonstrate a equi Join operation. How is a trigger different from procedure?
What does SQL signify? Describe it in detail with its subcategories. What SQL statement is employed to delete the table ‘Student’?
What is Normalization and its need. Explain the Anomalies in 3NF relations? what is a stored procedure? why do we require them? How are they different from functions and triggers?
Distinguish between SQL and embedded SQL.What is Sequence? How it is created in PL-SQL?
Write down the syntax of Table Creation and Deletion commands. What do you understand by view? How it is created in PL SQL?
What is advantage of using indexes? Write the statements to create and delete an index? Write down the types of integrity constraints used in Transact-SQL.
Write fitting SQL for the following English queries.: Find the names of parts whose weight is between 10 and 15. Which supplier supplied what parts to the 'Sorter' job?
Write the syntax of ‘ORDER BY’ clause used in ‘SELECT’ statement. Distinguish between GRANT and REVOKE command.
Use MySQL to create database of information about used trucks for sale. Make up equipment which characterizes trucks. Get the raw data from the ad section of the newspaper, Instead of the states in
Using Oracle 11g sql plus create a single script file drop the tables you are creating, create the tables for the project, insert sample data into the tables.
Present table creation statements (consisting of constraints) for Database Model. Present them all in a single script file.
Write a PL/SQL block which includes a procedure get_customer which accepts a project title and returns the customer name and location for that project and create a trigger to enforce the constraint.