02 2019 档案
摘要：48、(10-12)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 PRODUC
阅读全文
摘要：47、(10-6)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. Whi
阅读全文
摘要：46、(10-4) 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 Mal
阅读全文
摘要：45、(9-16)choose the best answer: View the Exhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total compens
阅读全文
摘要：44、(9-12)choose all that apply View the Exhibit and examine the details of the ORDER_ITEMS table. Evaluate the following SQL statements: Statement 1:
阅读全文
摘要：43、(9-2)choose three Which three tasks can be performed by DDL statements? A) preventing data retrieval from a table outside of office hours B) modify
阅读全文
摘要：42、(9-1)choose the best answer: Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements? A) DELETE but not TRUNCATE statement can
阅读全文
摘要：41、(8-14) choose two View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values 'd
阅读全文
摘要：40、(8-7) choose two Which two statements are true regarding views? (Choose two.) A) A simple view in which column aliases have been used cannot be upd
阅读全文
摘要：39.choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total remuneration for each e
阅读全文
摘要：38.choose the best answer View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon
阅读全文
摘要：19.choose the best answer View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: SQL>SELECT promo_n
阅读全文
摘要：36.choose the best answer View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables. You issue the following query: SQ
阅读全文
摘要：35.choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT first_name
阅读全文
摘要：34.choose two View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the supplies d
阅读全文
摘要：33.choose the best answer View the Exhibit and examine the structure of the ORDER_ITEMS table. Examine the following SQL statement: SELECT order_id, p
阅读全文
摘要：32.choose the best answer View the Exhibit and examine the data in EMP and DEPT tables. In the DEPT table, DEPTNO is the PRIMARY KEY. In the EMP table
阅读全文
摘要：31.choose the best answer Which statement is true regarding the USING clause in table joins? A) It can be used to access data from tables through equi
阅读全文
摘要：30.choose the best answer Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: SQL> CREATE TABLE DEPARTMENT_DETAILS (DEPARTMENT_
阅读全文
摘要：29.choose the best answer Evaluate the following query: SQL> SELECT promo_name || q'{'s start date was \}' || promo_begin_date AS "Promotion Launches"
阅读全文
摘要：28.choose the best answer Evaluate the following SQL statement: SQL> SELECT promo_id, promo_category FROM promotions WHERE promo_category = 'Internet'
阅读全文
摘要：27.choose two The SQL statements executed in a user session are as follows: SQL> CREATE TABLE product (pcode NUMBER(2), pname VARCHAR2(10)); SQL> INSE
阅读全文
摘要：26.choose two Examine the structure of the PRODUCTS table. Which two statements are true? A) EXPIRY_DATE always stores date and time in character form
阅读全文
摘要：25. choose the best answer Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect
阅读全文
摘要：24. choose the best answer In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years. Evaluate the fo
阅读全文
摘要：23.choose the best answer View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the numbe
阅读全文
摘要：5.choose the best answer Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCA
阅读全文
摘要：3.choose three View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where the PR
阅读全文
摘要：20.choose two Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be execute
阅读全文
摘要：1.choose the best answerWhat is the primary difference between the relational database (RDB) andobject-oriented database (OODB) models?A) RDB allows t
阅读全文
摘要：18、（8-7） choose twoWhich two statements are true regarding views? (Choose two.) A) A simple view in which column aliases have been used cannot be upda
阅读全文
摘要：17、（7-11） choose twoView the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.You need to remove from the ORDER_ITEMS table those ro
阅读全文
摘要：16、（7-5） choose the best answerThe PRODUCTS table has the following structure:Evaluate the following two SQL statements:SQL>SELECT prod_id, NVL2(prod_
阅读全文
摘要：15、（6-24）choose the best answerExamine the structure of the MEMBERS table:You want to display details of all members who reside in states starting wit
阅读全文
摘要：14、（6-13） choose the best answer:View the Exhibit and examine the structure of the ORDERS table.Which UPDATE statement is valid? A) UPDATE ordersSET o
阅读全文
摘要：13、（6-7） choose twoWhich two statements are true regarding operators used with subqueries? (Choose two.)A) =ANY and =ALL operators have the same funct
阅读全文
摘要：12、（5-12）choose two:Examine the data in the CUSTOMERS table:You want to list all cities that have more than one customer along with the customer detai
阅读全文
摘要：11、（5-8） 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 'INV
阅读全文
摘要：10、（5-6） choose the best answer:Examine the structure of the EMPLOYEES table:There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.Y
阅读全文
摘要：9、（5-5） choose the best answerView the Exhibit and examine the structure of the SALES and STORES tables.You want to display the store name and the tot
阅读全文
摘要：8、（5-4） choose the best answer:You need to produce a report where each customer's credit limit has been incremented by $1000.In the output, the custom
阅读全文
摘要：7、（5-1） choose two:View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks would require subqueries? A) Display the minimum l
阅读全文
摘要：6、（4-21） choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statement: SQL> SELECT
阅读全文
摘要：5、（4-12） choose two: You executed the following CREATE TABLE statement that resulted in an error: SQL> CREATE TABLE employees( emp_id NUMBER(10) PRIMA
阅读全文
摘要：4、(4-11) choose two:View the Exhibit and examine the data in the PRODUCT_INFORMATION table.Which two tasks would require subqueries? (Choose two.) A)
阅读全文
摘要：3、(4-10) choose the best answer:The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:GRANT ALLON orders, order_i
阅读全文
摘要：2019-02-12 16:23:54 2、(4-7) choose the best answer:You need to display the first names of all customers from the CUSTOMERS table that contain thechara
阅读全文
摘要：choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which ha
阅读全文
