Skip to main content

RDBMS Data Definition Language | Test Your Understanding 2

Image
By Astrio Jather

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

Must Read:

Course DH ASE B3 Slot3 Mock 1 Handson | RDBMS

By Astrio Jather
DH ASE B3          Slot3              Mock 1                  Handson: RDBMS
Post a Comment
Read more

Software Engineering Concepts Software Engineering Fundamentals Post-Quiz

By Astrio Jather
  Software Engineering Concepts       Software Engineering Fundamentals            Post-Quiz
Post a Comment
Read more

Accenture Mock Quiz | Part 4

By Astrio Jather
  Question  31 Correct Marked out of 1.00 Flag question Question text What will be the output of the following Java code? class Test extends Throwable { } class Base extends Test {} public class Main { public static void main(String args[]) { try { throw new Base(); } catch(Test t) { System.out.println("Test Exception"); } finally { System.out.println("Finally block "); } } } Select one: a.  Complilation error : Bass calss can't extends Test b.  print-"Test Exception" c.  Complilation error: Test Class cant extends Throwable d.  print - "Test Exception" "Finally block "   Feedback The correct answer is: print - "Test Exception" "Finally block " Question  32 Correct Marked out of 1.00 Flag question Question text Which of the following statement(s) is/are TRUE? (i) In a non-correlated(independent) subquery, the subquery is always executed only onc...
Post a Comment
Read more

Subscribe to Get's Answer by Email