The answer for Q.2 = d (notice explanation)

The answer for Q.3 = d

😂 have a break have a joke 😂

Database : Oracle Functions 📃📎⬇️

📎🗓 Figure DB 1.1

————————————————
| Database Exercise Questions |
————————————————
N.B. Consider the database shown above in Figure DB 1.1, whose schema is shown and do the practical exercises below.

(We assume you have installed Oracle’s default HR(Human Resource) database, it’s comes as a compacted package within the Oracle Enterprise 11G program.)
————————————————
Exercise Instruction : Write the SQL command used to manipulate in Oracle SQL Command Line program.

•Ex 1• Select and display all records from jobs table where it’s job title words started with ‘A’ character

•Ex 2• Display different /not duplicated/ maximum & minimum values of records from jobs table

•Ex 3• Display department names records from departments table whose location ID’s are 1700

•Ex 4• Display all records of jobs table in minimum salary ascending order whose job title had ‘P’ character in it

•Ex 5• Display first & last name, email, and salary records of employees table whose first name ends with character ‘y’ in email descending order

•Ex 6• Display first name, last name and salary records from employees table whose salary is either 12008 or 3000

•Ex 7• Display city and postal code records whose last character of city record neither ends with ‘y’, ‘e’ nor ‘a’ from locations table

•Ex 8• Display employee Id, first name, phone number and email records from employees table whose hires 4000 days before server date

•Ex 9• Display average, minimum and maximum salary values only by using functions from employees table

•Ex 10• Display employees of first name, last name and salary records whose hire date is January 07 2002 and whose salary is either 6500 or 8300

For SQL Commands reference please review the pdf short note attached and pined earlier.

AI Programming @freecodecs

Have a Lit🔥 Practice Folks 🙌🏽

Using Run SQL Command Line
We described the full steps on below post ⬇️

AI Programming @freecodecs
Hope this will be helpful 🙏🏽

Steps Using Run SQL Command Line
——————————————————
Step 1: Open Run SQL Command Line

Step 2: Write and enter the following without quotations and semicolon
‘connect system’

Step 3: Enter your password which is you gave when you install Oracle Enterprise program and press enter(*you won’t see it when you write it’s just blank)

Step 4: Alter the HR database account to access it every time - write and enter the following without the quotation and with the semicolon this time
‘alter user hr account unlock;’

Step 5: Now create user and password for manipulation of HR account - also write enter the following without the quotation and with semicolon
‘alter user hr identified by hr;’

Step 6: Write and enter ‘connect’ then enter user name & pass, write and enter twice ‘hr’ for the username and password

•NB• Now you can use the Oracle SQL Program anytime but when you use it on next launch which is after exiting and starting again skip Step 4 & 5

AI Programming @freecodecs
As always :
Have a Lit 🔥 Practice Folks 🙌🏽

DB - Oracle Exercise 1 :Answers
————————————————
•Ans Ex 1
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%A_%’;

•Ans Ex 2
SELECT DISTINCT MIN_SALARY, MAX_SALARY FROM JOBS;

•Ans Ex 3
SELECT DEPARTMENT_NAME FROM DEPARTMENTS WHERE LOCATION_ID = 1700;

•Ans Ex 4
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY MIN_SALARY;
(SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY ASC MIN_SALARY;)

•Ans Ex 5
SELECT FIRST_NAME, LAST_NAME, EMAIL, SALARY FROM EMPLOYEES WHERE FIRST_NAME LIKE ‘%y’ ORDER BY EMAIL DESC;

•Ans Ex 6
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY = 12008 OR SALARY = 3000;

•Ans Ex 7
SELECT CITY, POSTAL_CODE FROM LOCATIONS WHERE CITY NOT LIKE ‘%e’ AND CITY NOT LIKE ‘%y’ AND CITY NOT LIKE ‘%a’;

•Ans Ex 8
SELECT EMPLOYEE_ID, FIRST_NAME, PHONE_NUMBER, EMAIL FROM EMPLOYEES WHERE HIRE_DATE > SYSDATE - 4000;

•Ans Ex 9
SELECT MAX(SALARY) as “Max Salary”, MIN(SALARY) as “Min Salary”, AVG(SALARY) as “Average Salary” FROM EMPLOYEES;

•Ans Ex 10
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE HIRE_DATE = ‘07-JUN-02’ AND (SALARY = 6500 OR SALARY = 8300);

AI Programming @freecodecs

😂 have a break have a joke 😂

Let’s close 2018 tag and .... Happy New Year 🎆 Folks

Programmer life😂😂😂👇👇