Answered step by step
Verified Expert Solution
Link Copied!

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 23image text in transcribedimage text in transcribed

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 above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students also viewed these Databases questions

Question

Consider this article:...

Answered: 1 week ago

Question

=+ Are unions company-wide, regional, or national?

Answered: 1 week ago

Question

=+j Explain the litigation risks in international labor relations.

Answered: 1 week ago