Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me with 21 and 22 and 23 21. You need to display the date 11-oct-2019 in words as Eleventh of October, Two Thousand
Please help me with 21 and 22 and 23
21. You need to display the date 11-oct-2019 in words as "Eleventh of October, Two Thousand and Nineteen". Which statement would give the required results? 1. SELECT TO CHAR('11-oct-2019', 'fmDdspth "of" Month, Year') FROM DUAL; 2. SELECT TO CHAR(to_date '2019-10-11','fmDdspth "of" Month, Year') FROM DUAL; 3. SELECT TO CHAR(TO_CHAR(2019-12-19), 'fmDdspth "of" Month, Year') FROM DUAL; 4. SELECT TO_CHAR(to_date ('11-oct-2019'), 'fmDdspth "of" Month, Year') FROM DUAL; You issued the following command: DROP TABLE customers; Which statement is true? 1. The customers table can be recovered using the rollback command. 2. All indexes and constraints defined on the table being dropped are also dropped 3. Sequences used in the customers table become invalid. 4. The space used by the customers table is reclaimed immediately CREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYCLE: CREATE TABLE ord_items (ord_no NUMBER (4) DEFAULT ord_seq. NEXTVAL NOT NULL, Item_no NUMBER(3), qty NUMBER(3) CHECK (aty BETWEEN 100 AND 200). expiry_date date CHECK (expiry date > SYSDATE). CONSTRAINT it-pk PRIMARY KEY (ord_no, item_no), CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord no): INF3707 The command to create a table fails. Identify the two reasons for SQL statement failure? 1. You cannot use the BETWEEN clause in the condition of a CHECK constraint 2. You cannot use ord_no and item_no coumns as a composite primary key because ord_no is also a foreign key 3. You cannot use the NEXTVAL sequence value as a DEFAULT value for a column 4. All of the aboveStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started