Langsung ke konten utama

Section 5 Quiz Oracle Database Programming with SQL

Section 5 Quiz
                (Answer all questions in this section)

1.            CASE and DECODE evaluate expressions in a similar way to IF-THEN-ELSE logic. However, DECODE is specific to Oracle syntax. True or False? Mark for Review
(1) Points

                True (*)
                False

2.            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

 Mark for Review
(1) Points

                King, A N Other
Kochhar, King
De Haan, King
Hunold, A N Other
Ernst, A N Other
(*)

                King, A N Other
Kochhar, King
De Haan, King
Hunold, Kochhar
Ernst, De Haan

                Invalid statement.

                King, Null
Kochhar, King
De Haan, King
Hunold, A N Other
Ernst, A N Other

3.            Which of the following is a conditional expression used in SQL?  Mark for Review
(1) Points

                NULLIF
                WHERE
                CASE (*)
                DESCRIBE

4.            A table has the following definition: EMPLOYEES(
EMPLOYEE_ID NUMBER(6) NOT NULL,
NAME VARCHAR2(20) NOT NULL,
MANAGER_ID VARCHAR2(6))

and contains the following rows:

(1001, 'Bob Bevan', '200')
(200, 'Natacha Hansen', null)

Will the folloiwng query work?

SELECT *
FROM employees
WHERE employee_id = manager_id;       Mark for Review
(1) Points

                Yes, Oracle will perform implicit dataype conversion, and the query will return one row of data.

                Yes, Oracle will perform implicit datatype conversion, but the WHERE clause will not find any matching data. (*)

                No.ï¾  You will have to re-wirte the statement and perform explicit datatype conversion.

                No, because the datatypes of EMPLOYEE_ID and MANAGER_ID are different.

5.            If you use the RR format when writing a query using the date 27-Oct-17 and the year is 2001, what year would be the result?      Mark for Review
(1) Points

                1901
                2017 (*)
                2001
                1917

6.            Which arithmetic operation will return a numeric value?                Mark for Review
(1) Points

                SYSDATE + 30 / 24
                NEXT_DAY(hire_date) + 5
                SYSDATE - 6
                TO_DATE('01-Jun-2004') - TO_DATE('01-Oct-2004') (*)

7.            Which SQL Statement should you use to display the prices in this format: "$00.30"?         Mark for Review
(1) Points

                SELECT TO_CHAR(price, '$99,900.99')
FROM product;
(*)

                SELECT TO_NUMBER(price, '$99,900.99')
FROM product;

                SELECT TO_CHAR(price, '$99,990.99')
FROM product;

                SELECT TO_CHAR(price, '$99,999.99')
FROM product;

8.            Which two statements concerning SQL functions are true? (Choose two.)            Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Single-row functions manipulate groups of rows to return one result per group of rows.
                Conversion functions convert a value from one data type to another data type. (*)
                Not all date functions return date values. (*)
                Character functions can accept numeric input.
                Number functions can return number or character values.

9.            You need to display the HIRE_DATE values in this format: 25th of July 2002. Which SELECT statement would you use?              Mark for Review
(1) Points

                SELECT TO_CHAR(hire_date, 'DDspth 'of' Month RRRR')
FROM employees;

                SELECT TO_CHAR(hire_date, 'DDTH "of" Month YYYY')
FROM employees;

                SELECT TO_CHAR(hire_date, 'ddth "of" Month YYYY')
FROM employees;
(*)

                SELECT enroll_date(hire_date, 'DDspth "of" Month YYYY')
FROM employees;

10.          Which function compares two expressions?        Mark for Review
(1) Points

                NVL
                NVL2
                NULL
                NULLIF (*)

11.          Which of the following General Functions will return the first non-null expression in the expression list?                Mark for Review
(1) Points

                NULLIF
                COALESCE (*)
                NVL2
                NVL

12.          When executed, which statement displays a zero if the TUITION_BALANCE value is zero and the HOUSING_BALANCE value is null?            Mark for Review
(1) Points

                SELECT NVL (tuition_balance + housing_balance, 0) "Balance Due"
FROM student_accounts;
(*)

                SELECT tuition_balance + housing_balance
