Skip to main content

RDBMS Data Definition Language | Test Your Understanding 1

Image
By Astrio Jather

Refer the below schema, and modify the given query appropriately in order to create the product table.

COLUMN NAME

DATATYPE

SIZE

CONSTRAINT

prod_id

number

4

Primary key

prod_name

varchar2

25

 

Prod_expiry_date

date

 

Not null




Refer the below schema, and modify the given query appropriately in order to create the product table. COLUMN NAME DATATYPE SIZE CONSTRAINT prod_id number 4 Primary key prod_name varchar2 25 Prod_expiry_date date 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