-
编辑 删除
047-034
34. View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMStables. Evaluate the following SQL statement:SELECT oi.order_id, product_id, order_dateFROM order_items oi JOIN orders o USI...
-
编辑 删除
047-033
33. 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:SEL...
-
编辑 删除
047-032
32. Which two statements are true regarding views? (Choose two.)A. A simple view in which column aliases have been used cannot be updated.B. A subquery used in a complex view definition cannot contain...
-
编辑 删除
047-030
30. You need to create a table for a banking application with the followingconsiderations:1) You want a column in the table to store the duration of the credit period.2) The data in the column should ...
-
编辑 删除
047-029
29. A non-correlated subquery can be defined as ____.A. a set of sequential queries, all of which must always return a single valueB. a set of sequential queries, all of which must return values from ...
-
编辑 删除
042-028
28. Which two statements are true regarding the EXISTS operator used in thecorrelated subqueries? (Choose two.)A. The outer query stops evaluating the result set of the inner query whenthe first value...
-
编辑 删除
047-026
26. Which statement is true regarding external tables?A. The default REJECT LIMIT for external tables is UNLIMITED.B. The data and metadata for an external table are stored outside thedatabase.C. ORAC...
-
编辑 删除
047-023
23. View the Exhibit and examine the structure of the CUST table.Evaluate the following SQL statements executed in the given order:ALTER TABLE cust ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id) DEFER...
-
编辑 删除
047-020
20. In which scenario would you use the ROLLUP operator for expression orcolumns within a GROUP BY clause?A. to find the groups forming the subtotal in a rowB to create group-wrise grand totals for th...
-
编辑 删除
047-022
22. Which statement correctly grants a system privilege?A. GRANT EXECUTE ON proc1 TO PUBLIC.B. GRANT CREATE VIEW ON table1 TO user1.C. GRANT CREATE TABLE TO user1,user2.D. GRANT CREATE SESSION TO ALL....
-
编辑 删除
知识点
知识点：pivoting condition insert merge
-
编辑 删除
047-014
14. OE and SCOTT are the users in the database. The ORDERS table is ownedby OE. Evaluate the statements issued by the DBA in the following sequence:CREATE ROLE r1.GRANT SELECT, INSERT ON oe.orders TO ...
-
编辑 删除
047-013
13. Which two statements are true regarding the execution of the correlatedsubqueries? (Choose two.)A. The nested query executes after the outer query returns the row.B. The nested query executes firs...
-
编辑 删除
047-006
6. Which two statements are true? (Choose two.)A. The USER_SYNONYMS view can provide information about private synonyms.B. The user SYSTEM owns all the base tables and user-accessible views of thedata...
-
编辑 删除
047-004
4. View the Exhibit and examine the structure of the EMP table which is notpartitioned and not an indexorganized table.Evaluate the following SQL statement:ALTER TABLE emp DROP COLUMN first_name.Which...
-
编辑 删除
042-178
178. Which two statements are true about the Flashback technology? (Choose two)A.The accidental loss of schema can be recovered.B.The accidental loss of tablespace can be recovered.C.The restoration o...
-
编辑 删除
042-177
177. The abnormal termination of the database background process causes the database instance to shut down without synchronizing the database files. The steps that will be performed at the next instan...
-
编辑 删除
042-176
176. You execute the following set of commands to create a database user and to grant the system privileges in your production database: SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE...
-
编辑 删除
042-174
174: You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time? (Choose two)A. By multiplexing the control filesB. By multiplexin...
-
编辑 删除
042-170
170: You want to perform. a backup of your database to tape. Which backup format can you use?A. backup set onlyB.image copyonlyC. only user-managed backupD. both image copy and backup setE. only incre...
