Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Answer:: C. D. E. F

    Uploaded by

    Miriam Almeida

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Answer:: C. D. E. F

    Uploaded by

    Miriam Almeida
    21 views3 pages

    Original Title

    2

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    21 views3 pages

    Answer:: C. D. E. F

    Uploaded by

    Miriam Almeida

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 3

    IT Certification Guaranteed, The Easy Way!

    C. CORADER BY 1, LNAME DESC


    D. WHERE city='%AN%;
    E. WHERE city LIKE '%AN%;
    F. WHERE city IN ('%AN%')
    Answer: C,E

    NO.12 Examine the description or the BOOKS_TRANSACTIONS table:

    FOR customers whose income level has a value, you want to display the first name and due amount
    as 5% of their credit limit. Customers whose due amount is null should not be displayed.
    Which query should be used?
    A. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
    FROM customers
    WHERE cust income_level !=NULL
    AND cust credit_level !=NULL;
    B. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
    FROM customers
    WHERE cust income_level IS NOT NULL
    AND due_amount IS NOT NULL;
    C. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
    FROM customers
    WHERE cust income_level <> NULL
    AND due_amount <> NULL;
    D. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
    FROM customers
    WHERE cust_income_level IS NOT NULL
    AND cust_credit_limit IS NOT NULL;
    E. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
    FROM customers
    WHERE cust income_level !=NULL
    AND due_amount !=NULL;
    Answer: D

    NO.13 Which two statements are true about external tables?


    A. Indexes can be created on them.
    B. You can populate them from existing data in the database by using the CREATE TABLE AS SELECT
    command.
    C. DML statements cannot be used on them.
    D. Their data can be retrieved by using only SQL or PL/SQL.

    5
    IT Certification Guaranteed, The Easy Way!

    E. Their metadata and actual data are both stored outside the database.
    Answer: B,C

    NO.14 Examine the description of the sales table.


    The sales table has 55,000 rows.
    Examine this statements:
    Which two statements are true?
    A. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those
    constraints in the SALES table.
    B. SALES1 created with 55, 000 rows
    C. SALES1 created with no rows.
    D. SALES1 created with 1 row.
    E. SALES1 has NOT NULL constraints on any I selected columns which had those constraints I in the
    SALES table.
    Answer: B,E

    NO.15 Which three are true about privileges?


    A. Schema owners can grant object privileges on objects in their schema to any other user or role.
    B. A combination of object and system privileges can be granted to a role.
    C. All types of schema objects have associated object privileges .
    D. Only users with the DBA role can create roles .
    E. Object privileges granted on a table automatically apply to all synonyms for that table.
    F. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from
    other users.
    Answer: A,B,C

    NO.16 Which three statements are true about GLOBAL TEMPORARY TABLES?
    A. A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM.
    B. A GLOBAL TEMPORARY TABLE can have multiple indexes
    C. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
    D. Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.
    E. A GLOBAL TEMPORARY TABLE can have only one index.
    F. A trigger can be created on a GLOBAL TEMPORARY TABLE
    Answer: B,C,F

    NO.17 Which two statements execute successfully?


    A. SELECT TO_ DATE('2019-DEC-25 15:30', 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE
    =AMERICAN' ) FROM DUAL;
    B. SELECT TO_CHAR('2019-DEC-25 15:30", YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE =
    AMERICAN')
    FROM DUAL;
    C. SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI'))
    FROM DUAL;

    6
    IT Certification Guaranteed, The Easy Way!

    D. SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI'))


    FROM DUAL
    E. SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI')
    FROM DUAL
    Answer: A,D

    NO.18 Which three statements are true about Data Manipulation Language (DML)?
    A. delete statements can remove multiple rows based on multiple conditions.
    B. insert statements can insert nulls explicitly into a column.
    C. insert into. . .select. . .from statements automatically commit.
    D. DML statements require a primary key be defined on a table.
    E. update statements can have different subqueries to specify the values for each updated column.
    Answer: A,B,E

    NO.19 Which two are true about global temporary tables?


    A. They can be created only by a user with the DBA role,but can be accessed by all users who can
    create a session.
    B. Backup and recovery operations are available for these tables.
    C. If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.
    D. Their data is always stored in the default temporary tablespace of the user who created them.
    E. Indexes can be created on them.
    F. If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each
    COMMIT or ROLLBACK.
    Answer: C,F

    NO.20 Which two statements will do an implicit conversion?


    A. SELECT * FROM customers WHERE customer_ id = 0001 ;
    B. SELECT * FROM customers WHERE customer id = '0001';
    C. SELECT * FROM customers WHERE insert_ date = DATE '2019-01-01';
    D. SELECT * FROM customers WHERE insert date ='01-JAN-19'
    E. SELECT * FROM customers WHERE TO_ CHAR (customer_ id) ='0001';
    Answer: B,D

    NO.21 Examine this statement which executes successfully:


    Which statement will violate the CHECK constraint?
    A. UPDATE emp80
    SET department_id=90
    WHERE department_id=80;
    B. DELETE FROM emp80
    WHERE department_id=90;
    C. SELECT *
    FROM emp80
    WHERE department_id=80;

    You might also like