create_oracle的专栏

QUESTION 2View the Exhibit to examine the description for the SALES table.Which views can have all DML operations performed on it? (Choose all that apply.)

QUESTION 25Resume (character large object [CLOB] data type), which contains the resume submitted by theemployeeWhich is the correct syntax to create this table?A. CREATE TABLE EMP_1(emp_id N

QUESTION 8View 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? (Choose two.)

QUESTION 16Evaluate the following query:SQL> SELECT promo_name q'{'s start date was }' promo_begin_dateAS "Promotion Launches"FROM promotions;What would be the outcome of the above query?A

QUESTION 17View the E xhibit 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:

QUESTION 22You need to create a table for a banking application. One of the columns in the table has the followingrequirements:1) You want a column in the table to store the duration of the cred

QUESTION 26Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$# (emp_no NUMBER (4));B. CREATE TABLE 9emp$# (emp_no NUMBER(4));C. CREATE TABLE emp*123 (emp_no NUMBER(4));D. CREATE

QUESTION 27Which 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 cann

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 is en

QUESTION 29Which 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

33. You want  to create an ORD_DETAIL table  to store details  for an order placed having  the  following business requirement:

36. Examine the following SQL commands:  SQL>CREATE TABLE products ( prod_id NUMBER(3) CONSTRAINT p_ck CHECK (prod_id > 0), prod_name CHAR(30), prod_qty NUMBER(6), CONSTRAINT p_name NOT NULL

32. 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_de

31. Evaluate the following SQL commands: SQL>CREATE SEQUENCE ord_seq     INCREMENT BY 10     START WITH 120     MAXVALUE 9999     NOCYCLE; SQL>CREATE TABLE ord_items        (ord_no NUMBE

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

QUESTION 30Evaluate 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

34. You created an ORDERS table with the following description: name                Null            Type ORD_ID              NOT NULL        NUMBER(2) CUST_ID             NOT NULL        NUMBER(

QUESTION 24Examine the structure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(6)CUST_NAME NOT NULL VARCHAR2(20)CUST_STATUS NOT NULL VARCHAR2TRANS_DATE NOT NUL

QUESTION 23Examine the structure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(6)CUST_NAME NOT NULL VARCHAR2(20)CUST_STATUS NOT NULL CHARTRANS_DATE NOT NULL DA

QUESTION 21Examine the description of the EMP_DETAILS table given below:name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME NOT NULL VARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regar

QUESTION 1View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMEStables.The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS ta

QUESTION 5Which 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;

QUESTION 4Which two statements are true regarding single row functions? (Choose two.)A. They a ccept only a single argument.B. They c an be nested only to two levels.C. Arguments can only be c

QUESTION 3You need to extract details of those products in the SALES table where the PROD_ID column containsthe string '_D123'.Which WHERE clause could be used in the SELECT statement to get the

QUESTION 6Examine the structure of the SHIPMENTS table:name Null TypePO_ID NOT NULL NUMBER(3)PO_DATE NOT NULL DATESHIPMENT_DATE NOT NULL DATESHIPMENT_MODE VARCHAR2(30)SHIPMENT_COST NUMBE

QUESTION 9Which statement is true regarding the INTERSECT operator?A. It ignores NULL values.B. Reversing the order of the intersected tables alters the result.C. The names of columns in all S

QUESTION 12You need to produce a report where each customer's credit limit has been incremented by $1000. In theoutput, t he customer's last name should have the heading Name and the incremented c

1Z0-051 QUESTION 1 利用CREATE　TABLE　AS创建表

QUESTION 10View the Exhibit; e xamine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days .Your manager has asked you to generate a report, which provides

QUESTION 11View the Exhibit and examine the structure of the PRODUCTS table.All products have a list price.You issue the following command to display the total price of each product after a disc

QUESTION 13View 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'

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amountin each income level. The report should NOT show any repeated credit amounts in each income level.Which

QUESTION 15View the Exhibit and examine the data in the CUSTOMERS table.Evaluate the following query:SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAXLOWER

QUESTION 18Examine the structure of the PROMOTIONS table:name Null TypePROMO_ID NOT NULL NUMBER(6)PROMO_NAME NOT NULL VARCHAR2(30)PROMO_CATEGORY NOT NULL VARCHAR2(30)PROMO_COST NOT NULL

QUESTION 19Evaluate 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 abov

QUESTION 20Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)A. Only one LONG column can be used per table.B. A TIMESTAMP data type column store

37. 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 stru