OCP-1Z0-051
文章平均质量分 70
hello_holly
每天前进一小步
展开
-
OCP-1Z0-051 第2题 视图的WITH CHECK OPTION选项
View the Exhibit to examine the description for the SALES table.Which views can have all DML operations performed on it? (Choose all that apply.) A. CREATE VIEW v3AS SELECT * FROM SALESWHERE原创 2014-04-14 13:58:26 · 9528 阅读 · 2 评论 -
OCP-1Z0-051 第3题 转义字符
You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.Which WHERE clause could be used in the SELECT statement to get the required out原创 2014-04-14 13:59:20 · 7057 阅读 · 0 评论 -
OCP-1Z0-051 第6题 case when和decode的用法
一、原题Examine the structure of the SHIPMENTS table:name Null TypePO_ID NOT NULL NUMBER(3)PO_DATE NOT NULL DATESHIPMENT_DATE N原创 2014-04-14 14:02:51 · 7122 阅读 · 0 评论 -
OCP-1Z0-051 第13题 q操作符
View the Exhibit and examine the structure of the PRODUCTS table.You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box's category is原创 2014-04-14 14:04:15 · 6016 阅读 · 0 评论 -
OCP-1Z0-051 第19题 INTERVAL用法
一、原题Evaluate the following query:SELECT INTERVAL '300' MONTH,INTERVAL '54-2' YEAR TO MONTH,INTERVAL '11:12:10.1234567' HOUR TO SECONDFROM dual;What is the correct output of the above query原创 2014-04-14 14:07:06 · 5782 阅读 · 0 评论 -
OCP-1Z0-051 第1题 CTAS语句建表注意事项
原题: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 table, which references the PRODUCTS table.原创 2014-04-14 14:10:24 · 15505 阅读 · 5 评论 -
OCP-1Z0-051 第4题 单行函数
Which two statements are true regarding single row functions? (Choose two.)A. They accept only a single argument.B. They can be nested only to two levels.C. Arguments can only be column values o原创 2014-04-14 14:10:43 · 10787 阅读 · 3 评论 -
OCP-1Z0-051 第17题 null参与运算后仍是null
一、原题View the Exhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to date.You issue the following query:SQL>原创 2014-04-14 14:05:07 · 5185 阅读 · 0 评论 -
OCP-1Z0-051 第5题 to_char的数字的格式
Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three)A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;C. SELECT TO_CH原创 2014-04-14 13:59:58 · 7572 阅读 · 1 评论 -
OCP-1Z0-051 第29题 约束
一、原题Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. The column with a UNIQUE constraint can store NULLS .C. A constraint is enf原创 2014-04-30 17:13:17 · 4219 阅读 · 0 评论 -
OCP-1Z0-051 第27题 oracle对象命名规则
一、原题Which two statements are true regarding tables? (Choose two.)A. A table name can be of any length.B. A table can have any number of columns.C. A column that has a DEFAULT value cannot stor原创 2014-04-30 16:55:11 · 4920 阅读 · 1 评论 -
OCP-1Z0-051 第28题 oracle约束规则
一、原题Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. A column with the UNIQUE constraint can contain NULL values.C. A constraint原创 2014-04-30 17:10:33 · 5104 阅读 · 2 评论 -
OCP-1Z0-051 第30题 主外键约束,check约束
一、原题Evaluate the following CREATE TABLE commands:CREATE TABLE orders(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_date DATE,cust_id NUMBER(4));>,CREATE TABLE ord_items(ord_no NUMBE原创 2014-04-30 17:18:13 · 4674 阅读 · 0 评论 -
OCP-1Z0-051 第31题 约束规则
一、原题Evaluate the following SQL commands:SQL>CREATE SEQUENCE ord_seqINCREMENT BY 10START WITH 120MAXVALUE 9999NOCYCLE;SQL> CREATE TABLE ord_items(ord_no NUMBER(4) DEFAULT ord_seq.NEXTVA原创 2014-04-30 17:27:34 · 4508 阅读 · 1 评论 -
OCP-1Z0-051 第33题 create table 建表语句
一、原题You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement:1) The order ID will be unique and cannot have null values.2) The order原创 2014-05-04 15:38:39 · 4907 阅读 · 0 评论 -
OCP-1Z0-051 第34题 先建表,再用alter加主键
一、原题You created an ORDERS table with the following description:name Null TypeORD_ID NOT NULL NUMBER(2)CUST_ID NOT NULL NUMBER(3)O原创 2014-05-04 15:44:17 · 4228 阅读 · 0 评论 -
OCP-1Z0-051 第35题 主外键规则
一、原题Which two statements are true regarding constraints? (Choose two.)A. A table can have only one primary key and one foreign key.B. A table can have only one primary key but multiple foreign k原创 2014-05-04 15:52:21 · 4112 阅读 · 0 评论 -
OCP-1Z0-051 第32题 create table 建表语句
一、原题Which CREATE TABLE statement is valid?A. CREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY,item_no NUMBER(3) PRIMARY KEY,ord_date DATE NOT NULL);B. CREATE TABLE ord_details(ord_n原创 2014-05-04 15:37:44 · 5413 阅读 · 0 评论 -
OCP-1Z0-051 第49题 SYNONYM同义词
一、原题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following原创 2014-05-06 20:59:51 · 4133 阅读 · 0 评论 -
OCP-1Z0-051 第51题 SYNONYM同义词
一、原题Which statement is true regarding synonyms?A. Synonyms can be created only for a table.B. Synonyms are used to reference only those tables that are owned by another user.C. A public synony原创 2014-05-06 21:51:42 · 4626 阅读 · 0 评论 -
OCP-1Z0-051 第52题 列别名
一、原题View the Exhibit and examine the structure of the PRODUCTS table.Using the PRODUCTS table, you issue the following query to generate the names, current list price,and discounted list price for原创 2014-05-06 22:11:15 · 4764 阅读 · 0 评论 -
OCP-1Z0-051 第56题 日期时间段
一、原题View the Exhibit and examine the structure of the PROMOTIONS table.Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet' that ended原创 2014-05-06 23:10:15 · 3807 阅读 · 0 评论 -
OCP-1Z0-051 第57题 别名和null值判断
一、原题The CUSTOMERS table has the following structure:name Null TypeCUST_ID NOT NULL NUMBERCUST_FIRST_NAME NOT NULL VARCHAR原创 2014-05-06 23:38:49 · 4464 阅读 · 0 评论 -
OCP-1Z0-051 第47题 索引
一、原题View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are composite PRIMARY KEY in the ORD原创 2014-05-06 17:17:05 · 4368 阅读 · 0 评论 -
OCP-1Z0-051 第60题
一、原题View the Exhibit and examine the structure of CUSTOMERS table.Evaluate the following query:SQL>SELECT cust_id, cust_cityFROM customersWHERE cust_first_name NOT LIKE 'A_%g_%' ANDcust_cr原创 2014-05-07 09:07:13 · 4050 阅读 · 0 评论 -
OCP-1Z0-051 第46题 约束和索引
一、原题Which statements are correct regarding indexes? (Choose all that apply.)A. When a table is dropped, the corresponding indexes are automatically dropped.B. A FOREIGN KEY constraint on a colum原创 2014-05-06 15:29:14 · 4684 阅读 · 0 评论 -
OCP-1Z0-051 第40题 视图的注意事项
一、原题View the Exhibit to examine the description for the SALES and PRODUCTS tables.You want to create a SALE_PROD view by executing the following SQL statement:CREATE VIEW sale_prodAS SELECT p.原创 2014-05-05 23:33:52 · 4270 阅读 · 0 评论 -
OCP-1Z0-051 第41题 视图的注意事项
一、原题Which two statements are true regarding views? (Choose two.)A. A subquery that defines a view cannot include the GROUP BY clause.B. A view that is created with the subquery having the DISTIN原创 2014-05-06 00:00:48 · 4828 阅读 · 0 评论 -
OCP-1Z0-051 第37题 drop table
一、原题You issued the following command to drop the PRODUCTS table:SQL> DROP TABLE products;What is the implication of this command? (Choose all that apply.)A. All data along with the table struc原创 2014-05-05 22:48:17 · 5189 阅读 · 0 评论 -
OCP-1Z0-051 第59题 null值判断
一、原题View the Exhibit and examine the data in the PRODUCTS table.You need to display product names from the PRODUCTS table that belong to the 'Software/Other ' category with minimum prices as eithe原创 2014-05-07 08:33:16 · 5465 阅读 · 1 评论 -
OCP-1Z0-051 第45题 SEQUENCE(序列)的注意事项
一、原题Which two statements are true about sequences created in a single instance database? (Choose two.)A. The numbers generated by a sequence can be used only for one table.B. DELETE would remov原创 2014-05-06 15:26:07 · 5282 阅读 · 0 评论 -
OCP-1Z0-051 第61题 where通配符
一、原题View the Exhibit and examine the structure of the PROMOTIONS table.You need to generate a report of all promos from the PROMOTIONS table based on the following conditions:1. The promo name s原创 2014-05-07 10:05:59 · 4561 阅读 · 1 评论 -
OCP-1Z0-051 第44题 SEQUENCE的缺省值
一、原题View the Exhibit and examine the structure of the ORD table.Evaluate the following SQL statements that are executed in a user session in the specified order:CREATE SEQUENCE ord_seq;SELECT原创 2014-05-06 14:25:46 · 4485 阅读 · 0 评论 -
OCP-1Z0-051 第7题 ON和USING子句的用法与区别
Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)A. Both USING and ON clauses can be used for equijoins and nonequijoins.B. A maximum of one pair of co原创 2014-04-19 22:27:48 · 9350 阅读 · 0 评论 -
OCP-1Z0-051 第54题
一、原题View the Exhibit and examine the structure of the CUSTOMERS table.Evaluate the query statement:SQL> SELECT cust_last_name, cust_city, cust_credit_limitFROM customersWHERE cust_last_name原创 2014-05-06 22:34:52 · 3911 阅读 · 0 评论 -
OCP-1Z0-051 第58题 转义字符escape
一、原题The PART_CODE column in the SPARES table contains the following list of values:PART_CODEA%_WQ123A%BWQ123AB_WQ123Evaluate the following query:SQL> SELECT part_codeFROM sparesWHERE原创 2014-05-07 08:18:26 · 4280 阅读 · 0 评论 -
OCP-1Z0-051 第38题 视图注意事项
一、原题Which two statements are true regarding views? (Choose two.)A. A simple view in which column aliases have been used cannot be updated.B. Rows cannot be deleted through a view if the view def原创 2014-05-05 23:19:59 · 5633 阅读 · 1 评论 -
OCP-1Z0-051 第43题 序列的cycle选项
一、原题Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXVALUE 200CYCLENOCACHE;The SEQ1 sequence has generated numbers up to the maximum原创 2014-05-06 14:03:33 · 4654 阅读 · 0 评论 -
OCP-1Z0-051 第50题 DROP SYNONYM
一、原题SLS is a private synonym for the SH.SALES table.The user SH issues the following command:DROP SYNONYM sls;Which statement is true regarding the above SQL statement?A. Only the synonym wo原创 2014-05-06 21:39:36 · 5172 阅读 · 0 评论 -
OCP-1Z0-051 第42题 视图的注意事项
一、原题Which three statements are true regarding views? (Choose three.)A. Views can be created only from tables.B. Views can be created from tables or other views.C. Only simple views can use ind原创 2014-05-06 13:17:10 · 4101 阅读 · 0 评论