FROM student_accounts;

                SELECT TO_NUMBER(tuition_balance, 0), TO_NUMBER (housing_balance, 0), tutition_balance + housing_balance "Balance Due"
FROM student_accounts;

                SELECT NVL(tuition_balance, 0), NVL (housing_balance), tuition_balance + housing_balance "Balance Due"
FROM student_accounts;

13.          Which statement about group functions is true?               Mark for Review
(1) Points

                NVL and COALESCE, but not NVL2, can be used with group functions to replace null values.
                COALESCE, but not NVL and NVL2, can be used with group functions to replace null values.
                NVL and NVL2, but not COALESCE, can be used with group functions to replace null values.
                NVL, NVL2, and COALESCE can be used with group functions to replace null values. (*)

14.          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 ;

 Mark for Review
(1) Points

                King, null
Kochhar, 100
Vargas, 124
Zlotkey, .2

                King, -1
Kochhar, 100
Vargas, 124
Zlotkey, .2
(*)

                Statement will fail

                King, -1
Kochhar, 100
Vargas, 124
Zlotkey, 100

15.          You need to replace null values in the DEPT_ID column with the text N/A. Which functions should you use?                Mark for Review
(1) Points

                TO_NUMBER and NULLIF
                TO_CHAR and NULLIF
                TO_CHAR and NULL
                TO_CHAR and NVL (*)

1.            All Human Resources data is stored in a table named EMPLOYEES. You have been asked to create a report that displays each employee's name and salary. Each employee's salary must be displayed in the following format: $000,000.00. Which function should you include in a SELECT statement to achieve the desired result?      Mark for Review
(1) Points

                TO_DATE
                TO_CHAR (*)
                TO_NUMBER
                CHARTOROWID

2.            The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(9)
LAST_NAME VARCHAR2 (25)
FIRST_NAME VARCHAR2 (25)
HIRE_DATE DATE

You need to display HIRE_DATE values in this format:

January 28, 2000

Which SQL statement could you use?

 Mark for Review
(1) Points

                SELECT TO_CHAR(hire_date, 'Month DD', ' YYYY')
FROM employees;

                SELECT TO_CHAR(hire_date, 'Month DD, YYYY')
FROM employees;
(*)

                SELECT hire_date(TO_CHAR 'Month DD', ' YYYY')
FROM employees;

                SELECT TO_CHAR(hire_date, Month DD, YYYY)
FROM employees;

3.            A table has the following definition: EMPLOYEES(
EMPLOYEE_ID NUMBER(6) NOT NULL,
NAME VARCHAR2(20) NOT NULL,
MANAGER_ID VARCHAR2(6))

and contains the following rows:

(1001, 'Bob Bevan', '200')
(200, 'Natacha Hansen', null)

Will the folloiwng query work?

SELECT *
FROM employees
WHERE employee_id = manager_id;       Mark for Review
(1) Points

                Yes, Oracle will perform implicit dataype conversion, and the query will return one row of data.

                No, because the datatypes of EMPLOYEE_ID and MANAGER_ID are different.

                Yes, Oracle will perform implicit datatype conversion, but the WHERE clause will not find any matching data. (*)

                No.ï¾  You will have to re-wirte the statement and perform explicit datatype conversion.

4.            Which statement is true about SQL functions?   Mark for Review
(1) Points

                Functions can convert values or text to another data type.
                Functions can round a number to a specified decimal place.
                Functions can convert upper case characters to lower case characters.
                a, b and c are true. (*)
                None of the above statements are true.

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

                True (*)
                False

6.            Which three statements concerning explicit data type conversions are true? (Choose three.)     Mark for Review
(1) Points
                                                (Choose all correct answers)      

                Use the TO_NUMBER function to convert a character string of digits to a number. (*)
                Use the TO_CHAR function to convert a number or date value to a character string. (*)
                Use the TO_DATE function to convert a character string to a date value. (*)
                Use the TO_DATE function to convert a date value to a character string or number.
                Use the TO_NUMBER function to convert a number to a character string.

7.            Which function compares two expressions?        Mark for Review
(1) Points

                NULL
                NVL2
                NVL
                NULLIF (*)

8.            The following statement returns 0 (zero). True or False?
SELECT 121/NULL
FROM dual;        Mark for Review
(1) Points

                True
                False (*)

