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)
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;
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"?
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'?
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?
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 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.)
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 ;
Posting Komentar
- Selagi bisa di jawab maka akan segera di jawab secepat mungkin
- gunakan bahasa yang sopan
- anda sopan saya segan