Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance), write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.
Modify Oracle table data using the correct SQL statements. You must create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-
Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column. Group the result set by VendorName. Return only 10 rows, corr
If an employee works on every project except the one(s) controlled by the department that has no location in Houston, then list the employees social security number and name.
Will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. The lab will utilize a set of tables found in the script file (LeeBooks.sql)
Review EMPLOYEE table structure file within the course document (CSCI 507 - EMPLOYEE table structure - Final Exam -Section C Question.doc), design a relational schema to manage employee payroll (just
Advanced SQL. Define the various types of outer joins and define when each would be used. Provide scenarios when each would be used.
Write an UPDATE statement that modifies the VendorCopy table. Change the default account number to 403 for each vendor that has a default account number 400
Write an INSERT statement that adds a row to the VendorCopy table for each non-California vendor in the Vendors Table. (This will result in duplicate vendors in the VendoCopy Table).
Write an SQL CREATE TABLE statement to create the PET table without a referential integrity constraint on OwnerID in PET. Justify your choices of column properties. Why not make every column NOT NULL?
Select a specific author and list all books for that author. Include the title, year and ISBN number. Order the information alphabetically by title.
Given the table CUSTOMER (custID, Name, PhonNumber,AccountBalance), write the standard SQL query to retrives the Name and Phone Number of customers with a balance greater than 50
The statement below changes the amount column name to no column mame how can you change the column name or what is a different way to write the statement in SQL so it displays the amount column as mon
Microsoft Access does not fully support SQL 92 standards. Using the internet as a research tool, document how Access implementation differs from the standard. Use an example for clarity.
The table name will be METALS and will be used to store a description of various metals. The following offers some additional direction on how the table should be created.
As the DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Upon inspection, you observe that the customer table is joined in
This exercise requires that students know how to create queries and reports using information from multiple tables. The solutions provided here were created using the query wizard and report wizard ca
Employee (ssn, Name, dno, pid, sal, ...);Department (dno, dname, mgr_id, ...);Project (pid, startDate, endDate, ...);and the following indexes built in the database:
SQL Server has different security models for users connecting to a database. The DBA has the ability to use a SQL Server login or a Windows login. The Windows login can be a user or a group with users
.Write a SELECT statement that returns four columns:
Explain in Oracle how the WHERE clause and HAVING clause are similar and why you can use the HAVING with a group function but not a WHERE clause.
Consider the TCP procedure for estimating RTT. Suppose that α = 0:5. Let SampleRTT1 be theMost recent sample RTT, let SampleRTT2 be the next most recent sample RTT, and so on.
Modify the following SQL command so that the Rep_ ID column is the PRIMARY KEY for the table and the default value of Y is assigned to the Comm column. ( The Comm column indicates whether the sales re
Write a set of three SQL statements coded as a transaction to reflect the following change: United Parcel Service has been purchased by federal Express Corporation and the new company is named FedUp.