9.            When executed, which statement displays a zero if the TUITION_BALANCE value is zero and the HOUSING_BALANCE value is null?            Mark for Review
(1) Points

                SELECT tuition_balance + housing_balance
FROM student_accounts;

                SELECT NVL(tuition_balance, 0), NVL (housing_balance), tuition_balance + housing_balance "Balance Due"
FROM student_accounts;

                SELECT TO_NUMBER(tuition_balance, 0), TO_NUMBER (housing_balance, 0), tutition_balance + housing_balance "Balance Due"
FROM student_accounts;

                SELECT NVL (tuition_balance + housing_balance, 0) "Balance Due"
FROM student_accounts;
(*)

10.          You need to replace null values in the DEPT_ID column with the text N/A. Which functions should you use?                Mark for Review
(1) Points

                TO_NUMBER and NULLIF
                TO_CHAR and NULLIF
                TO_CHAR and NULL
                TO_CHAR and NVL (*)

11.          Which statement about group functions is true?               Mark for Review
(1) Points
                NVL and COALESCE, but not NVL2, can be used with group functions to replace null values.
                NVL and NVL2, but not COALESCE, can be used with group functions to replace null values.
                NVL, NVL2, and COALESCE can be used with group functions to replace null values. (*)
                COALESCE, but not NVL and NVL2, can be used with group functions to replace null values.

12.          With the following data in Employees (last_name, commission_pct, manager_id) what is the result of the following statement?
DATA:
King, null, null
Kochhar, null, 100
Vargas, null, 124
Zlotkey, .2, 100
SELECT last_name, NVL2(commission_pct, manager_id, -1) comm
FROM employees ;

 Mark for Review
(1) Points

                King, -1
Kochhar, -1
Vargas, -1
Zlotkey, 100
(*)

                Statement will fail.

                King, -1
Kochhar, -1
Vargas, -1
Zlotkey, .2

                King, -1
Kochhar, 100
Vargas, 124
Zlotkey, .2

13.          Which statement will return a listing of last names, salaries, and a rating of 'Low', 'Medium', 'Good' or 'Excellent' depending on the salary value?           Mark for Review
(1) Points

                SELECT last_name,salary,
