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

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:

Software Engineering Concepts Configuration Management And Version Control Post-Quiz

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

Software Engineering Concepts Introduction to Agile Technologies Introduction to Agile Technologies | Quiz 2

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

RDBMS Data Definition Language | Alter - Add CHECK constraint to Mobile_Master

RDBMS Data Definition Language Alter - Add CHECK constraint to Mobile_Master Refer the following schema and add a constraint CHK_WARRANTY in Mobile_Master table to ensure that the warranty in years is greater than zero. Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+

Star Pattern

/* @ToDo Star Pattern * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ...

UNIX Introduction to Unix | Post-Quiz

UNIX Introduction to Unix Post-Quiz Feedback Congratulations! You have passed by securing more that 80%. Question 1 Correct Mark 1.00 out of 1.00 Flag question Question text What is the default maximum number of processes that can exist in Unix? Select one: a. unlimited b. 32768 c. 4096 d. 1024 Feedback Your answer is correct. The correct answer is: 32768 Question 2 Correct Mark 1.00 out of 1.00 Flag question Question text Single user mode shell has _____ prompt. Select one: a. $ Normal user b. % Admin user c. ~ Home user d. # Root user Feedback Your answer is correct. The correct answer is: # Root user Question 3 Correct Mark 1.00 out of 1.00 Flag question Question text Predict the output for the following...

Min Cost In Maze Traversal

1. You are given a number n, representing the number of rows. 2. You are given a number m, representing the number of columns. 3. You are given n*m numbers, representing elements of 2d array a, which represents a maze. 4. You are standing in top-left cell and are required to move to bottom-right cell. 5. You are allowed to move 1 cell right (h move) or 1 cell down (v move) in 1 motion. 6. Each cell has a value that will have to be paid to enter that cell (even for the top-left and bottom- right cell). 7. You are required to traverse through the matrix and print the cost of path which is least costly. Input Format A number n A number m e11 e12.. e21 e22.. .. n * m number of elements Output Format The cost of least costly path. Constraints 1 <= n <= 10^2 1 <= m <= 10^2 0 <= e1, e2, .. n * m elements <= 1000 Sample Input 6 6 0 1 4 2 8 2 4 3 6 5 0 4 1 2 4 1 4 6 2 0 7 3 2 2 3 1 5 9 2 4 2 7 0 8 5 1 Sample Output 23 Solution: import java.io.*; import...

Get's Answer

Search This Blog