Please start from declare the variable  Using SQL*Plus and SQL Developer tool, complete the following tasks  a. Create a PL/SQL script to display all user accounts and their account status. b. Create a PL/SQL script to display all OPEN user accounts and their default tablespace  information. c. Create a PL/SQL script to display all LOCKED user account and the expiry date of their  passwords.

plz help in sql In Triggers, BEFORE means before the changes are made in memory but after the changes are permanently saved to disk. Select one: a. True b. False

Database  Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…

Subqueries--Create an sql script to answer the following questions.--List all products whose unit price is less than the average price.--List the shipper id, shipping company and freight cost for the order with the lowest freight charge.--List all products with their highest unit price, i.e. not discounted. --List the average unit price for each product category and--the average unit price without discounts

A SQL Data Manipulation command like UPDATE or INSERT immediately saves the result to disk without further intervention from the user.   Question 31 options:   1) True   2) False

please use sql to answer the following question

Create an anonymous block in PL/SQL to list all the countries from Country table where Currency contain keyword ‘Dollar’. Perform following steps: Create user define type with name of the country, currency.Type should contain datatype for name and currency using %type only.Display should include Name of the country, currency code using user defined type. Filter for the data : All the countries from Country table where Currency contain keyword ‘Dollar’.

Is it possible to use PL/SQL or T-SQL procedures on MySQL?

Write the following inserts, deletes, or updates in SQL, using the universityschema. Increase the salary of each instructor in the Comp. Sci. department by 10%.

Answer the following SQL questions using MySQL command language in MySQL Workbench, sakila database environment!