CIS dataworld asses 13

SQL DATABASE Management System

Answer the following questions then copy your code to a text document (with print screens) and upload it on Blackboard before the due date. A- Create this Employees table Department_id 66 First name salary 1500 Last name Almahmod Alnaser Al badr Saad Saleh 10500 50 Abdullah 2000 50 Mohammad Alabdukarem 18000 50 Almasoud B- Then apply the following queries: Nasser 11000 70 1- Retrieve all the employees who got salary more than 2000$ 2- Retrieve all the employees who got salary in the range 2000$ to 11000$ 3- Retrieve all the employees who got salary out of the range 2000$ to 11000$ 4- Retrieve all the employees who got salary 2000$ , 10500$ or 17000$ using the IN operator 5- Retrieve all the employees who got salary other than 2000$ , 10500$ or 17000$ using the IN operator 6- Retrieve employee first name, last name and display his Full name which is the concatenation of his first name and last name together. 7- Retrieve the first name, last name and salary for all employees whose first…

one of the followings is NOT a DML command: Insert .a Create Table Delete .c O Update .d O

BASIC QUERIES #4 The PatientDim table contains a column, Name. which of the following SELECT clauses will make "Patient Name" function as an alias for Name? SELECT ONE OF THE FOLLOWING A. SELECT Name, "Patient Name" B. SELECT Name "Patient Name" C. SELECT Name, [Patient Name] D. SELECT Name, as "Patient Name"

This SQL statement is used to change the value of an existing row.a. DROPb. UPDATEc. PURGEd. INSERT

Which of the following is not true about database objects?   a. You can split a form into multiple parts.   b. A query should include all the fields in a table.   c. You may want to require that all fields be entered before submitting a form.   d. When creating a report, you should consider its layout and design.     Brad is designing a form for his database. Which of the following is not true about forms?   a. Forms should validate data as it is entered.   b. A form provides a data entry screen.   c. Brad can include instructions specific to each field.   d. A form generally shows multiple records at a time.     In a database, a data file is a/n ______.   a. collection of related records   b. index of the database's objects   c. list of the fields in a table   d. query result that can be saved as a table     A data warehouse is a type of database.  True  False

Computer Science PHP - SQL

Looking Up Data- INDEX () & MATCH() Which of the following statements describes how the INDEX) and MATCH() functions are combined to lookup data?   A) MATCH() is used within the INDEX() function to return the relative position of the data in the lookup table B) INDEX) is used within the MATCH() function to return the relative position of the data in the lookup table C) MATCH() is used to match values from the lookup table and the source table, INDEX() returns the index of these values D) INDEX calculates the relative position of the data in the source table and returns values for MATCH() to lookup

Database Oracle sql Note :I hope the solution is from HR in the Oracle sql software