![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle Certficate&Exam
zbdba
live in oracle
展开
-
阿里dba面试题
注:以下题目,可根据自己情况挑选题目作答,不必全部作答.您也可以就相关问题直接找负责面试人员面述而不笔答 一. SQL tuning 类 1:列举几种表连接方式 hash join/merge join/nest loop(cluster join)/index join 2:不借助第三方工具,怎样查看sql的执行计划 set aut转载 2013-10-24 09:11:25 · 1835 阅读 · 0 评论 -
ocp 1Z0-051 1-22题解析
1. View the Exhibit andexamine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMEStables.The PROD_ID column isthe foreign key in the SALES table, which references the PRODUCTS table.Simil原创 2013-12-01 08:56:33 · 8746 阅读 · 0 评论 -
ocp 1Z0-051 23-70题解析
23. Examine thestructure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULLNUMBER(6)CUST_NAME NOT NULLVARCHAR2(20)CUST_STATUS NOT NULLCHARTRANS_DATE NOT NULL DATETRANS_VAL原创 2013-12-02 12:40:13 · 5206 阅读 · 9 评论 -
ocp 1Z0-051 71-105题解析
71. Which arithmeticoperations can be performed on a column by using a SQL function that is builtintoOracle database ?(Choose three .)A. a dditionB. s ubtractionC. r aising to a powerD. f in原创 2013-12-03 13:32:33 · 5918 阅读 · 0 评论 -
ocp 1Z0-051 141-175题解析
141. View the Exhibitand examine the structure of CUSTOMERS and GRADES tables.You need to displaynames and grades of customers who have the highest credit limit.Which two SQL statementswould accom原创 2013-12-11 08:49:12 · 7560 阅读 · 0 评论 -
ocp 1Z0-051 106-140题解析
106. Examine the data inthe LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:LIST_PRICE MIN_PRICE10000 80002000030000 30000Which two expressionsgive the same output? (Choose two.)A.原创 2013-12-10 08:06:54 · 7174 阅读 · 0 评论