(CASE WHEN salary<5000 o:p="" ow="" then="">
     WHEN salary<10000 edium="" o:p="" then="">
     WHEN salary<20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;
(*)

                SELECT last_name,sal,
(CASE WHEN sal<5000 o:p="" ow="" then="">
     WHEN sal<10000 edium="" o:p="" then="">
     WHEN sal<20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;

                SELECT last_name,salary,
(RATING WHEN salary<5000 o:p="" ow="" then="">
     WHEN salary<10000 edium="" o:p="" then="">
     WHEN salary<20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;

                SELECT last_name,salary,
(CASE WHEN salary<5000 o:p="" ow="" then="">
     WHEN sal <10000 edium="" o:p="" then="">
     WHEN sal <20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;

14.          Which of the following is a conditional expression used in SQL?  Mark for Review
(1) Points

                CASE (*)
                NULLIF
                DESCRIBE
                WHERE

15.          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

 Mark for Review
(1) Points

                King, A N Other
Kochhar, King
De Haan, King
Hunold, A N Other
Ernst, A N Other
(*)

                Invalid statement.

                King, Null
Kochhar, King
De Haan, King
Hunold, A N Other
Ernst, A N Other

                King, A N Other
Kochhar, King
De Haan, King
Hunold, Kochhar
Ernst, De Haan

1.            Sysdate is 12-May-2004.
You need to store the following date: 7-Dec-89
Which statement about the date format for this value is true?   Mark for Review
(1) Points

                The RR date format will interpret the year as 1989, and the YY date format will interpret the year as 2089 (*)

                Both the YY and RR date formats will interpret the year as 2089

                The RR date format will interpret the year as 2089, and the YY date format will interpret the year as 1989

                Both the YY and RR date formats will interpret the year as 1989

2.            Which functions allow you to perform explicit data type conversions?    Mark for Review
(1) Points

                TO_CHAR, TO_DATE, TO_NUMBER (*)
                LENGTH, SUBSTR, LPAD, TRIM
                NVL, NVL2, NULLIF
                ROUND, TRUNC, ADD_MONTHS

3.            Which statement will return the salary (for example, the salary of 6000) from the Employees table in the following format?   $6000.00       Mark for Review
(1) Points

                SELECT TO_CHAR(sal, '$99999.00') SALARY
FROM employees

                SELECT TO_CHAR(salary, '$99999') SALARY
FROM employees

                SELECT TO_CHAR(salary, '99999.00') SALARY
FROM employees

                SELECT TO_CHAR(salary, '$99999.00') SALARY
FROM employees
(*)

4.            The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(9)
LAST_NAME VARCHAR2 (25)
FIRST_NAME VARCHAR2 (25)
HIRE_DATE DATE

You need to display HIRE_DATE values in this format:

January 28, 2000

Which SQL statement could you use?

 Mark for Review
(1) Points

                SELECT TO_CHAR(hire_date, Month DD, YYYY)
FROM employees;

                SELECT TO_CHAR(hire_date, 'Month DD', ' YYYY')
FROM employees;

                SELECT TO_CHAR(hire_date, 'Month DD, YYYY')
FROM employees;
(*)

                SELECT hire_date(TO_CHAR 'Month DD', ' YYYY')
FROM employees;

5.            If you use the RR format when writing a query using the date 27-Oct-17 and the year is 2001, what year would be the result?      Mark for Review
(1) Points

                2017 (*)
                1901
                1917
                2001

6.            Which three statements concerning explicit data type conversions are true? (Choose three.)     Mark for Review
(1) Points
                                                                               
                                                (Choose all correct answers)      

                Use the TO_DATE function to convert a character string to a date value. (*)
                Use the TO_CHAR function to convert a number or date value to a character string. (*)
                Use the TO_DATE function to convert a date value to a character string or number.
                Use the TO_NUMBER function to convert a character string of digits to a number. (*)
                Use the TO_NUMBER function to convert a number to a character string.

7.            Which statement will return a listing of last names, salaries, and a rating of 'Low', 'Medium', 'Good' or 'Excellent' depending on the salary value?           Mark for Review
(1) Points

                SELECT last_name,salary,
(CASE WHEN salary<5000 o:p="" ow="" then="">
     WHEN salary<10000 edium="" o:p="" then="">
     WHEN salary<20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;
(*)

                SELECT last_name,salary,
(RATING WHEN salary<5000 o:p="" ow="" then="">
     WHEN salary<10000 edium="" o:p="" then="">
     WHEN salary<20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;

                SELECT last_name,salary,
(CASE WHEN salary<5000 o:p="" ow="" then="">
     WHEN sal <10000 edium="" o:p="" then="">
     WHEN sal <20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;

                SELECT last_name,sal,
(CASE WHEN sal<5000 o:p="" ow="" then="">
     WHEN sal<10000 edium="" o:p="" then="">
     WHEN sal<20000 o:p="" ood="" then="">
     ELSE 'Excellent'
END) qualified_salary
FROM employees;

8.            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

 Mark for Review
(1) Points

                King, A N Other
Kochhar, King
De Haan, King
Hunold, A N Other
Ernst, A N Other
(*)

                King, Null
Kochhar, King
De Haan, King
Hunold, A N Other
Ernst, A N Other

                Invalid statement.

                King, A N Other
Kochhar, King
De Haan, King
Hunold, Kochhar
Ernst, De Haan

9.            Which of the following is a conditional expression used in SQL?  Mark for Review
(1) Points

                DESCRIBE
                CASE (*)
                NULLIF
                WHERE

10.          Which function compares two expressions?        Mark for Review
(1) Points

                NVL
                NULL
                NULLIF (*)
                NVL2

11.          Which statement about group functions is true?               Mark for Review
(1) Points

                NVL and NVL2, but not COALESCE, can be used with group functions to replace null values.
                COALESCE, but not NVL and NVL2, can be used with group functions to replace null values.
                NVL and COALESCE, but not NVL2, can be used with group functions to replace null values.
                NVL, NVL2, and COALESCE can be used with group functions to replace null values. (*)

12.          When executed, which statement displays a zero if the TUITION_BALANCE value is zero and the HOUSING_BALANCE value is null?            Mark for Review
(1) Points

                SELECT tuition_balance + housing_balance
FROM student_accounts;

                SELECT NVL (tuition_balance + housing_balance, 0) "Balance Due"
FROM student_accounts;
(*)

                SELECT NVL(tuition_balance, 0), NVL (housing_balance), tuition_balance + housing_balance "Balance Due"
FROM student_accounts;

                SELECT TO_NUMBER(tuition_balance, 0), TO_NUMBER (housing_balance, 0), tutition_balance + housing_balance "Balance Due"
FROM student_accounts;

13.          You need to replace null values in the DEPT_ID column with the text N/A. Which functions should you use?                Mark for Review
(1) Points

                TO_NUMBER and NULLIF
                TO_CHAR and NULL
                TO_CHAR and NULLIF
                TO_CHAR and NVL (*)

14.          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 ;

 Mark for Review
(1) Points

                King, -1
Kochhar, 100
Vargas, 124
Zlotkey, 100

                Statement will fail

                King, null
Kochhar, 100
Vargas, 124
Zlotkey, .2

                King, -1
Kochhar, 100
Vargas, 124
Zlotkey, .2
(*)

15.          The STYLES table contains this data:
STYLE_ID              STYLE_NAME     CATEGORY          COST
895840                  SANDAL               85940                    12.00
968950                  SANDAL               85909                    10.00
869506                  SANDAL               89690                    15.00
809090                  LOAFER                 89098                    10.00
890890                  LOAFER                 89789                    14.00
857689                  HEEL                      85940                    11.00
758960                  SANDAL               86979   
Evaluate this SELECT statement:

SELECT style_id, style_name, category, cost
FROM styles
WHERE style_name LIKE 'SANDAL' AND NVL(cost, 0) < 15.00
ORDER BY category, cost;

Which result will the query provide?

 Mark for Review
(1) Points

STYLE_ID              STYLE_NAME     CATEGORY          COST
968950                  SANDAL               85909                    10.00
895840                  SANDAL               85940                    12.00
758960                  SANDAL               86979   
(*)


STYLE_ID              STYLE_NAME     CATEGORY          COST
895840                  SANDAL               85909                    12.00
968950                  SANDAL               85909                    10.00
758960                  SANDAL               86979   
869506                  SANDAL               89690                    15.00

STYLE_ID              STYLE_NAME     CATEGORY          COST
895840                  SANDAL               85940                    12.00
968950                  SANDAL               85909                    10.00
758960                  SANDAL               86979   

STYLE_ID              STYLE_NAME     CATEGORY          COST
895840                  SANDAL               85909                    12.00
968950                  SANDAL               85909                    10.00
869506                  SANDAL               89690                    15.00

758960                  SANDAL               86979    

Komentar

  1. Which statement concerning single row functions is true? Mark for Review
    (1) Points


    Single row functions return one or more results per row.


    Single row functions can be nested. (*)


    Single row functions cannot modify a data type.


    Single row functions can accept only one argument, but can return multiple values.

    BalasHapus
  2. What is the result of the following statement:
    SELECT last_name, COALESCE(commission_pct, manager_id, -1) comm
    FROM employees ;

    Mark for Review
    (1) Points


    King, -1
    Kochhar, 100
    Vargas, 124
    Zlotkey, .2
    (*)



    Statement will fail


    King, null
    Kochhar, 100
    Vargas, 124
    Zlotkey, .2


    King, -1
    Kochhar, 100
    Vargas, 124
    Zlotkey, 100

    BalasHapus
  3. The PRODUCT table contains this column: PRICE NUMBER(7,2)
    Evaluate this statement:

    SELECT NVL(10 / price, '0')
    FROM PRODUCT;

    What would happen if the PRICE column contains null values?

    The statement would fail because values cannot be divided by 0.


    A value of 0 would be displayed. (*)


    A value of 10 would be displayed.


    The statement would fail because values cannot be divided by null.

    BalasHapus
  4. With the following data in Employees (last_name, commission_pct, manager_id) what is the result of the following statement?
    DATA:
    King, null, null
    Kochhar, null, 100
    Vargas, null, 124
    Zlotkey, .2, 100

    SELECT last_name, NVL2(commission_pct, manager_id, -1) comm
    FROM employees ;

    King, -1
    Kochhar, 100
    Vargas, 124
    Zlotkey, .2



    Statement will fail.


    King, -1
    Kochhar, -1
    Vargas, -1
    Zlotkey, 100

    (*)


    King, -1
    Kochhar, -1
    Vargas, -1
    Zlotkey, .2

    BalasHapus
  5. Detox Pills: Best Weed Detox KitDetox drinks are touted for their ability to flush THC out of the body on the very day of consumption, albeit temporarily. Most detox drinks are effective only for a few hours. Nonetheless, these detox drinks can help amplify your body’s natural detox process.Detox drinks are cleansing supplements that may taste like energy drinks. Consumers may have to drink the entire bottle exactly 60–90 minutes before the drug screening to come out undetected, though some detox drinks are required to be taken for a longer period of time days before the test., then these pills can help get rid of that too Visit: https://www.urineworld.com/

    BalasHapus
  6. 4. What three statements are true about explicit data type conversions? (Select three.)
    (Choose all correct answers)
    (0/1) Points
    Use the TO_DATE function to convert a date value to a character string or a number.
    Use the TO_NUMBER function to convert a number to a character string.
    Use the TO_DATE function to convert a character string to a date value. (*)
    Use the TO_CHAR function to convert a numeric or date value to a character string. (*)
    Use the TO_NUMBER function to convert a character string from digits to a number. (*)

    10. With the following Employees data (last_name, commission_pct, manager_id), what is the result of the following statement?
    DATA:
    King, null, null
    Kochhar, null, 100
    Vargas, null, 124
    Zlotkey, .2, 100
    SELECT last_name, NVL2 (commission_pct, manager_id, -1) comm
    FROM employees;

    (0/1) Points
    The sentence will fail.
    King, -1
    Kochhar, 100
    Vargas, 124
    Zlotkey, .2

    King, -1
    Kochhar, -1
    Vargas, -1
    Zlotkey, 100 (*)

    King, -1
    Kochhar, -1
    Vargas, -1
    Zlotkey, .2

    BalasHapus
  7. buat anda yang sudah menunggu lama slot online deposit pulsa tanpa potongan sekarang saat nya bermain disini. https://198.252.110.85/

    BalasHapus
  8. mainkan game slot gacor sekarang juga di situs judi online deposit pulsa tanpa potongan http://139.59.77.247/

    BalasHapus
  9. For activating YoutubeTV you need to go on 'tv.youtube.com/start', 'tv youtube com start', 'tv.youtube.comstart' or any other YouTubeTV related issues please do visit https://youtvstart.com/

    BalasHapus
  10. Deni Ace: Section 5 Quiz Oracle Database Programming With Sql >>>>> Download Now

    >>>>> Download Full

    Deni Ace: Section 5 Quiz Oracle Database Programming With Sql >>>>> Download LINK

    >>>>> Download Now

    Deni Ace: Section 5 Quiz Oracle Database Programming With Sql >>>>> Download Full

    >>>>> Download LINK

    BalasHapus
  11. Deni Ace: Section 5 Quiz Oracle Database Programming With Sql >>>>> Download Now

    >>>>> Download Full

    Deni Ace: Section 5 Quiz Oracle Database Programming With Sql >>>>> Download LINK

    >>>>> Download Now

    Deni Ace: Section 5 Quiz Oracle Database Programming With Sql >>>>> Download Full

    >>>>> Download LINK 9V

    BalasHapus

  12. Bliss Solution
    Social media marketing (SMM) is continually progressing and adapting, becoming a for companies and brands. Social media platforms like Facebook, Twitter, LinkedIn, and Instagram can dynamically increase exposure and interest in your company. Search engines like Google and Bing are beginning to integrate updates, Tweets, profiles, and comments into their results pages, recognizing the importance of social interaction.


    About Us - CIC World Immigration Consultant
    CIC immigration consultancy is a one-stop answer for giving clients unending quality administrations in migration. We have the best group of master experts. We have begun the firm to give another way to deal with the movement field. In the present roaring economy, the people like to travel to another country for studies and earning.


    BalasHapus
  13. Which best describes the TO_CHAR function?
    The TO_CHAR function can only be used on Date columns.
    The TO_CHAR function can be used to specify meaningful column names in an SQL statement's result set.
    The TO_CHAR function can be used to display dates and numbers according to formatting conventions that are supported by Oracle. (*)
    The TO_CHAR function can be used to remove text from column data that will be returned by the database.

    BalasHapus
  14. You have been asked to create a report that lists all customers who have placed orders of at least $2,500. The report's date should be displayed using this format:
    Day, Date Month, Year (For example, Tuesday, 13 April, 2004 ).
    Which statement should you issue?
    SELECT companyname, TO_CHAR (sysdate, 'fmdd, dy month, yyyy'), total
    FROM customers NATURAL JOIN orders
    WHERE total >= 2500;
    SELECT companyname, TO_DATE (sysdate, 'dd, dy month, yyyy'), total
    FROM customers NATURAL JOIN orders
    WHERE total >= 2500;
    SELECT companyname, TO_CHAR (sysdate, 'fmDay, dd Month, yyyy'), total
    FROM customers NATURAL JOIN orders
    WHERE total >= 2500; (*)
    SELECT companyname, TO_DATE (date, 'day, dd month, yyyy'), total
    FROM customers NATURAL JOIN orders
    WHERE total >= 2500;

    BalasHapus
  15. The EMPLOYEES table contains these columns:
    EMPLOYEE_ID NUMBER(9)
    LAST_NAME VARCHAR2 (25)
    FIRST_NAME VARCHAR2 (25)
    SALARY NUMBER(6)
    You need to create a report to display the salaries of all employees. Which SQL Statement should you use to display the salaries in format: "$45,000.00"?

    SELECT TO_CHAR(salary, '$999,999')
    FROM employees;
    SELECT TO_NUM(salary, '$999,990.99')
    FROM employees;
    SELECT TO_NUM(salary, '$999,999.00')
    FROM employees;
    SELECT TO_CHAR(salary, '$999,999.00')
    FROM employees; (*)

    BalasHapus

Posting Komentar

Postingan populer dari blog ini

Section 6 Quiz Oracle Database Programming with SQL

Section 6 Quiz             (Answer all questions in this section)                                                             1.         Given the following descriptions of the employees and jobs tables, which of the following scripts will display each employee ï¾’ s possible minimum and maximum salaries based on their job title? EMPLOYEES Table: Name   Null?    Type EMPLOYEE_ID          NOT NULL     NUMBER (6) FIRST_NAME             VARCHAR2 (20) LAST_NAME  NOT NULL     VARCHAR2 (25) EMAIL NOT NULL     VARCHAR2 (25) PHONE_NUMBER                  VARCHAR2 (20) HIRE_DATE   NOT NULL     DATE JOB_ID           NOT NULL     VARCHAR2 (10) SALARY                     NUMBER (8,2) COMMISSION_PCT                NUMBER (2,2) MANAGER_ID                       NUMBER (6) DEPARTMENT_ID                 NUMBER (4) JOBS Table: Name   Null?    Type JOB_ID           NOT NULL     VARCHAR2 (10) JOB_TITLE     NOT NULL     VARCHAR2 (35) MIN_SALARY                      

Section 10 Quiz Database Programming With SQL

Section 10 Quiz             (Answer all questions in this section) 1.         A multiple-row operator expects how many values?   Mark for Review (1) Points             One or more (*)             Only one             Two or more             None 2.         The salary column of the f_staffs table contains the following values: 4000 5050 6000 11000 23000 Which of the following statements will return the last_name and first_name of those employees who earn more than 5000?  Mark for Review (1) Points             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT last_name, first_name FROM f_staffs WHERE salary <5000 o:p="">             SELECT last_name, first_name FROM f_staffs WHERE salary = (SELECT salary FROM f_staffs WHERE salary < 5000);             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT salary FROM f_staffs WHERE salary > 5000); (*)             SELEC

Section 6 Quiz Database Design Oracle

Section 6 Quiz             (Answer all questions in this section) 1.         Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES:     # CLIENT ID     FIRST NAME     LAST NAME     STREET     CITY     ZIP CODE  Mark for Review (1) Points             1st Normal Form.             2nd Normal Form.             3rd Normal Form.             None of the above, the entity is fully normalised. (*) 2.         A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review (1) Points             True (*)             False 3.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review (1) Points             Functional dependency             Dependency             Transitive dependency (*)             Non-dependency