Skip to main content

RDBMS Data Definition Language | Create Buses table

 efer the below schema and create the buses table.

Column Name

Datatype

Size

Constraint

Constraint name

Bus_no

Number

11

Primary key

PK_BUSES

Bus_name

Varchar2

20


 

Type

Varchar2

20


 

Total_seats

Number

11


 

Avail_seats

Number

11


 


efer the below schema and create the buses table.  Column Name  Datatype  Size  Constraint  Constraint name  Bus_no  Number  11  Primary key  PK_BUSES  Bus_name  Varchar2  20      Type  Varchar2  20      Total_seats  Number  11      Avail_seats  Number  11

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

 

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