Jawaban Database Programming with SQL ORACLE

Pejuang Sukses - hai pejuang siapa yang kenal dengan java oracle ?, saya yakin dan percaya pejuang semua mengetahui product dari java ini ya karena oracle merupakan database yang kini banyak digunakan oleh perusahan besar dan biasanya oracle digunakan untuk penyimpanan data dengan skala yang cukup besar sehingga dapat digunakan sebagai data mining.

Dan kali ini admin akan berbagi jawaban bagi yang mengikuti ujian Database Programming with SQL nah untuk cara mencari jawaban nya cukup mudah yaitu dengan cara tekan " CTRL + F " kemudian masukan soal kalian dan otomatis akan menampilkan soal dan jawaban yang kalian cari namun jika jawaban yang kalian cari belum ada berarti admin minta maaf belum bisa memberikan jawaban yang pejuang cari, selamat mengerjakan.

Gunakan CTRL + F untuk mempermudah pencarian.

The EMPLOYEES table includes these columns: EMPLOYEE_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(15) NOT NULL FIRST_NAME VARCHAR2(10) NOT NULL HIRE_DATE DATE NOT NULL You want to produce a report that provides the last names, first names, and hire dates of those employees who were hired between March 1, 2000, and August 30, 2000. Which statements can you issue to accomplish this task?

The EMPLOYEES table contains these columns:

LAST_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
EMAIL VARCHAR2(50)

You are writing a SELECT statement to retrieve the names of employees that have an email address.

SELECT last_name||', '||first_name "Employee Name"
FROM employees;

Which WHERE clause should you use to complete this statement?

Which of the following WHERE clauses would not select the number 10?

If you write queries using the BETWEEN operator, it does not matter in what order you enter the values, i.e. BETWEEN low value AND high value will give the same result as BETWEEN high value and low value. True or False?

Which two statements would select salaries that are greater than or equal to 2500 and less than or equal to 3500? (Choose two)

(Choose all correct answers)

Which of the following elements cannot be included in a WHERE clause?

The Concatenation Operator does which of the following?

Which clause would you include in a SELECT statement to restrict the data returned to only the employees in department 10?

In order to eliminate duplicate rows use the ________ keyword

Which comparison operator searches for a specified character pattern?

Which of the following commands will display the last name concatenated with the job ID from the employees table, separated by a comma and space, and label the resulting column "Employee and Title"?

You want to retrieve a list of customers whose last names begin with the letters 'Fr' . Which symbol should you include in the WHERE clause of your SELECT statement to achieve the desired result?

Which of the following are true? (Choose Two)

            (Choose all correct answers)

You want to retrieve a list of customers whose last names begin with the letters 'Fr' . Which keyword should you include in the WHERE clause of your SELECT statement to achieve the desired result?

Which of the following would be returned by this SELECT statement:

SELECT last_name, salary

FROM employees

WHERE salary < 3500;

You query the database with this SQL statement:

SELECT price

FROM products

WHERE price IN(1, 25, 50, 250)

AND (price BETWEEN 25 AND 40 OR price > 50);

Which two values could the statement return? (Choose two.)

            (Choose all correct answers)

You need to create a report to display all employees that were hired on or before January 1, 1996. The data should display in this format:

Employee        Start Date and Salary

14837 - Smith 10-May-1992 / 5000

Which SELECT statement could you use?

Evaluate this SELECT statement:

SELECT last_name, first_name, email

FROM employees

ORDER BY email;

If the EMAIL column contains null values, which statement is true?

Evaluate this SQL statement:

SELECT product_id, product_name, price

FROM products

ORDER BY product_name, price;

What occurs when the statement is executed?

What value will the following SQL statement return?

SELECT employee_id

FROM employees

WHERE employee_id BETWEEN 100 AND 150

   OR employee_id IN(119, 175, 205)

   AND (employee_id BETWEEN 150 AND 200);

The function COUNT is a single row function. True or False?

The PLAYERS table contains these columns:

PLAYERS TABLE:

LAST_NAME VARCHAR2 (20)

FIRST_NAME VARCHAR2 (20)

SALARY NUMBER(8,2)

TEAM_ID NUMBER(4)

MANAGER_ID NUMBER(9)

POSITION_ID NUMBER(4)

