READ Free Dumps For Oracle- 1z0-001

Question ID 1546	You need to store currency data and you know that the data will always have two digits to the right of the decimal point. However, the number of digits to the left of the decimal place will vary greatly. Which datatype would be most appropriate to store this data?
Option A	A.    LONG
Option B	B.    NUMBER
Option C	C.    LONG RAW
Option D	D.    NUMBER(p)
Correct Answer	B

Explanation

Question ID 1547	Examine the structure of the STUDENT table: Name Null? Type                  STUD_ID NOT NULL NUMBER(3) NAME VARCHAR2(25) ADDRESS VARCHAR2(50) GRADUATION DATE Currently, the table is empty. You have decided that NULL values should not be allowed for NAME column. Which statement restricts NULL values from being entered into the column?
Option A	A.    ALTER TABLE student ADD CONSTRAINT name(NOT NULL);
Option B	B.    ALTER TABLE student ADD CONSTRAINT NOT NULL(name);
Option C	C.    ALTER TABLE student MODIFY (name varchar2(25) NOT NULL);
Option D	D.    ALTER TABLE student MODIFY CONSTRAINT name(NOT NULL);
Correct Answer	C

Explanation

Previous-Page 1 2. . . 31 32 33 34 35 36 37. . . 152 153 Next-Page

Send email to admin@getfreedumps for new dumps request!!!