03 2019 档案
摘要：80、View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables. You need to create a view that displays the ORDER_ID, ORDER_DATE, and
阅读全文
摘要：79、Which statement is true about transactions? A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT
阅读全文
摘要：78、View the exhibit and examine the structure of the CUSTOMERStable. Which two tasks would require subqueries or joins to be executed in a single stat
阅读全文
摘要：77、Which two statements are true about sequences created in a single instance database? (Choose two.) A. When the MAXVALUElimit for the sequence is re
阅读全文
摘要：76、View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables. The retrieve data for all the employees for their EMPLOYEE_ID,
阅读全文
摘要：75、Which statements are correct regarding indexes? (Choose all that apply.) A. A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automati
阅读全文
摘要：74、View the exhibit and examine the structure of ORDERS and CUSTOMERS tables. ORDERS Name Null? Type ORDER_ID NOT NULL NUMBER(4) ORDER_DATE NOT NULL D
阅读全文
摘要：73、Which statement correctly grants a system privilege? A. GRANT CREATE VIEW ON table1 TO user1; B. GRANT ALTER TABLE TO PUBLIC; C. GRANT CREATE TABLE
阅读全文
摘要：72、View the exhibit for the structure of the STUDENTand FACULTYtables. STUDENT Name Null? Type STUDENT_ID NOT NULL NUMBER(2) STUDENT_NAME VARCHAR2(20)
阅读全文
摘要：71、(32-18) choose three Which three statements indicate the end of a transaction? (Choose three.) A) after a CREATE statement is issued B) after a SEL
阅读全文
摘要：70、(31-2)choose the best answer: View the Exhibit and examine the structure of the Book table. The BOOKS table contains details of 100 books. Examine
阅读全文
摘要：69、(31-1)choose the best answer: Evaluate the following query: SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567'
阅读全文
摘要：68、(29-13)choose two: Which two statements are true? (Choose two.) A) DICTIONARY is a view that contains the names of all the data dictionary views th
阅读全文
摘要：67、(25-8)choose the best answer: View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query: SQL>SELECT cust_id, cust
阅读全文
摘要：66、(22-19)choose two Examine the structure proposed for the TRANSACTIONS table: Which two statements are true regarding the creation and storage of da
阅读全文
摘要：65、(22-16) choose the best answer: The CUSTOMERS table has the following structure: You need to write a query that does the following tasks: 1. Displa
阅读全文
摘要：64、(22-7) choose the best answer: View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. Evaluate the following SQL statemen
阅读全文
摘要：63、(22-4) choose the best answer: View the Exhibit and examine the data in the PRODUCTS table. Which statement would add a column called PRICE, which
阅读全文
摘要：62、(13-17)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:
阅读全文
摘要：61、(18-6) choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. You want to generate a report showing the last na
阅读全文
摘要：60、(16-10) choose the best answer: Evaluate the following SQL commands: SQL>CREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYC
阅读全文
摘要：59、(16-8)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 c
阅读全文
摘要：58、(16-1) choose the best answer: Examine the structure of the BOORSTRANSACTIONS table: Examine the SQL statement: SQL> SELECT FROM books_transactions
阅读全文
摘要：57、(14-17) choose two: Examine the structure of the DEPARTMENTS table You execute the following command: SQL> ALTER TABLE departments SET UNUSED (coun
阅读全文
摘要：56、(14-14) choose the best answer: You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each em
阅读全文
摘要：55、(13-3) choose the best answer: Which statement is true regarding the SESSION_PRIVS dictionary view? A) It contains the object privileges granted to
阅读全文
摘要：54、(12-15) choose the best answer: View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDE
阅读全文
摘要：53、(12-14) choose the best answer: Examine the command to create the BOOKS table. SQL>CREATE TABLE books (book_id CHAR(6) PRIMARY KEY, title VARCHAR2(
阅读全文
摘要：52、(12-11) 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
阅读全文
摘要：51、(12-10)choose the best answer: Evaluate the following SQL statement: SQL> SELECT cust_id, cust_last_name FROM customers WHERE cust_credit_limit IN
阅读全文
摘要：50、(11-15)choose two Examine the structure of the MARKS table: Which two statements would execute successfully? A) SELECT SUM(subjectl+subject2+subjec
阅读全文
摘要：49、(11-1) 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 a
阅读全文
