Skip to main content

RDBMS Data Definition Language | Alter - Add a column age

Image
By Astrio Jather

 Write a query to add a new column named Age of type number(10) to  Customer_Info table.

Write a query to add a new column named Age of type number(10) to Customer_Info table. Accenture Write a query to add a new column named Age of type number(10) to Customer_Info table.


Write a query to add a new column named Age of type number(10) to Customer_Info table. Accenture Write a query to add a new column named Age of type number(10) to Customer_Info table.

Write a query to add a new column named Age of type number(10) to Customer_Info table. Accenture Write a query to add a new column named Age of type number(10) to Customer_Info table.

Labels:

Comments

Post a Comment

Must Read:

RDBMS Data Definition Language | Create Sales_info table

By Astrio Jather
  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 | +------------------------------+
Post a Comment
Read more

RDBMS Data Definition Language | Create Buses table

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     Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

RDBMS Data Definition Language | Change the name of the table Sales Info

By Astrio Jather
  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 | +------------------------------+
Post a Comment
Read more

Software Engineering Concepts Hands-On

By Astrio Jather
  Software Engineering Concepts  Hands-On
Post a Comment
Read more

Logic Development Logic Development Test Your Understanding

By Astrio Jather
Logic Development       Logic Development            Test Your Understanding
Post a Comment
Read more

RDBMS Data Definition Language | Alter -Modify the field type

By Astrio Jather
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 | +------------------------------+
Post a Comment
Read more

Logic Development | Object Oriented Programming Post Quiz

By Astrio Jather
 Logic Development | Object-Oriented Programming | Post Quiz
Post a Comment
Read more

Count Binary Strings

By Astrio Jather
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] ...
Post a Comment
Read more

Subscribe to Get's Answer by Email