RDBMS Data Definition Language | Alter-Rename the field

RDBMS

Data Definition Language

Alter-Rename the field

Write a query to change the field name Distributor_name to Distributor_Full_name in Distributor table.

Evaluation Result:

 Result Description
 Summary of tests
+------------------------------+
| 3 tests run / 3 test passed  |
+------------------------------+

Comments

Must Read:

0-1 Pattern

/* @ToDo 0-1 Pattern 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 */ #include <iostream> using namespace std ; int main (){ #ifndef ONLINE_JUDGE freopen ( "../asset/input.txt" , "r" , stdin ); freopen ( "../asset/output.txt" , "w" , stdout ); #endif // Code here!! int n ; cin >> n ; int sign = 1 ; for ( int i = 1 ; i <= n ; i ++){ ...

Software Engineering Concepts Basics Of Testing Pre-Quiz

Software Engineering Concepts Basics Of Testing Pre-Quiz | Software Engineering Concepts Basics Of Testing Pre-Quiz | Software Engineering Concepts Requirement Analysis Post-Quiz Software Engineering Concepts Requirement Analysis Test Your Understanding Software Engineering Concepts Requirement Analysis Pre-Quiz Software Engineering Concepts Software Maintenance Test Your Understanding Software Engineering Concepts Software Maintenance Post-Quiz Software Engineering Concepts Software Maintenance Pre-Quiz Software Engineering Concepts Software Engineering Fundamentals Post-Quiz Software Engineering Concepts Software Engineering Fundamentals Pre-Quiz Algorithm Analysis and Design Concepts Data Structure and Algorithms Post-Quiz Software Engineering Concepts Configuration Management And V...

Arrange Buildings

1. You are given a number n, which represents the length of a road. The road has n plots on it's each side. 2. The road is to be so planned that there should not be consecutive buildings on either side of the road. 3. You are required to find and print the number of ways in which the buildings can be built on both side of roads. Input Format A number n Output Format A number representing the number of ways in which the buildings can be built on both side of roads. Constraints 0 < n <= 45 Sample Input 6 Sample Output 441 Solution: import java.io.*; import java.util.*; public class Main{ public static void main(String[] args) throws Exception { // write your code here Scanner scn = new Scanner(System.in); long n = scn.nextInt(); long ob = 1; long os = 1; for (int i = 2; i <= n; i++) { long nb = os; long ns = os + ob; ob = nb; ...

Accenture Mock Quiz | Part 1

Question 1 Incorrect Marked out of 1.00 Remove flag Question text Select the true statement ? Select one: a. Inheritance forms a is-a part of relationship between classes. b. Aggregation is the stronger form of Inheritance. c. Aggregation forms the is-a type of relationship between classes. d. Aggregation forms a is-a part of relationship between classes. Composition is the stronger form of Aggregation. Feedback The correct answer is: Aggregation forms a is-a part of relationship between classes. Composition is the stronger form of Aggregation. Question 2 Correct Marked out of 1.00 Flag question Question text What is the diagram that depicts the interaction between objects by arranging the objects in time sequence ? Select one: a. Use Case Diagram b. Sequence Diagram c. Component Diagram d. Activity Diagram Feedback The correct answer is: Sequence Diagram Question 3 Incorrect Marked out of 1.00 Flag question...

Count Encodings

1. You are given a string str of digits. (will never start with a 0) 2. You are required to encode the str as per following rules 1 -> a 2 -> b 3 -> c .. 25 -> y 26 -> z 3. You are required to calculate and print the count of encodings for the string str. For 123 -> there are 3 encodings. abc, aw, lc For 993 -> there is 1 encoding. iic For 013 -> This is an invalid input. A string starting with 0 will not be passed. For 103 -> there is 1 encoding. jc For 303 -> there are 0 encodings. But such a string maybe passed. In this case print 0. Input Format A string str Output Format count of encodings Constraints 0 < str.length <= 10 Sample Input 123 Sample Output 3 Solution: import java.io.*; import java.util.*; public class Main { ...

Mock 3 Slot3 - Handson - 21st July RDBMS (20 Marks) 2.1 Customer details

Write a query to display customer id, customer name, and password of customers whose name starts with 'A'. The password contains the first 3 characters from the name and the first 3 digits from the phone number. Give alias name for password as PASSWORD. Sort the records based on id in descending order. ( Hint: Retrieve data from Customers tables ) Evaluation Result: Result Description Summary of tests:(Note:Your query is evaluated against different datasets. Kindly do not Hardcode) +------------------------------+ | 2 tests run / 2 test passed | +------------------------------+

Accenture TFA MCQ | Part 1

Question 1 Correct Mark 1.00 out of 1.00 Flag question Question text Identify whether the below statement is True or False: The hierarchy of Reader/Writer class is character-oriented and InputStream/OutputStream class is byte-oriented Select one: True False Feedback The correct answer is 'True'. Question 2 Correct Mark 1.00 out of 1.00 Flag question Question text While garbage collection the java run time system automatically calls ______________method. Select one: a. finalize() b. finalizer() c. finally() d. finalized() Feedback The correct answer is: finalize() Question 3 Partially correct Mark 0.67 out of 1.00 Flag question Question text Choose all the statement(s) that are valid. Select one or more: a. There is only single copy of member function in memory when a class is loaded b. A super class is an incomplete class that requires further specification c. Two classes in two different packages can have ...

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 ) { ...

Get's Answer

Search This Blog