数据库:Oracle DBA成长之路
从理论到实践,一步一步学习Oracle。
城风漫漫
路漫漫其修远兮,吾将上下而求索。
展开
-
1z0-071 Oracle Database 12c SQL 第48题 GROUP BY
Q48. Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)A. You can use column alias in the GROUP BY clause.B. Using the WHERE clause after the GROUP BY clause...转载 2018-06-22 16:50:57 · 818 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第3题 external table外部表
Q3. Whichstatement is true regarding external tables?A. The defaultREJECT LIMIT for external tables is UNLIMITED.B. The data andmetadata for an external table are stored outside the database.C. ORA...转载 2018-06-13 22:26:06 · 1837 阅读 · 1 评论 -
1z0-071 Oracle Database 12c SQL 第62题 INTERSECT交叉查询
Q62. Which statement is true regarding the INTERSECT operator?A. It ignores NULL values.B.The number of columns and data types must be identical for all SELECT statements in the query.C. The names of ...转载 2018-06-23 13:34:27 · 611 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第67题 模糊搜索
Q67. Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAME-——————Renske LadwigJason MallinSamuel McCainAllan MCEwenIrene MikilineniJulia NayerYou need to display customers’ second ...转载 2018-06-24 11:15:41 · 620 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第5题 roles角色
Q5. Which two statements are true regarding roles? (Choose two.)A. A role can be granted to itself.B. A role can be granted to PUBLIC.C. A user can be granted only one role at any point of time.D. The...转载 2018-06-13 23:39:42 · 1306 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第72题 less than the highest
Q72. View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.Evaluate the following SQL statement:SQL> SELECT prod_id FROM costsWHERE promo_id IN (SELECT promo_id FROM promo...转载 2018-06-24 11:16:13 · 867 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第56题 Natural join
Q56. View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following ...转载 2018-06-23 13:06:36 · 839 阅读 · 1 评论 -
1z0-071 Oracle Database 12c SQL 第12题 &转义字符
Q12. You execute the following commands:SQL > DEFINE hiredate = ’01-APR-2011′SQL >SELECT employee_id, first_name, salaryFROM employeesWHERE hire_date > ‘&hiredate’AND manager_id > &...转载 2018-06-15 00:16:53 · 1344 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第26题 normal form
Q26. Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?A. first normal formB. second normal formC. third normal formD. fourth normal formCorrect Answer: ...转载 2018-06-20 11:25:06 · 1758 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第68题 CREATE TABLE AS
Q68. View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.Simila...转载 2018-06-24 11:15:48 · 674 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第17题 ERD(ER模型)
Q17. Examine the business rule:Each student can take up multiple projects and each project can have multiple students.You need to design an Entity Relationship Model (ERD) for optimal data storage and...转载 2018-06-15 00:43:08 · 2266 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第39题 single quotation mark单引号
Q39. Evaluate the following SQL statement:SELECT product_name || ‘it’s not available for order’FROM product_informationWHERE product_status = ‘obsolete’;You received the following error while executin...转载 2018-06-21 09:42:41 · 884 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第49题 OUTER JOIN
Q49. Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:SQL>CREATE TABLE DEPARTMENT_DETAILS(DEPARTMENT_ID NUMBER PRIMARY KEY,DEPARTMENT_NAME VARCHAR2(50),HOD VARCHAR2(50));SQ...转载 2018-06-22 16:51:03 · 1281 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第70题 group functions
Q70. Which three statements are true regarding group functions? (Choose three.)A. They can be used on columns or expressions.B. They can be passed as an argument to another group function.C. They can ...转载 2018-06-24 11:16:02 · 835 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第31题 subquenes
Q31. Which three statements are true reading subquenes?A. A Main query can have many subqueries.B. A subquery can have more than one main queryC. The subquery and main query must retrieve date from th...转载 2018-06-20 11:51:03 · 776 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第28题 SET UNUSED
Q28. Evaluate the following ALTER TABLE statement:ALTER TABLE ordersSET UNUSED (order_date);Which statement is true?A. The DESCRIBE command would still display the ORDER_DATE column.B. ROLLBACK can be...转载 2018-06-20 11:32:19 · 1664 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第57题 序列 sequences
Q57. Which two statements are true about sequences created in a single instance database? (Choose two.)A. CURRVAL is used to refer to the last sequence number that has been generated.B. DELETE <seq...转载 2018-06-23 13:11:58 · 647 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第34题 COUNT function
Q34. Which two statements are true regarding the COUNT function?A. COUNT (*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns.B. COUNT (cust_id)...转载 2018-06-21 09:42:10 · 535 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第18题 AND语句
Q18. View the Exhibit and examine the details of the PRODUCT_INFORMATION table.You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 ...转载 2018-06-15 00:51:03 · 671 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第41题 NVL2
Q41. Examine the structure of the INVOICE table.Name Null? Type-—————– ——————- ————-INV_NO NOT NULL NUMBER(3)INV_DATE DATEINV_AMT NUMBER(10,2)Which two SQL statements would execute successfully?A. SEL...转载 2018-06-21 10:05:02 · 719 阅读 · 2 评论 -
1z0-071 Oracle Database 12c SQL 第16题 in和or语句
Q15. Evaluate the following two queries:SQL> SELECT cust_last_name, cust_cityFROM customersWHERE cust_credit_limit IN (1000, 2000, 3000);SQL> SELECT cust_last_name, cust_cityFROM customersWHERE ...转载 2018-06-15 00:38:30 · 692 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第37题 transaction事务
Q37. When does a transaction complete? (Choose all that apply.)A. When a PL/SQL anonymous block is executedB. When a DELETE statement is executedC. When a data definition language statement is execute...转载 2018-06-21 09:42:28 · 469 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第11题 DROP语句
Q11. You issue the following command to drop the PRODUCTS table:SQL > DROP TABLE products;Which three statements are true about the implication of this command?A. All data in the table is deleted b...转载 2018-06-15 00:12:20 · 1472 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第42题 DROP语句
Q42. Which three statements are true about the ALTER TABLE….DROP COLUMN…. command?A. A column can be dropped only if it does not contain any data.B. A column can be dropped only if another column exis...转载 2018-06-21 10:07:55 · 1294 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第9题 WITH TIES关键字
Q9. You want to display 5 percent of the rows from the SALES table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the out...转载 2018-06-14 00:56:21 · 2520 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第45题 GRANT命令
Q45. The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command:GRANT ALLON orders, order_itemsTO PUBLIC;What correction needs to be done to the above statemen...转载 2018-06-22 16:50:44 · 1008 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第66题 ROUND和TRUNC
Q66. Evaluate the following query:SQL> SELECT TRUNC (ROUND(156.00, -1),-1)FROM DUAL;What would be the outcome?A. 200B. 16C. 160D. 150E. 100Correct Answer: CExplanation/Reference:References:https://...转载 2018-06-24 11:15:34 · 704 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第60题 CREATE VIEW
Q60. 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 the total number of items in each order.Which CRE...转载 2018-06-23 13:27:46 · 872 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第44题 SQL functions
Q44. Which three tasks can be performed using SQL functions built into Oracle Database?A. combining more than two columns or expressions into a single column in the outputB. displaying a date in a non...转载 2018-06-22 16:50:38 · 720 阅读 · 3 评论 -
1z0-071 Oracle Database 12c SQL 第7题 when语句
Q7.Evaluate the following statement.INSERT ALLWHEN order_total < 10000 THENINTO small_ordersWHEN order_total > 10000 AND order_total < 20000 THENINTO medium_ordersWHEN order_total > 200000...转载 2018-06-13 23:53:01 · 1411 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第73题 按条件更新
Q73. View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY colum...转载 2018-06-24 11:16:19 · 1143 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第27题 MINUS
Q27. View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.The CUSTOMERS table contains the current location of all currently active customers. The CUST_HISTORY table sto...转载 2018-06-20 11:28:21 · 641 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第25题 RIGHT OUTER JOIN和LEFT OUTER JOIN
Q25. Examine the structure of the EMPLOYEES table.Name Null? Type-—————- —– —— ——EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE NU...转载 2018-06-20 11:19:43 · 1887 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第47题 日期函数
Q47. You want to display the date for the first Monday of the next month and issue the following command:What is the outcome?A. It executes successfully and returns the correct result.B. It executes s...转载 2018-06-22 16:50:51 · 695 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第2题 WHERE和HAVING条件
Q2. Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose all that apply.)A. The HAVING clause can be used with aggregate functions in subqueries.B. The WHERE...转载 2018-06-13 22:13:35 · 1086 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第15题 CASE WHEN语句
Q15. See the Exhibit and examine the structure of the PROMOTIONS table:Exhibit:Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in c...转载 2018-06-15 00:35:38 · 727 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第1题 ORDER BY语句
Q1.Evaluate the following SQL statement:SQL>SELECT cust_id, cust_last_name "Last Name"FROM customersWHERE country_id = 10UNIONSELECT cust_id CUST_NO, cust_last_nameFROM customersWHERE country_id = ...转载 2018-06-03 16:41:55 · 1336 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第32题 ORDER BY
Q32. Which statement is true regarding the default behavior of the ORDER BY clause?A. In a character sort, the values are case-sensitive.B. NULL values are not considered at all by the sort operation....转载 2018-06-21 09:41:59 · 627 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第61题 inner join
Q61. Which statement is true about an inner join specified in the WHERE clause of a query?A. It must have primary-key and foreign-key constraints defined on the columns used in the join condition.B. I...转载 2018-06-23 13:30:19 · 1228 阅读 · 0 评论 -
1z0-071 Oracle Database 12c SQL 第55题 索引index
Q55. Which statements are correct regarding indexes? (Choose all that apply.)A. When a table is dropped, the corresponding indexes are automatically dropped.B. For each DML operation performed, the co...转载 2018-06-23 13:01:49 · 668 阅读 · 0 评论