Artikel Terkait Oracle iLearning
Section 2 Quiz
(Answer all questions in this section)
1. Which two statements would select salaries that are greater than or equal to 2500 and less than or equal to 3500? (Choose two) Mark for Review
(1) Points
(Choose all correct answers)
WHERE salary >= 2500 AND salary <= 3500 (*)
WHERE salary <=2500 AND salary >= 3500
WHERE salary BETWEEN 2500 AND 3500 (*)
WHERE salary BETWEEN 3500 AND 2500
2. Which of the following are examples of comparison operators used in the WHERE clause? Mark for Review
(1) Points
=, >, <, <=, >=, <>
between ___ and ___
in (..,..,.. )
like
is null
All of the above (*)
3. 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? Mark for Review
(1) Points
True
False (*)
4. When using the "LIKE" operator, the % and _ symbols can be used to do a pattern-matching, wild card search. True or False? Mark for Review
(1) Points
True (*)
False
5. Which of the following WHERE clauses would not select the number 10? Mark for Review
(1) Points
WHERE hours <= 10
WHERE hours IN (8,9,10)
WHERE hours BETWEEN 10 AND 20
WHERE hours <>10 (*)
6. Which SELECT statement will display both unique and non-unique combinations of the MANAGER_ID and DEPARTMENT_ID values from the EMPLOYEES table? Mark for Review
(1) Points
SELECT manager_id, DISTINCT department_id FROM employees;
SELECT manager_id, department_id DISTINCT FROM employees;
SELECT manager_id, department_id FROM employees; (*)
SELECT DISTINCT manager_id, department_id FROM employees;
7. If the EMPLOYEES table has the following columns, and you want to write a SELECT statement to return the employee last name and department number for employee number 176, which of the following SQL statements should you use?
Name Type Length
EMPLOYEE_ID NUMBER 22
FIRST_NAME VARCHAR2 20
LAST_NAME VARCHAR2 25
EMAIL VARCHAR2 25
PHONE_NUMBER VARCHAR2 20
SALARY NUMBER 22
COMMISSION_PCT NUMBER 22
MANAGER_ID NUMBER 22
DEPARTMENT_ID NUMBER 22
Mark for Review
(1) Points
SELECT last_name, department_id
FROM employees
WHERE employee_id equals 176;
SELECT last_name, employee_id
FROM employees
WHERE employee_id equals 176;
SELECT last_name, department_id
FROM employees
WHERE employee_id = 176; (*)
SELECT first_name, employee_id
FROM employees
WHERE employee_id = 176;
8. 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"? Mark for Review
(1) Points
SELECT last_name||","|| job_id "Employee and Title" FROM employees;
SELECT last_name||', '|| job_id "Employee and Title" FROM employees; (*)
SELECT " last name" ||', '|| "job_id" + "Employee and Title" FROM emp;
SELECT " last name" ||', '|| "job_id" + "Employee and Title" FROM employees;
9. Which of the following is true? Mark for Review
(1) Points
Date values are enclosed in single quotation marks (*)
Character strings must be enclosed in double quotation marks
Character values are not case-sensitive
Date values are not format-sensitive
10. Which of the following are true? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Date values are format-sensitive (*)
Character values are not case-sensitive
Date values are enclosed in single quotation marks (*)
Character strings are enclosed in double quotation marks
11. In order to eliminate duplicate rows use the ________ keyword Mark for Review
(1) Points
SINGLES_ONLY
EXCLUSIVE
DISTINCT (*)
FIRST_ONLY
12. Which clause would you include in a SELECT statement to restrict the data returned to only the employees in department 10? Mark for Review
(1) Points
SELECT
IS
WHERE (*)
FROM
13. The concatenation operator ... Mark for Review
(1) Points
Brings together columns or character strings into other columns
Creates a resultant column that is a character expression
Is represented by two vertical bars ( || )
All of the above (*)
14. Which comparison operator searches for a specified character pattern? Mark for Review
(1) Points
IN
IS NULL
BETWEEN...AND...
LIKE (*)
15. What does the DISTINCT keyword do when it is used in a SELECT clause? Mark for Review
(1) Points
Hides NULL values
Eliminates all unique values and compares values
Eliminates duplicate rows in the result (*)
Eliminates only unique rows in the result
SELAMAT BERJUANG…………………………………..
Pelajar yang menyelesaikan Desain & Pemrograman Database Oracle Academy dengan kursus SQL dapat sebagai gantinya (atau juga) memilih untuk mempersiapkan dan mengikuti ujian sertifikasi SQL Server SQL Expert. Namun, ujian Oracle Database SQL Expert berisi topik tambahan yang akan membutuhkan lebih banyak belajar mandiri dan berlatih sendiri untuk mempersiapkan.
Membutuhkan penyelesaian yang berhasil sebelum Ujian Sertifikasi Oracle Database SQL Expert, Pengantar Oracle Ujian Sertifikasi SQL, atau Oracle Database : Ujian Sertifikasi SQL Fundamentals.
Di atas adalah soal dan jawaban kuis oracle ilearning - oracle academy, sebagai penambah ilmu pengetahuan untuk kita semua, yang pada intinya jangan lupa untuk dipahami dan dikuasai.
Tag : oracle academy quiz answers, oracle ilearning quiz answers, oracle academy certification, oracle academy training, soal dan jawaban kuis oracle, jawaban kuis oracle academy, jawaban kuis oracle ilearning, kunci jawaban oracle academy, kunci jawaban oracle ilearning.
Selain Sebagai Penyedia Panduan Belajar Database dan Tutorial Pemrograman, Kami Juga Membagikan Kumpulan Source Code Program Aplikasi dan Ebook Pemrograman Terlengkap yang Bisa Anda Dapatkan Secara Gratis di Halaman :
(Answer all questions in this section)
1. Which two statements would select salaries that are greater than or equal to 2500 and less than or equal to 3500? (Choose two) Mark for Review
(1) Points
(Choose all correct answers)
WHERE salary >= 2500 AND salary <= 3500 (*)
WHERE salary <=2500 AND salary >= 3500
WHERE salary BETWEEN 2500 AND 3500 (*)
WHERE salary BETWEEN 3500 AND 2500
2. Which of the following are examples of comparison operators used in the WHERE clause? Mark for Review
(1) Points
=, >, <, <=, >=, <>
between ___ and ___
in (..,..,.. )
like
is null
All of the above (*)
3. 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? Mark for Review
(1) Points
True
False (*)
4. When using the "LIKE" operator, the % and _ symbols can be used to do a pattern-matching, wild card search. True or False? Mark for Review
(1) Points
True (*)
False
5. Which of the following WHERE clauses would not select the number 10? Mark for Review
(1) Points
WHERE hours <= 10
WHERE hours IN (8,9,10)
WHERE hours BETWEEN 10 AND 20
WHERE hours <>10 (*)
6. Which SELECT statement will display both unique and non-unique combinations of the MANAGER_ID and DEPARTMENT_ID values from the EMPLOYEES table? Mark for Review
(1) Points
SELECT manager_id, DISTINCT department_id FROM employees;
SELECT manager_id, department_id DISTINCT FROM employees;
SELECT manager_id, department_id FROM employees; (*)
SELECT DISTINCT manager_id, department_id FROM employees;
7. If the EMPLOYEES table has the following columns, and you want to write a SELECT statement to return the employee last name and department number for employee number 176, which of the following SQL statements should you use?
Name Type Length
EMPLOYEE_ID NUMBER 22
FIRST_NAME VARCHAR2 20
LAST_NAME VARCHAR2 25
EMAIL VARCHAR2 25
PHONE_NUMBER VARCHAR2 20
SALARY NUMBER 22
COMMISSION_PCT NUMBER 22
MANAGER_ID NUMBER 22
DEPARTMENT_ID NUMBER 22
Mark for Review
(1) Points
SELECT last_name, department_id
FROM employees
WHERE employee_id equals 176;
SELECT last_name, employee_id
FROM employees
WHERE employee_id equals 176;
SELECT last_name, department_id
FROM employees
WHERE employee_id = 176; (*)
SELECT first_name, employee_id
FROM employees
WHERE employee_id = 176;
8. 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"? Mark for Review
(1) Points
SELECT last_name||","|| job_id "Employee and Title" FROM employees;
SELECT last_name||', '|| job_id "Employee and Title" FROM employees; (*)
SELECT " last name" ||', '|| "job_id" + "Employee and Title" FROM emp;
SELECT " last name" ||', '|| "job_id" + "Employee and Title" FROM employees;
9. Which of the following is true? Mark for Review
(1) Points
Date values are enclosed in single quotation marks (*)
Character strings must be enclosed in double quotation marks
Character values are not case-sensitive
Date values are not format-sensitive
10. Which of the following are true? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Date values are format-sensitive (*)
Character values are not case-sensitive
Date values are enclosed in single quotation marks (*)
Character strings are enclosed in double quotation marks
11. In order to eliminate duplicate rows use the ________ keyword Mark for Review
(1) Points
SINGLES_ONLY
EXCLUSIVE
DISTINCT (*)
FIRST_ONLY
12. Which clause would you include in a SELECT statement to restrict the data returned to only the employees in department 10? Mark for Review
(1) Points
SELECT
IS
WHERE (*)
FROM
13. The concatenation operator ... Mark for Review
(1) Points
Brings together columns or character strings into other columns
Creates a resultant column that is a character expression
Is represented by two vertical bars ( || )
All of the above (*)
14. Which comparison operator searches for a specified character pattern? Mark for Review
(1) Points
IN
IS NULL
BETWEEN...AND...
LIKE (*)
15. What does the DISTINCT keyword do when it is used in a SELECT clause? Mark for Review
(1) Points
Hides NULL values
Eliminates all unique values and compares values
Eliminates duplicate rows in the result (*)
Eliminates only unique rows in the result
SELAMAT BERJUANG…………………………………..
Oracle Ilearning for Database Design
Pelajar yang menyelesaikan Desain & Pemrograman Database Oracle Academy dengan kursus SQL dapat sebagai gantinya (atau juga) memilih untuk mempersiapkan dan mengikuti ujian sertifikasi SQL Server SQL Expert. Namun, ujian Oracle Database SQL Expert berisi topik tambahan yang akan membutuhkan lebih banyak belajar mandiri dan berlatih sendiri untuk mempersiapkan.
Membutuhkan penyelesaian yang berhasil sebelum Ujian Sertifikasi Oracle Database SQL Expert, Pengantar Oracle Ujian Sertifikasi SQL, atau Oracle Database : Ujian Sertifikasi SQL Fundamentals.
Di atas adalah soal dan jawaban kuis oracle ilearning - oracle academy, sebagai penambah ilmu pengetahuan untuk kita semua, yang pada intinya jangan lupa untuk dipahami dan dikuasai.
Pembahasan didalam Oracle Ilearning - Oracle Academy
- Oracle Ilearning for Database Design
- Oracle Ilearning for Course Resources
- Oracle Ilearning for Introduction
- Oracle Ilearning for Entities and Attributes
- Oracle Ilearning for Relationship Basics
- Oracle Ilearning for Super/Sub Types and Business Rules
- Oracle Ilearning for Relationship Fundamentals
- Oracle Ilearning for UIDs and Normalization
- Oracle Ilearning for Arcs, Hierarchies, and Recursive Modeling
- Oracle Ilearning for Changes and Historical Modeling
- Oracle Ilearning for Mapping
- Oracle Ilearning for Creating Database Projects
- Oracle Ilearning for Presenting Database Projects
- Oracle Ilearning quiz answers for Database Design English Quizzes and Exams
- Oracle Ilearning quiz answers for Database Design Midterm Exam
- Oracle ilearning quiz answers for Database Design Final Exam
Tag : oracle academy quiz answers, oracle ilearning quiz answers, oracle academy certification, oracle academy training, soal dan jawaban kuis oracle, jawaban kuis oracle academy, jawaban kuis oracle ilearning, kunci jawaban oracle academy, kunci jawaban oracle ilearning.
Selain Sebagai Penyedia Panduan Belajar Database dan Tutorial Pemrograman, Kami Juga Membagikan Kumpulan Source Code Program Aplikasi dan Ebook Pemrograman Terlengkap yang Bisa Anda Dapatkan Secara Gratis di Halaman :
Rekomendasi Web Hosting
- 20rb perbulan. Diskon hingga 40% kode kupon: MCP Daftar disini (apache).
- 10rb perbulan. Diskon hingga 75% kode kupon: MCP Daftar disini (litespeed).
- 10rb perbulan. Diskon hingga 70% kode kupon: aff-MCP Daftar disini (apache).