MYSQL Questions and Answers

1. Which of the following acts as the internal layer in the three-tier architecture? the user interface the application server the database server any of this 6. In terms of the following relations: A...

. Question 14 (3 points) Given the following two relations R S a b a N A N U W H W Match the RA expressions with their corresponding SQL queries 1. SELECT DISTINCT R.a, S.a FROM R, S; J R.a, S.a ( R...

Write a PROCEDURE called NUM2DIRECTION with one IN parameter of type number. Your procedure will take as input a number between 0 and 360. It will send to the screen the closest equivalent in letters...

Using Oracle SQL 1. Write a SQL query using subqueries to find all orders who have the order date above the minimum order date and who have ordered before order id 77(Hint 2 subquery and group fu...

Please click this link then copy and paste it on ORACLE SQL DEVELOPER APP, then run it: http://dbs211.ca/docs/DBS311_SampleDatabase_CreationScript.txt After successfully running the script, please ...

Question 12 (3 points) Using the following ER Diagram, the single line going out of EMPLOYEE and into the subtype circle denotes that Wellness Hospital EMPLOYEE 0 An instance of EMPLOYEE can belong to...

Question 19 (3 points) Using the following ER Diagram, what type of relationship is the assigned to/assigned relationship? EMPLOYEE FirstName LastName JobTitle | | | ___ ___—_mentor trams/trained by...

Question 11 (3 points) Using the following ER Diagram, the 'd' in the subtype circle denotes that Wellness Hospital EMPLOYEE EmpID DEPARTMENT assigned to/assigned Dept# FirstName LastName Name Job Tit...

Using the following ER Diagram, what type of relationship is the assigned to/assigned relationship? Wellness Hospital EMPLOYEE FitstName LastNarna. Using the following ER Diagram, what type of relatio...

PART II. For each question' show the theoretical relational algebra statement that would accomplish what is requested (not SQL statements) and the resulting relation. Use the following relations to an...

Question 4 (3 points) ~/ Saved If we have two relations, A and B, A RIGHT OUTER JOIN B ON A.id = B.id returns: 6) All rows in A and matching rows in B, where there is no match in B null values will ap...

Task3 : Updating Order Status Create a procedure named STATUS_SHIP_SP that allows an employee in the Shipping. Department to update an order status to add shipping information. The BB_BASKETS...

ISTE-230 Introduction to Database & Data Modeling Homework #7 - Implementing a Relational Schema using SQL DUE: Name: _____________________________________________ Submit your script to th...

REFERENCE: https://dev.mysql.com/doc/refman/8.0/en/explain-output.html 5.8 LAB - Create index and explain (Sakila) Refer to the film table of the Sakila database. This lab loads film with 100 rows ...

SCRIPT: https://we.tl/t-2AGdbEckS2 Create a procedure named ADDING that accepts a product ID, basket ID, price, quantity, size code option (1 or 2), and form code option (3 or 4) and uses this info...

Assuming that the following table is created and filled with data, Write a statment to remove any record having courseID='100' . Section Field Name type size constraints Refrencing table Ref...

Write an update statment to change the CourseID from '100' to '200' for all records in the table. Section Field Name type size constraints Refrencing table Refrencing field SectionNo Number 4 PK...

Assuming that the following table is created, write a statement to add one record using courseID='100' and use data from your choice. Section Field Name type size constraints Refrencing table Re...

Write a statement to drop the following table with all the associated constraints . Section Field Name type size constraints Refrencing table Refrencing field SectionNo Number 4 PK Semeste...

Create a table inventory having the below columns. Also create a Primary Key for this table by choosing the most suitable column: product_id : a numerical (precision = any length, scale = 0) column pr...

1. Create a table inventory having the below columns. Also create a Primary Key for this table by choosing the most suitable column: product_id : a numerical (precision = any length, scale = 0) col...

1. Create a table inventory having the below columns. Also create a Pn'maryr Key for this table by choosing the most suitable column: a. product_id: a numen'cal (precision = any length' scale = 0) c...

1 . Which of the below is not a single row function? a. ROWNUM b. SYSDATE c. MONTHS_BETWEEN d. SQRT 2. Which of the below clauses of an SQL statement is the 3rd one in th...

Create a table inventory having the below columns. Also create a Primary Key for this table by choosing the most suitable column: product_id: a numerical (precision = any length, scale = 0) column pro...

1, What data base property enables Query Optimizer to automatically create stats for runtime plans Select one: a. Auto Close b. Auto Create Statistics c. Auto Shrink 2, Which tool ha...

1,You can view the SID for users of the server by running Select one: a. select * from sys.server_principals b. exec sp_help c. exec sp_updatestats d. exec sp_who 2, All users ...

1, What step in Risk Identification involves what actual or potential threats exist for each asset and how likely they are to occur. Select one: a. Risk assessment b. Vulnerability assessment ?...

1, Which of the following is true about the transaction log? Select one: a.It is best kept on a physical drive that is separate from the database files. b.It is best to keep RAID 1 storage. ?...

Which tool allows you to import, transform and export data. These operations are managed as packages. Select one: a. SQL Server Profiler b. SQL Server Management Studio c. Configuration M...

STUDENT (SID, Name, Dorm_No., DormType, DormCost, Club, ClubFee, ClubManager, Nickname) Assume that students pay different dorm costs, depending on the type of room they live in. A student can join ma...

Write an SQL query that will find any customers who have not placed orders. use PVFC database from the drive below. Files needed can be found in this google drive as I cant upload them here. https:/...