Skip to main content

RDBMS Data Definition Language | Test Your Understanding 2

Test Your Understanding 2

Modify the given query appropriately in order to create the department table using the schema given below, considering the product table that you have already created.

COLUMN NAME

DATATYPE

SIZE

CONSTRAINT

dept_id

number

4

Primary key

prod_id

number

4

Foreign key

dept_name

varchar2

25

Unique

dept_head

varchar2

25

Not null



Accentur Ple Learning module answers getasnwer.blogspot.com Test Your Understanding 2 Modify the given query appropriately in order to create the department table using the schema given below, considering the product table that you have already created. COLUMN NAME DATATYPE SIZE CONSTRAINT dept_id number 4 Primary key prod_id number 4 Foreign key dept_name varchar2 25 Unique dept_head varchar2 25 Not null Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+


Evaluation Result:


 
Result Description
 Summary of tests
+------------------------------+
| 3 tests run / 3 test passed  |
+------------------------------+
Labels:

Comments

Post a Comment

Popular posts from this blog

NTA Declares JEE (Main)-2021 (February Session) NTA Scores for Paper 1 (B.E./B.Tech.) | JEE Mains 2021

The JEE (Main) Examination for B.E./B.Tech. was conducted by NTA from 24 to 26 February 2021. A total number of 6.52 lacs candidates were registered for Paper 1 (B.E. /B. Tech.) in this examination.  The Examination was conducted in 331 Cities [including 9 cities outside India in Colombo, Doha, Dubai, Kathmandu, Muscat, Riyadh, Sharjah, Singapore, and Kuwait] in 828 Centres.  A total number of 742 Observers, 261 City-Coordinators, 19 Regional Coordinators, 06 Special Coordinators & 02 National Coordinators were deployed at these centres to oversee the smooth and fair conduct of the examination.  The examination for Paper 1 (B.E. /B. Tech.) was conducted in a total of 6 shifts from 24 to 26 February 2021. The scores of Paper 1 (B.E./B.Tech.) are being declared today.   The Examination was conducted for the first time in 13 languages (English, Hindi, Gujarati along with Assamese, Bengali, Kannada, Malayalam, Marathi, Odia, Punjabi, Tamil, Telugu, and Urdu).  T...
Post a Comment
Read more

Display of Provisional Answer Keys and Question Paper with Recorded Responses for Answer Key Challenge | JEE (Main) 2021 Session 4 for Paper 1 (B.E./B.Tech.)

The JEE (Main) - 2021 Session - 4 was conducted throughout the country and abroad on 26, 27, 31 August and 1 September 2021 for Paper 1 (B.E./B.Tech.) in the Computer Based Test (CBT) mode. The National Testing Agency has uploaded the Provisional Answer Keys for Paper 1 (B.E./B.Tech.) along with the Question Paper with Recorded Responses on the website https://jeemain.nta.nic.in for candidates to challenge. The procedure (as enclosed) for the challenge of Answer Key may be used. The candidates, who are not satisfied with the answer key, may challenge the same by paying a fee of ₹ 200/- (Rupees Two Hundred only) per question challenged as a non-refundable processing fee. This facility is available from 06 September 2021 to 08 September 2021 (up to 10:00 A.M.). The payment of the processing fee may be made through, Debit card/Credit Card/Net Banking/Paytm upto 08 September 2021 (upto 11:00 A.M.). No challenge will be entertained without receipt of the processing fee. The Challenges will ...
Post a Comment
Read more

CSAB Special round for NITs, IIITs and CFTIS 2018

CSAB Special round for NITs, IIITs and CFTIS 2 018 After the  seat allotment of JoSAA 2018  is completed, CSAB will conduct a special round of counselling for NITs, IIITs and CFTIs through CSAB. The allotment will be open only for those candidates who have successfully completed their  JEE Main 2018   examination and secured valid scores. Exclusive:   JoSAA Counselling 2021, Documents Required... CSAB 2018 Special Round 1 Seat Allotment Result CSAB 2018 Special Round 1 Opening and Closing Rank Important Dates of CSAB Special round for NITs, IIITs and CFTIS 2018 S.No Events Important Dates (Tentative) 1 Registration and Choice Filling Fourth week of July 2018 2 Announcement of Seat Allotment Fourth week of July 2018 3 Reporting to Allotted Institutes First week of August 2018 click here to get full schedule... Eligibility Criteria of CSAB Special round ...
10 comments
Read more