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  |
+------------------------------+
 

Comments

Must Read:

RDBMS Data Definition Language | Create Sales_info table

  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 | +------------------------------+

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

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

Algorithm Analysis and Design Concepts Analysis of Algorithms Post-Quiz

 Algorithm Analysis and Design Concepts       Analysis of Algorithms            Post-Quiz  

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

  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 | +------------------------------+

Mock 3 Slot3 - Quiz - 21st July Quiz Quiz

Mock 3 Slot3        Quiz - 21st July          Important Questions

Logic Development | Object Oriented Programming Post Quiz

 Logic Development | Object-Oriented Programming | Post Quiz

Java Flow Control And Functions If Else | Day 1

Problem: In computer programming, we use the if statement to control the flow of the program. For example, if a certain condition is met, then run a specific block of code. Otherwise, run another code. For example: class Main { public static void main(String[] args) { int number = 0; // checks if number is greater than 0 if (number > 0) { System.out.println("The number is positive."); } // checks if number is less than 0 else if (number < 0) { System.out.println("The number is negative."); } // if both condition is false else { System.out.println("The number is 0."); } } } Output The number is 0. In the above example, we are checking whether the  number is positive, negative, or zero . Here, we have two condition expressions: number > 0  - checks if the number is greater than 0 number < 0  - checks if the number is less than 0 Here, the value of the  number is 0 . So both th...

Programming using Java Hands On - Control Structures | Print Username

  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 | +------------------------------+

Logic Development | Object Oriented Programming Pre Quiz

 

Subscribe to Get's Answer by Email