- 博客(77)
- 资源 (7)
- 收藏
- 关注
RSS订阅原创 目前申请Oracle 11g认证需要考哪些课程？
要认证Oracle，当然需要在Oracle官方去找答案：1、有哪些认证级别Oracle Database 11g Certification现在是2018年6月23日，由上图可以看到Oracle的认证级别分为Associate：Oracle Database 11g Administrator Certified Associate，即：Oracle数据库11g认证专员，简称OCAProfessi...
2018-06-26 15:12:52
3631
1
转载 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
转载 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
866
转载 1z0-071 Oracle Database 12c SQL 第71题 data dictionary
Q71. Which statements are true? (Choose all that apply.)A. The data dictionary is created and maintained by the database administrator.B. The data dictionary views consists of joins of dictionary base...
2018-06-24 11:16:07
1479
转载 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
转载 1z0-071 Oracle Database 12c SQL 第69题 数据字典user_constraints
Q69. Evaluate the following SELECT statement and view the Exhibit to examine its output:SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status FROM user_cons...
2018-06-24 11:15:54
1209
转载 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
转载 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
转载 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
转载 1z0-071 Oracle Database 12c SQL 第65题 the steps for a correlated subquery
Q65. The following are the steps for a correlated subquery, listed in random order:1. The WHERE clause of the outer query is evaluated.2. The candidate row is fetched from the table specified in the o...
2018-06-24 11:15:27
1106
转载 1z0-071 Oracle Database 12c SQL 第64题 DROP
Q64. The first DROP operation is performed on PRODUCTS table using the following command:DROP TABLE products PURGE;Then you performed the FLASHBACK operation by using the following command:FLASHBACK T...
2018-06-24 11:15:19
684
转载 1z0-071 Oracle Database 12c SQL 第63题 FETCH FIRST n PERCENT ROWS ONLY
Q63. Examine the following query:SQL> SELECT prod_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY;What is the output of this query?A. It displays 5 percent of the produ...
2018-06-23 13:37:58
1855
转载 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
610
转载 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
转载 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
转载 1z0-071 Oracle Database 12c SQL 第59题 transactions
Q59. Which statement is true about transactions?A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.B. Each Data Definitio...
2018-06-23 13:20:04
1602
转载 1z0-071 Oracle Database 12c SQL 第58题 subqueries
Q58. View the exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement?A. listing of customers who do not have a ...
2018-06-23 13:17:48
566
转载 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
转载 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 第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
转载 1z0-071 Oracle Database 12c SQL 第54题 多条件插入
Q54. View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts...
2018-06-23 12:56:24
688
2
转载 1z0-071 Oracle Database 12c SQL 第52题 RIGHT OUTER JOIN
1z0-071 Oracle Database 12c SQL 第52题
2018-06-22 23:57:42
730
转载 1z0-071 Oracle Database 12c SQL 第51题 JOIN
Q51. View the Exhibit for the structure of the STUDENT and FACULTY tables.You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine t...
2018-06-22 23:54:36
1100
转载 1z0-071 Oracle Database 12c SQL 第50题 SQL statements
Q50. Which two tasks can be performed by using Oracle SQL statements?A. changing the password for an existing database userB. connecting to a database instanceC. querying data from tables across datab...
2018-06-22 23:14:19
1689
转载 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
转载 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
817
转载 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
转载 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
转载 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 第43题 NULL、NVL、COUNT
Q43. View the Exhibit and examine the description of the PRODUCT_INFORMATION table.Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?A. SELECT COUNT(li...
2018-06-22 16:50:26
713
转载 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
1293
转载 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
718
2
转载 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
转载 1z0-071 Oracle Database 12c SQL 第38题 MERGE statement
Q38. View the exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.ORDERS_MASTERORDER_TOTALORDER_ID1 10002 20003 30004MONTHLY_ORDERSORDER_TOTALORDER_ID2 25003Evaluate the following ...
2018-06-21 09:42:35
976
转载 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
468
转载 1z0-071 Oracle Database 12c SQL 第36题 AS别名
Q37. Examine the structure of the BOOKS_TRANSACTIONS table:Name Null? Type-————— —————– —————————TRANSACTION_ID NOT NULL VARCHAR2 (6)BORROWED_DATE VARCHAR2 (50)DUE_DATE DATEBOOK_ID DATEMEMBER_ID VARCH...
2018-06-21 09:42:23
907
转载 1z0-071 Oracle Database 12c SQL 第35题 DML
Q35. Which task can be performed by using a single Data Manipulation Language (DML) statement?A. adding a column constraint when inserting a row into a tableB. adding a column with a default value whe...
2018-06-21 09:42:16
3030
2
转载 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
534
转载 1z0-071 Oracle Database 12c SQL 第33题 IN
Q33. Examine the structure of the MEMBERS table.Name Null? Type-————— —————– —————————MEMBER_ID NOT NULL VARCHAR2 (6)FIRST_NAME VARCHAR2 (50)LAST_NAME NOT NULL VARCHAR2 (50)ADDRESS VARCHAR2 (50)CITY V...
2018-06-21 09:42:05
675
Database PSU 11.2.0.4.200414 Patch 30670774 for UNIX
2020-07-16
GI PSU 11.2.0.4.200414 Patch 30805461 for UNIX
2020-07-16
GridControl_11.1.0.1.0_Linux_x86-64.txt
2020-07-16
GridControl_11.1.0.1.0_Linux.txt
2020-07-16
根据系统类型、DB版本和OS内存自动计算Oralce建议的memory_target、SGA和PGA大小
2018-06-14
Oracle Database 12c SQL v6.0 (1z0-071)
2018-06-03
BareTailProfessional（已注册）
2017-01-21
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人