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:

Data Formats ( XML & JSON ) XML AND JSON | Generate XSD for Persons

Generate XSD for Persons Generate XSD for the following XML. XYZ organization wants to store the details of persons in an xml file. The following scenario helps in designing the XML document. Here PersonList is the root tag. PersonList contains the entry of each person with adhaarno, name, age and address. <?xml version="1.0" encoding="UTF-8"?> <PersonList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PersonList.xsd"> <Person> <adhaarno>414356782345</adhaarno> <name> <firstname>Zeenath</firstname> </name> <age>28</age> <address> <doorno...

Programming using Java Running case study - Requirement 1 / 6 | State Board of Cricket Council –V1.0 *

State Board of Cricket Council –V1.0 * State Board of Cricket Council State Board of Cricket Council (SBCC) is one of the leading cricket selection academies in the state . They are in need of an automated system that should manipulate the player details provided and also find the players who have secured star rating between a specific range from the database. You being their software consultant have been approached to develop a pilot java application which can be used by the admin for the above mentioned requirement . UserInterface.java package com.sbcc.main; import com.sbcc.model.*; import java.util.*; import java.lang.*; import com.sbcc.skeletonvalidator.SkeletonValidator; public class UserInterface { public static Player pl ; public static void main ( String [] args ) { ...

Data Formats ( XML & JSON ) XML AND JSON | Generate XSD for Students

Generate XSD for Students Generate XSD for the following XML. XYZ School wants to store the details of students in an xml file. The following scenario helps in designing the XML document. Here StudentList is the root tag. StudentList contains the entry of each student with rollno, name, age, address and department. <?xml version="1.0" encoding="UTF-8"?> <StudentList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="StudentList.xsd"> <Student rollno="2017CSE0055"> <name> <firstname>Savitha</firstname> </name> <age>20</age> <address> <doorno>35</doorno> ...

DFA Solutions

Question 1 Correct Mark 1.00 out of 1.00 Flag question Question text To secure the http messages in the API calls, its necessary to: Select one: a. All the above b. Use cryptography c. implement identity management d. avoid hardcoding any sensitive data in the messages Feedback The correct answer is: All the above Question 2 Correct Mark 1.00 out of 1.00 Remove flag Question text A team has completed 10 Sprints and moving to the 11th Sprint. Till Sprint 10, the team has achieved an average of 50 story points per sprint. The same is projected as their velocity for the upcoming sprints with the Client. What is this approach called? Select one: a. Velocity Driven Sprint Planning b. Velocity Driven Commitment c. Commitment Driven Velocity d. Commitment Driven Sprint Planning Feedback The correct answer is: Velocity Driven Sprint Planning Question 3 Incorrect Mark 0.00 out of 1.00 Remove flag Question text Jack is grooming himself to be a potential Product Owner. Kno...

Programming using Java Hands On - Control Structures | Celcius to Farenheit Conversion

Celcius to Farenheit Conversion Write a program to convert Celsius to Farenheit. Display the result correct to 1 decimal. Create a class "CelsiusConversion.java" and write the main method. Hint : 5 * (F – 32) = 9 * C, F-Farenheit , C- Celsius Sample Input 1 : 80 Sample Output 1 : 176.0 Sample Input 2 : 88 Sample Output 2 : 190.4 Result Description Summary of tests *Note: All the test cases might not have same weightage +------------------------------+ | 7 tests run/ 7 tests passed | +------------------------------+

Unbounded Knapsack

1. You are given a number n, representing the count of items. 2. You are given n numbers, representing the values of n items. 3. You are given n numbers, representing the weights of n items. 3. You are given a number "cap", which is the capacity of a bag you've. 4. You are required to calculate and print the maximum value that can be created in the bag without overflowing it's capacity. Note: Each item can be taken any number of times. You are allowed to put the same item again and again. Input Format A number n v1 v2 .. n number of elements w1 w2 .. n number of elements A number cap Output Format A number representing the maximum value that can be created in the bag without overflowing it's capacity Constraints 1 <= n <= 20 0 <= v1, v2, .. n elements <= 50 0 < w1, w2, .. n elements <= 10 0 < cap <= 10 Sample Input 5 15 14 10 45 30 2 5 1 3 4 7 Sample Output 100 Solution: im...

Count A+b+c+ Subsequences

1. You are given a string str. 2. You are required to calculate and print the count of subsequences of the nature a+b+c+. For abbc -> there are 3 subsequences. abc, abc, abbc For abcabc -> there are 7 subsequences. abc, abc, abbc, aabc, abcc, abc, abc. Input Format A string str Output Format count of subsequences of the nature a+b+c+ Constraints 0 < str.length <= 10 Sample Input abcabc Sample Output 7 Solution: import java.io.*; import java.util.*; public class Main { public static void main(String[] args) throws Exception { Scanner sc = new Scanner(System.in); String str = sc.nextLine(); int counta = 0, countb = 0, countc = 0; for(int i=0;i<str.length();i++){ char ch = str.charAt(i); if(ch == 'a') ++coun...

Mock 3 Slot3 - Handson - 21st July Java (30 Marks) 1. Farm Fest

Anuj has a mango farm. He sells the mangoes and earns money from them. He fills the mangoes in a basket. To make the calculation much simpler, he fills the basket either with an odd number of mangoes or with an even number of mangoes. If the number of mangoes is a combination of both an even and an odd number of mangoes, then he needs to rearrange the basket. Note: Number of baskets cannot exceed 10 and cannot be zero or less, If so print “Invalid number of baskets”. A negative number of mangoes cannot exit, if so print "Invalid Input". Sample Input 1: Number of baskets 5 Number of mangoes in each basket 2 4 6 8 10 Sample Output 1: Even Sample Input 2: Number of baskets 4 Number of mangoes in each basket 13 29 45 5 Sample Output 2: Odd Sample Input 3: Number of baskets 3 Number of mangoes in each basket 12 13 14 Sample Output 3: Rearrange the mangoes Sample Input 4: Number of baskets 0 Sample Output 4: Invalid number of baskets Sample Input 5: Number of baskets 2 Number of ma...

Get's Answer

Search This Blog