071题库含新题20210115

Choose the best answer. 

Examine the description of the EMPLOYEES table: 

Name                  Null                            Type 

---------------------------------------------------------- 

EMP_ID            NOT NUL                       NUMBER 

EMP_NAME                                           VARCHAR2 (40) 

DEPT_ID                                                NUMBER(2) 

SALARY                                                 NUMBER(8,2) 

JOIN_DATE                                            DATE 

Which query is valid? 

Choose three

Which three are true about the CREATE TABLE command?

Choose two

The CUSTOMERS table has a CUST_CREDT_LIMIT column of data type number. 

Which two queries execute successfully?

Choose two

Examine the description of the PRODUCT DETALS table:

NAME                                 NULL                                      TYPE

--------------------------------------------------

PRODUCT_ID                      NOT NULL                            NUMBER(2)

PRODUCT_NAME               NOT NULL                             VARCHAR2(25) 

PRODUCT_PRICE                                                              NUMBER(8,2)

EXPIRY_DATE                                                                    DATE

Which two statements are true?

Choose the best answer

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. 

The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.

Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

Choose three

Which three statements are true about indexes and their administration in an Oracle database?

Choose three

Which three are true about granting object privileges on tables, views, and sequences?

Choose the best answer

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE

You want to display the date of the first Monday after the completion of six months since hiring

The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week

Which query can be used?

Choose three

Which three statements are true about views in an Oracle database?

Choose two

Which two statements are true about Oracle synonyms?

Choose two.

Which two statements are true about a self join?

Choose two

Which three statements are true about dropping and unused columns in an Oracle database?

Choose the best answer. 

Examine this query:

SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL;

What is the result?

Choose two.

Examine this SQL statement:

UPDATE orders o

SET customer_name =

(SELECT cust_last_name FROM customers

WHERE customer_id=o.customer_id); 

Which two are true?

Choose three

Examine the description of the PRODUCTS table:

Name                                         Null?                                                      Type

-----------------------------------------------------------------

PRODUCT_ID                             NOT NULL                                             NUMBER(2) 

PRODUCT_NANE                                                                                     VARCHAR2(10)

UNIT_PRICE                                                                                              NUMBER(3)

SURCHARGE                                                                                            VARCHAR2(2)

EXPIRY_DATE                                                                                            DATE

DELIVERY_DATE                                                                                       DATE

Which three queries use valid expressions?

Choose two.

Examine this partial command: 

CREATE TABLE cust (

            Cust_id             NUMBER(2), 

            credit_limit       NUMBER(10)

)

ORGANIZATION EXTERNAL

Which two clauses are required for this command to execute successfully?

Choose two

Examine this business rule:

Each student can work on multiple projects and earth project can have multiple students

You must decision an Entity Relationship (ER) model for optional data storage and allow generating reports in this format:

STUDENT_ID        FIRST_NAME       LAST_NAME       PROJECT_ID        PROJECT_NAME       PROJECT_TASK

Which two statements are true?

Choose two

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

Choose two

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE

NLS_DATE_FORMAT is set to DD-MON-RR.

Which two are true about data type conversions involving these columns in query expressions?

Choose two

The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2). Evaluate this SQL statement:

SELECT TO_CHAR(unit_price,'$9,999') FROM PRODUCT_INFORMATION;

Which two statements are true about the output?