071考題解析-第61題、choose the best answer:
View the Exhibit and examine the structure of the CUSTOMERS table.
You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10,000.
Evaluate the following two queries:
SQL SELECT cust_last_name, cust_credit_limit FROM customers
WHERE (UPPER(cust_last_na........詳情
071考題解析-第62題、choose the best answer:
You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.
Examine the sample output:
Which query will provide the required output?
A) SELECT LISTAGG(last_name, '; ') "Emp_list", MIN(hire_date) "Earliest"
FROM employees
WHERE department_id = 30
WITHIN GROUP ORDER BY hire_date;
B) SELECT LISTAGG(last_name, '; ') "EM........詳情
071考題解析-第63題、choose the best answer:
View the Exhibit and examine the data in the PRODUCTS table.
Which statement would add a column called PRICE, which cannot contain NULL?
A) ALTER TABLE products
ADD price NUMBER(8,2) DEFAULT NOT NULL;
B) ALTER TABLE products
ADD price NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL;
C) ALTER TABLE products
ADD price NUMBER(8,2) NOT NULL;
D) ALTER ........詳情
071考題解析-第64題、choose the best answer:
View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables.
Evaluate the following SQL statement:
SELECT oi.order_id, product_id, order_date
FROM order_items oi JOIN orders o
USING(order_id);
Which statement is true regarding the execution of this SQL statement?
A) The statement would not execute because the table alias prefi........詳情
071考題解析-第65題、choose the best answer:
The CUSTOMERS table has the following structure:
You need to write a query that does the following tasks:
1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.
2. Only those customers whose income level has a value should be considered.
3. Customers whose tax amount is null should not be considered.
Which st........詳情
071考題解析-第66題、choose two
Examine the structure proposed for the TRANSACTIONS table:
Which two statements are true regarding the creation and storage of data in the above table structure?
A) The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds,
and fractions of seconds.
B) The CUST_STATUS column would store exactly one character.
C) The TRANS........詳情
071考題解析-第67題、choose the best answer:
View the Exhibit and examine the structure of CUSTOMERS table.
Evaluate the following query:
SQLSELECT cust_id, cust_city
FROM customers
WHERE cust_first_name NOT LIKE 'A_%g_%' AND
cust_credit_limit BETWEEN 5000 AND 15000 AND
cust_credit_limit NOT IN (7000, 11000) AND
cust_city NOT BETWEEN 'A' AND 'B';
Which statement is true regarding the ab........詳情
071考題解析-第68題、choose two:
Which two statements are true? (Choose two.)
A) DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.
B) The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.
C) All the dynamic performance views prefixed with v$ are accessible to all the database users.
D) The USER_OBJECTS ........詳情
071考題解析-第69題、choose the best answer:
Evaluate the following query:
SELECT INTERVAL '300' MONTH,
INTERVAL '54-2' YEAR TO MONTH,
INTERVAL '11:12:10.1234567' HOUR TO SECOND
FROM dual;
What is the correct output of the above query?
A) +25-00 , +00-650, +00 11:12:10.123457
B) +25-00 , +54-02, +00 11:12:10.123457
C) +00-300, +00-650, +00 11:12:10.123457
D) +00-300, +54-02, +00 11:12:10........詳情
071考題解析-第70題、choose the best answer:
View the Exhibit and examine the structure of the Book table.
The BOOKS table contains details of 100 books.
Examine the commands executed and their outcome:
SQLINSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer',null,null);
1 row created.
SQLSAVEPOINT A;
Savepoint created.
SQLDELETE FROM books;
101 rows deleted.
SQLROLLBACK TO SAVE........詳情
071考題解析-第51題、choose the best answer:
Evaluate the following SQL statement:
SQL SELECT cust_id, cust_last_name
FROM customers
WHERE cust_credit_limit IN
(select cust_credit_limit
FROM customers
WHERE cust_city ='Singapore');
Which statement is true regarding the above query if one of the values generated by the subquery is NULL?.....詳情
071考題解析-第52題、choose the best answer:
Examine the structure and data in the PRICE_LIST table:
You plan to give a discount of 25% on the product price and need to display the discount amount
in the same format as the PROD_PRICE.
Which SQL statement would give the required result?.....詳情
071考題解析-第53題、choose the best answer:
Examine the command to create the BOOKS table.
SQLCREATE TABLE books
(book_id CHAR(6) PRIMARY KEY,
title VARCHAR2(100) NOT NULL,
publisher_id VARCHAR2(4),
author_id VARCHAR2(50));
The BOOK_ID value 101 does not exist in the table.
Examine the SQL statement:
SQL INSERT INTO books(BOOK_ID, TITLE, AUTHOR_ID)
VALUES ('101', 'LEARNING SQL', 'Tim Jo........詳情
071考題解析-第54題、choose the best answer:
View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables.
You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000.
You executed the following SQL statement:
SELECT order_id, product_id, unit_price*quantity "Total Price"
FROM order_it........詳情
071考試不僅是OCP11g的考試科目，同時(shí)也是OCP 12c的考試科目，所以關(guān)心071考題的同學(xué)有很多，對(duì)此我們專門收集整理了近期071考試的原題，并對(duì)這些考題進(jìn)行講解，希望幫助廣大考生順利通過(guò)071考試。--------------------------------------------071考題解析-第55題、choose the best answer:Which statement is true regarding the SESSION_PRIVS dictionary view?A) It contains the object privileges granted to other users b........詳情
071考題解析-第56題、choose the best answer:
You need to create a table with the following column specifications:
1. Employee ID (numeric data type) for each employee
2. Employee Name (character data type) that stores the employee name
3. Hire date, which stores the date of joining the organization for each employee
4. Status (character data type), that contains the value 'ACTIVE' if no data ........詳情
071考題解析-第57題、choose two:
Examine the structure of the DEPARTMENTS table
You execute the following command:
SQL ALTER TABLE departments
SET UNUSED (country);
Which two statements are true?.....詳情
071考題解析-第58題、choose the best answer:
Examine the structure of the BOORSTRANSACTIONS table:
Examine the SQL statement:
SQL SELECT FROM books_transactions WHERE borrowed_date
MEMBER_ID IN ('A101', 'A102');
Which statement is true about the outcome?.....詳情
071考題解析-第59題、choose two:
Which two statements are true regarding the USING and ON clauses in table joins?
A) The ON clause can be used to join tables on columns that have different names but compatible data types.
B) A maximum of one pair of columns can be joined between two tables using the ON clause.
C) Both USING and ON clauses can be used for equijoins and nonequijoins.
D) The WHE........詳情
071考題解析-第60題、choose the best answer:
Evaluate the following SQL commands:
SQLCREATE SEQUENCE ord_seq
INCREMENT BY 10
START WITH 120
MAXVALUE 9999
NOCYCLE;
SQLCREATE TABLE ord_items
(ord_no NUMBER(4) DEFAULT ord_seq.NEXTVAL NOT NULL,
item_no NUMBER(3),
qty RIUNBER(3) CHECK (qty BETWEEN 100 AND 200),
expiry_date date CHECK (expiry_date SYSDATE),
CONSTRAINT it_pk PRIMARY REY (ord........詳情
