071考试题库_071题库_071最新题库_071考题

071考试题库

【071考试题库】OCP-1Z0-071最新考试题库大全-第53题
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 tabl...
【071考试题库】OCP-1Z0-071最新考试题库大全-第54题
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. ...
【071考试题库】OCP-1Z0-071最新考试题库大全-第55题
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 by the current user session. B) It contains the system privileges granted to other users by the current...
【071考试题库】OCP-1Z0-071最新考试题库大全-第56题
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 j...
【071考试题库】OCP-1Z0-071最新考试题库大全-第57题
Oracle 12c的OCP考试考3科，分别是071、062、063，对于这些考题，我们专门有人负责收集整理，并由专业的老师对这些考题进行解析，希望可以帮助想考OCP的同学，这里开始介绍071的题库。每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验...
【071考试题库】OCP-1Z0-071最新考试题库大全-第58题
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考试题库】OCP-1Z0-071最新考试题库大全-第59题
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 betwe...
【071考试题库】OCP-1Z0-071最新考试题库大全-第60题
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 RIUNBE...
【071考试题库】OCP-1Z0-071最新考试题库大全-第51题
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 ab...
【071考试题库】OCP-1Z0-071最新考试题库大全-第52题
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 requ...
【071考试题库】OCP-1Z0-071最新考试题库大全-第50题
Oracle 12c的OCP考试考3科，分别是071、062、063，对于这些考题，我们专门有人负责收集整理，并由专业的老师对这些考题进行解析，希望可以帮助想考OCP的同学，这里开始介绍071的题库。每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验...
【071考试题库】OCP-1Z0-071最新考试题库大全-第41题
071考试题库-第41题、choose two View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 respectively. Which two INSERT statements are valid? (Choose two.) A) INSERT INTO (SELECT order_i...
【071考试题库】OCP-1Z0-071最新考试题库大全-第42题
071考试题库-第42题、choose three Which three tasks can be performed by DDL statements? A) preventing data retrieval from a table outside of office hours B) modifying a table to prevent data that violate certain conditions from being entered in a column C) preventing any data...
【071考试题库】OCP-1Z0-071最新考试题库大全-第43题
071考试题库-第43题、choose the best answer: Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements? A) DELETE but not TRUNCATE statement can be used to remove data from selective columns and rows of a table. B) DELETE and TRUNCATE statements can have a r...
【071考试题库】OCP-1Z0-071最新考试题库大全-第44题
071考试题库-第44题、choose all that apply View the Exhibit and examine the details of the ORDER_ITEMS table. Evaluate the following SQL statements: Statement 1: SELECT MAX(unit_price*quantity) "Maximum Order" FROM order_items; Statement 2: SELECT MAX(unit_price*quantity...
【071考试题库】OCP-1Z0-071最新考试题库大全-第45题
071考试题库-第45题、choose the best answer: View the Exhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total compensation paid to each employee to date(迄今为止支付给每位员工的总补偿). You issue the following query: SQLSELECT en...
【071考试题库】OCP-1Z0-071最新考试题库大全-第46题
071考试题库-第46题、choose two: Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME ---------------------- Lex De Haan Renske Ladwig Jose Manuel Urman Jason Mallin You want to extract only those customer names that have three names and display the ...
【071考试题库】OCP-1Z0-071最新考试题库大全-第47题
071考试题库-第47题、choose two You need to calculate the number of days from 1st January 2007 till date. Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required output? A) SELECT TO_DATE (SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2...
【071考试题库】OCP-1Z0-071最新考试题库大全-第48题
071考试题库-第48题、choose the best answer View the Exhibit and examine the description for the PRODUCTS and SALES table. PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table with ON DELETE CASCADE option. The SALES table contains data for the la...
【071考试题库】OCP-1Z0-071最新考试题库大全-第49题
071考试题库-第49题、choose the best answer Examine the structure of the SHIPMENTS table: You want to generate a report that displays the PO_ID and the penalty amount to be paid(罚款数额) if the SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per da...
【071考试题库】OCP-1Z0-071最新考试题库大全-第40题
071考试题库-第40题、choose two Which two statements are true regarding views? (Choose two.) A) A simple view in which column aliases have been used cannot be updated. B) The OR REPLACE option is used to change the definition of an existing view without dropping and re-creatin...
【071考试题库】OCP-1Z0-071最新考试题库大全-第31题
071考试题库-第31题、choose the best answer: Examine the structure of the EMPLOYEES table: There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID. You want to display the name, joining date, and manager for all the employees. Newly hired employees are yet t...
【071考试题库】OCP-1Z0-071最新考试题库大全-第32题
071考试题库-第32题、choose the best answer: Examine the structure of the BOOKS_TRANSACTIONS table. You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_ID has been entered. Examine this partial SQL statement: SQL UPDATE books_tra...
【071考试题库】OCP-1Z0-071最新考试题库大全-第33题
Oracle 12c的OCP考试考3科，分别是071、062、063，对于这些考题，我们专门有人负责收集整理，并由专业的老师对这些考题进行解析，希望可以帮助想考OCP的同学，这里开始介绍071的题库。每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验...
【071考试题库】OCP-1Z0-071最新考试题库大全-第34题
Oracle 12c的OCP考试考3科，分别是071、062、063，对于这些考题，我们专门有人负责收集整理，并由专业的老师对这些考题进行解析，希望可以帮助想考OCP的同学，这里开始介绍071的题库。每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验...
【071考试题库】OCP-1Z0-071最新考试题库大全-第35题
071考试题库-第35题、choose the best answer: View the Exhibit and examine the structure of the ORDERS table. Which UPDATE statement is valid? A) UPDATE orders SET order_date = '12-mar-2007' AND order_total = TO_NUMBER(NULL) WHERE order_id = 2455;
【071考试题库】OCP-1Z0-071最新考试题库大全-第36题
Oracle 12c的OCP考试考3科，分别是071、062、063，对于这些考题，我们专门有人负责收集整理，并由专业的老师对这些考题进行解析，希望可以帮助想考OCP的同学，这里开始介绍071的题库。每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验...
【071考试题库】OCP-1Z0-071最新考试题库大全-第37题
071考试题库-第37题、choose the best answer The PRODUCTS table has the following structure: Evaluate the following two SQL statements: SQLSELECT prod_id, NVL2(prod_expiry_date, prod_expiry_date + 15,'') FROM products; SQLSELECT prod_id, NVL(prod_expiry_date, prod_expiry_da...
【071考试题库】OCP-1Z0-071最新考试题库大全-第38题
071考试题库-第38题、choose two View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table. Which two DELETE statements are valid? (Choose two.) ...
【071考试题库】OCP-1Z0-071最新考试题库大全-第39题
071考试题库-第39题、choose two Which two statements are true regarding views? (Choose two.) A) A simple view in which column aliases have been used cannot be updated. B) The OR REPLACE option is used to change the definition of an existing view without dropping and re-creatin...