You want to display all players' names with position 6900 or greater.

You want the players names to be displayed alphabetically by last name and then by first name.

Which statement should you use to achieve the required results?

The conversion function TO_CHAR is a single row function. True or False?

The PLAYERS table contains these columns:

PLAYERS TABLE:

LAST_NAME VARCHAR2 (20)

FIRST_NAME VARCHAR2 (20)

SALARY NUMBER(8,2)

TEAM_ID NUMBER(4)

MANAGER_ID NUMBER(9)

POSITION_ID NUMBER(4)

You must display the player name, team id, and salary for players whose salary is in the range from 25000 through 100000 and whose team id is in the range of 1200 through 1500. The results must be sorted by team id from lowest to highest and then further sorted by salary from highest to lowest. Which statement should you use to display the desired result?

The following statement represents a multi-row function. True or False?

SELECT UPPER(last_name)

FROM employees;

Which of the following are examples of logical operators that might be used in a WHERE clause. (Choose Two)

Which statement about the default sort order is true?

Which of the following statements best describes the rules of precedence when using SQL?

Which of the following are TRUE regarding the logical AND operator?

You need to change the default sort order of the ORDER BY clause so that the data is displayed in reverse alphabetical order. Which keyword should you include in the ORDER BY clause?

Which functions can be used to manipulate character, number, and date column values?

Which of the following are types of SQL functions? (Choose two correct answers.)

You need to display each employee's name in all uppercase letters. Which function should you use?

Which query selects the first names of the DJ On Demand clients who have a first name beginning with "A"?

You query the database with this SQL statement: SELECT LOWER(SUBSTR(CONCAT(last_name, first_name)), 1, 5) "ID" FROM employee; In which order are the functions evaluated?

ROUND and TRUNC functions can be used with which of the following Datatypes?

Which comparison operator retrieves a list of values?

You issue this SQL statement:

SELECT ROUND (1282.248, -2) FROM dual;

What value does this statement produce?

You issue this SQL statement:

SELECT TRUNC(751.367,-1) FROM dual;

Which value does this statement display?

Which script displays '01-May-2004' when the HIRE_DATE value is '20-May-2004'?

What is the result of the following query? SELECT ADD_MONTHS ('11-Jan-1994',6) FROM dual;

Which query would return a whole number if the sysdate is 26-May-2004?

Which function would you use to return the current database server date and time?

What is the result of the following query? SELECT ADD_YEARS ('11-Jan-1994',6) FROM dual;

Evaluate this SELECT statement:

SELECT SYSDATE + 30

FROM dual;

Which value is returned by the query?

Which statement will return a listing of last names, salaries, and a rating of 'Low', 'Medium', 'Good' or 'Excellent' depending on the salary value?

For the given data from Employees (last_name, manager_id) what is the result of the following statement:

DATA:( King, null

Kochhar, 100

De Haan, 100

Hunold, 102

Ernst, 103)

SELECT last_name,

DECODE(manager_id, 100, 'King', 'A N Other') "Works For?"

FROM employees

Which of the following is a conditional expression used in SQL?

The following script will run successfully. True or False? SELECT TO_CHAR(TO_DATE('25-Dec-2004','dd-Mon-yyyy')) FROM dual

Which best describes the TO_CHAR function?

Which statement concerning single row functions is true?

Which statement is true about SQL functions?

Which three statements concerning explicit data type conversions are true? (Choose three.)

Which SQL Statement should you use to display the prices in this format: "$00.30"?

The following statement returns 0 (zero). True or False? SELECT 121/NULL FROM dual;

You need to replace null values in the DEPT_ID column with the text N/A. Which functions should you use?

If quantity is a number datatype, what is the result of this statement?

SELECT NVL(200/quantity, 'zero') FROM inventory;

When executed, which statement displays a zero if the TUITION_BALANCE value is zero and the HOUSING_BALANCE value is null?

Which of the following General Functions will return the first non-null expression in the expression list?

Consider the following data in the Employees table: (last_name, commission_pct, manager_id)

DATA:

King, null, null

Kochhar, null, 100

Vargas, null, 124

Zlotkey, .2, 100

What is the result of the following statement:

SELECT last_name, COALESCE(commission_pct, manager_id, -1) comm

FROM employees ;