Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Dependant Variable listed as a one/two word term, and its scale of measurement. How you plan to measure your DV?
Explain the risks of using SQL Database Mail and how it could be vulnerable to malicious exploits. If possible show or provide a working example.
Write a select statement that returns 3 columns from the Invoices table: VendorID, InvoiceCount, and TotalPaid.
You might delete a table that you did not intend to. What are some practices that you can deploy to prevent accidental changes to the tables?
Views are an important part of controlling access to data in a database. Define a view and explain how it helps restrict data access.
write a single SQL statement that shows the following data: - From the CustomerOrder table, show the OrderID and TotalPaid.
The following users U102,U105,U200 need to be granted UPDATE and DELETE privileges to table Faculty. Write the proper SQL DCL statement to accomplish this task.
List the names and ages of actors who have appeared in a comedy produced by Studio MGM. List the names of directors who have directed a drama or a comedy.
Assuming that the data is available as a database table called "orders", write & paste a SQL statement that will display only the 10 restaurant ids
Find a SQL query that computes a set difference and returns false positive(s) over a database with null values. Show correctness of your answer using example.
You are to use SQL Developer to perform the requested operations based on tables. I need to see your SQL command followed immediately by the result.
You are to use comments to record your name. Which orders were placed before April 2, 2009? List each order number, and order date.
Show any employees who were hired before 1995 regardless of their salary. Show LName, HDate (sort ascending), Salary, and Title for these employees.
Give a table already in 1NF but not in 2NF, along with the functional dependencies. Illustrate the process of normalisation of your table to 2NF.
Identifying the entities and set their attributes. Draw E-R model and indicate the maximum cardinalities and existence.
Create and populate object tables to contain instances of the object types. All SQL queries and their outputs should be shown.
How do we implement incremental load in SSIS? When is this done? How do we implement full fresh in SSIS? Why is this done?
Choose a business activity. Write down the sequence of steps necessary for the transaction to be completed.
Discuss security issues with the Pitt Fitness database. Who should have access to the database? Can any employee change the data?
Explain of how the 2 breaches for both SQL and CXS occurred and if they were isolated to that market segment.
Problem: Write detail on PostgreSQL and SQLite database.
Problem: Explain which components of SQL Server exist to deliver reports.
How do I start a command prompt and use the mysqldump program to create a full backup of the My Guitar Shop database in MySQL Workbench?
How are you going to choose the best value for k? What are the k-nn algorithm's shortcomings? Give at least two examples and elaborate on each one.
Write a query to display patron ID, first name, last name, book title, checkout date for books that are still checked out.