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

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

Comments

Must Read:

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

Software Engineering Concepts Configuration Management And Version Control Post-Quiz

Software Engineering Concepts Hands-On

RDBMS Data Definition Language | Alter -Modify the field type

Write a query to change the field type weight varchar(20) in Mobile_specification table to number(10). Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+

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 Pre-Quiz

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

Logic Development | Object Oriented Programming Post Quiz

Logic Development | Object-Oriented Programming | Post Quiz

Count Binary Strings

1. You are given a number n. 2. You are required to print the number of binary strings of length n with no consecutive 0's. Note: In this problem, you are given a number n. All we need to print is the number of binary strings of length n with no consecutive 0's For example: Sample Input: 3 Sample Output: 5 How 5? We have a total of eight binary numbers for length 3, out of which we have 5 numbers in which there are no consecutive zeros. Input Format A number n Output Format A number representing the number of binary strings of length n with no consecutive 0's. Constraints 0 < n <= 45 Sample Input 6 Sample Output 21 Solution: import java.io.*; import java.util.*; public class Main{ public static void main(String[] args) throws Exception { // write your code here Scanner sc = new Scanner(System.in); int n = sc.nextInt(); int dp[][] = new int[n+1][2]; dp[1][0] = 1; dp[1][1] ...

Get's Answer

Search This Blog