Skip to main content

RDBMS Data Definition Language | Create Buses table

Image
By Astrio Jather

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


Labels:

Comments

Post a Comment

Must Read:

Course DH ASE B3 Slot3 Mock 1 Handson | RDBMS

By Astrio Jather
DH ASE B3          Slot3              Mock 1                  Handson: RDBMS
Post a Comment
Read more

Software Engineering Concepts Software Engineering Fundamentals Post-Quiz

By Astrio Jather
  Software Engineering Concepts       Software Engineering Fundamentals            Post-Quiz
Post a Comment
Read more

Accenture Mock Quiz | Part 4

By Astrio Jather
  Question  31 Correct Marked out of 1.00 Flag question Question text What will be the output of the following Java code? class Test extends Throwable { } class Base extends Test {} public class Main { public static void main(String args[]) { try { throw new Base(); } catch(Test t) { System.out.println("Test Exception"); } finally { System.out.println("Finally block "); } } } Select one: a.  Complilation error : Bass calss can't extends Test b.  print-"Test Exception" c.  Complilation error: Test Class cant extends Throwable d.  print - "Test Exception" "Finally block "   Feedback The correct answer is: print - "Test Exception" "Finally block " Question  32 Correct Marked out of 1.00 Flag question Question text Which of the following statement(s) is/are TRUE? (i) In a non-correlated(independent) subquery, the subquery is always executed only onc...
Post a Comment
Read more

Subscribe to Get's Answer by Email