071题库含新题20210115

Choose two

In the PROMOTIONS table, the PROMO_BEGTN_DATE column is of data type DATE and the default date format is DD-MON-RR.

Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?

Choose two

Which two statements are true about transactions in the Oracle Database server?

Choose three

Examine this description of the PRODUCTS table:

Name                                          NULL?                                  TYPE

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

PROD_ID                                    NOT NULL                           VARCHAR2(6)

QUANTITY                                                                              NUMBER(8,2)

PRICE                                                                                      NUMBER(10.2)

EXPIRY_DATE                                                                          DATE

Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode. Which three commands execute successfully on PRODUCTS?

Choose three.

Which three statements are true about GLOBAL TEMPORARY TABLES?

Choose three.

Which three statements are true about defining relations between tables in a relational database?

Choose three

Which three actions can you perform only with system privileges?

Choose two

The ORDERS table has a column ORDER_DATE of date type DATE 

The default display format for a date is DD-MON-RR

Which two WHERE conditions demonstrate the correct usage of conversion functions?

Choose two.

ꞏ MANAGER is an existing role with no privileges or roles.

ꞏ EMP is an existing role containing the CREATE TABLE privilege.

ꞏ EMPLOYEES is an existing table in the HR schema. 

Which two commands execute successfully?

Choose two

Evaluate these commands which execute successfully 

CREATE SEQUENCE ord_seq

              INCREMENT BY 1

               START WITH 1

               MAXVALUE 100000 CYCLE

               CACHE 5000;

Create table ord_items(

Ord_no number(4) default ord_seq.nextval not null, 

Item_no number(3),

Qty number(3), 

Expiry_date date,

Constraint it_pk primary key(ord_no,item_no),

Constraint ord_fk foreign key (ord_no) references orders(ord_no));

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

Choose two

Examine the data in the CUST NAME column of the CUSTOMERS table: 

CUST_NAME

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

Renske Ladwig 

Jason Mallin 

Samuel McCain 

Allan MCEwen 

Irene Mikkilineni 

Julia Nayer

You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result?

Choose three

Examine this SQL statement:

SELECT cust_id, cus_last_name "Last Name" 

            FROM customers

WHERE country_id = 10 

UNION

SELECT cust_id CUST_NO, cust_last_name 

            FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully.

Choose three.

Which three statements are true about a self join?

Choose two.

Which two statements are true about the results of using the INTERSECT operator in compound queries?

Choose two

Which two statements are true about the COUNT function?

Choose three

Which three statements are true about sequences in a single instance Oracle database?

Choose the best answer

Examine the description of the PRODUCT_INFORMATION table: 

Name                                NULL?                                  Type

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

PROD_ID                           NOT NULL                       NUMBER(2) 

PROD_NANE                                                             VARCRAR2 (10)

LIST_PRICE                                                                NUMBER(6,2)

Which query retrieves the number of products with a null list price?

Choose two.

You need to calculate the number of days from 1st January 2019 until today. 

Dates are stored in the default format of DD-MON-RR.

Which two queries give the required output?

Choose two

Examine the description of the BOOKS_TRANSACTIONS table 

Name                                                   Null?                                    Type

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

THANSACTION_ID                              NOT NULL                         VARCHAR2(6) 

TRANSACTION_TYPE                                                                    VARCHAR2(3) 

BORROWED_DATE                                                                         DATE

BOOK_ID                                                                                        VARCHAR2(6)

MEMBER_ID                                                                                   VARCHAR2(6)

Examine this partial SQL statement:

SELECT * FROM books_transctions;

Which two WHERE conditions give the same result?

Choose two.

Which two statements are true about single row functions?

Choose two

Examine this SQL statement:

DELETE FROM employees e 

                WHERE EXISTS

                        (SELECT 'dummy' 

                         FROM emp_history

                          WHERE employee_id = eemployee_id) 

Which two are true?