Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
How do you hash a password (hardcode the password to a hash()) which was already created in combination of the database using php/sql?
What tools could you use to find out the tables, indexes, and sequences in the database so they can be dropped?
What type of situation using MongoDB is better than relational databases? Why? What type of situation using relational databases is better? Why?
The StoreSales table contains the following columns: The primary key StoreSalesID. What is the SQL to compare each Store's current year vs prior year sales?
The primary key SalesID, Date, Store, Product, UnitsSold and PricePerUnit. What is the SQL to retrieve the Top 5 products by total sales over the last 12 months
Write PL/SQL script to create function to return the total number of options on a car given the serial number of car. Include base options and invoice options.
Create a parameterized query (prepared statement) in C++ that prompts for an employee number and displays information their firstname, lastname, and job title.
What is our employee total count for each department? For each employee, list the employee last name with their department name.
Provide a list of supply orders, including contact information for the vendor, the name of the clerk who submitted the order, the order date, the receipt date.
Write PL/SQL script that uses a trigger that converts to upper case of the customer name, city, street and Province for Customer table during INSERT OR UPDATE.
Differentiate between an OLTP and a data warehouse. How would you distinguish between two-tier and three-tier client/server architectures?
What are the aggregates that the analyst would start with, and what are the relevant drill-down operations that the analyst would need to execute?
Create the database in the actual database application as indicated by your professor (i.e Microsoft Access, MySQL or Oracle, etc.).
Did Martoma act ethically in this case? Did Dr. Gilman act ethically in this case? What are beliefs without applying the law?
Write the JavaScript code, in less than 9 lines of code, to sing me Happy Birthday to the document window. Use the variables name and i in your code.
What classes will you need for the client program? What classes will you need for the server program?
Write a recursive function that takes a number n and an array of integers as input and returns true if n is in the given list and false otherwise.
Write a static method that receives three integer arguments, computes their sum, then divides the sum by the third one to form a quotient.
Write the method left2, which accepts a String argument and returns a version of the string where the first two characters are moved to the end.
What characteristic must a sort algorithm have in order to break the O(N2) barrier? Why does that allow the sort to go below that threshold? Explain in detail.
Application of education: How are you able to apply your academic learning to the internship experience?
What are the important points to keep in mind while using loops in a Java program? List 2 types of loops and situations where they can be used.
Write Java class which models a blender. Your class should have at least two meaningful attributes, one method to do some action on or for the object.
Compose a test program that measures the execution time for multiplying two 2,000 * 2,000 matrices using the parallel and sequential methods, respectively.
Design and implement an interactive Java program for customers of Sanderson's Ice Cream Sundaes to place an order.