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:

RDBMS Data Definition Language | Create Sales_info table

By Astrio Jather
  Write a query to create Sales_info with constraints mentioned. Refer the below schema  Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

Algorithm Analysis and Design Concepts Data Structure and Algorithms Post-Quiz

By Astrio Jather
Algorithm Analysis and Design Concepts       Data Structure and Algorithms            Post-Quiz  
Post a Comment
Read more

Algorithm Analysis and Design Concepts Analysis of Algorithms Post-Quiz

By Astrio Jather
 Algorithm Analysis and Design Concepts       Analysis of Algorithms            Post-Quiz  
Post a Comment
Read more

RDBMS Data Definition Language | Change the name of the table Sales Info

By Astrio Jather
  RDBMS  Data Definition Language  Change the name of the table Sales Info Write an SQL statement to rename the table Sales Info to Sales_Information. (Hint: use alter command to rename the table name) Evaluation Result: Result Description Summary of tests +------------------------------+ | 1 tests run / 1 test passed | +------------------------------+
Post a Comment
Read more

Mock 3 Slot3 - Quiz - 21st July Quiz Quiz

By Astrio Jather
Mock 3 Slot3        Quiz - 21st July          Important Questions
Post a Comment
Read more

Logic Development | Object Oriented Programming Post Quiz

By Astrio Jather
 Logic Development | Object-Oriented Programming | Post Quiz
Post a Comment
Read more

Programming using Java Hands On - Control Structures | Print Username

By Anonymous
  Print Username Jeffy, who is going to complete the higher education in this year needs to create a simple application which accept the name of a person and welcome them with a message along with their name. She wants to read the data using the class "Scanner". Implement this scenario using Java. Sample Input 1:   Enter the name: Johson Sample Output 1: Welcome Johnson. Sample Input 2:   Enter the name: Stain Polson Sample Output 2: Welcome Stain Polson. Result Description Summary of tests *Note: All the test cases might not have same weightage +------------------------------+ | 2 tests run/ 2 tests passed | +------------------------------+
Post a Comment
Read more

Logic Development | Object Oriented Programming Pre Quiz

By Astrio Jather
 
Post a Comment
Read more

Zig Zag Pattern

By Astrio Jather
  /* @ToDo     Zig Zag Pattern         *               *                *       *       *       *        *               *               *        */ #include   <iostream> using   namespace   std ; int   main (){       #ifndef  ONLINE_JUDGE          freopen ( "../asset/input.txt" , "r" , stdin );          freopen (...
Post a Comment
Read more

Subscribe to Get's Answer by Email