Explore topic-wise InterviewSolutions in .

There will be no change.

txtNetFee.setEditable(false);

/*This is a command spreading

Over two lines*/

Similarity: Column with both the constraints will only take unique values.

Difference: Column with Primary key constraints will not be able to hold NULL values while Column with Unique constraints will be able to hold NULL values.

Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= "Debit";

<ol type= "A" start = "D">

<li>Bake in oven for an hour</li>

<li>Remove from oven</li>

<Ii>Serve</li>

</ol>

Similarity: Column with both the constraints will only take unique values.

Difference: Column with Primary key constraints will not be able to hold NULL values while Column with Unique constraints will be able to hold NULL values. 

Multiple options can be selected through jCheckBox control while jRadioButton allows selecting a single option.

The output is:

OS

This statement states that in XML the tags used are not predefined, which means that there is just a procedure that user needs to follow and hence whatever is written in accordance to that, will act as an tag of XML. In general user defines the tag accordance to the object in consideration.

getText(), setText()

jLabel is an un-editable control, used to display text or information at run time while jTextField control is an editable control where user can type in characters at run time.

getText(), setText()

Common properties are :

(i) Name.

(ii) Height.

(iii) Left.

(iv) Top.

Two common methods are:

(i) setHorizontalAlignment(int).

(ii) getHorizontalAlignment(int).

SQL stands for Structured Query Language. It's a standard language for accessing and manipulating databases. MySQL is a database management system, like SQL Server Oracle, Informix, Postgres, etc. MySQL is a RDMS (Relational Database Management System).

The prediction of Kunal is correct. Since, total entries arc 20, which are total numbers of students. 15 students got marks less than 100. 

So, rest are getting the marks which is equal to or greater than 100. (20 - 15 = 5).

SELECT NAME FROM STUDENT WHERE STATE IN ("VA");

50 rows. This kind of joining is known as Cartesian Product.

The correct answer:

(iii) SELECT * from Employees WHERE UPPER (EmpName) like '%AMIT%';

Yes it will be different as in First Code there will be no output while in Second Code the output will be 2 because in while loop condition is false in the beginning so control will not come inside the loop even for once while in do while loop, loop will be executed at least once even if the condition is false.

Yes it will be different as in First Code there will be no output while in Second Code the output will be 2 because in while loop condition is false in the beginning so control will not come inside the loop even for once while in do while loop, loop will be executed at least once even if the condition is false. 

Any two freedom offered by Free software are: 

The freedom to run the program for any purpose. 

The freedom to redistribute copies.

It is Freeware as freeware software are freely distributed and used by anyone but the source code is not available while source will be available with Free software.

Openoffice.org

A firewall is a program or hardware device that filters the information coming through an internet connection to a network or computer system. If incoming information does not pass the rules stored in the firewall, it is not allowed through.

i. Variables are named storage location to store values temporarily which can be changed during program execution.

Data type states the way the values of that type are stored, the operations that can be done on that type and the range for that type.

For example: 

int marks;

In the above statement, int is the data type and marks is the name of variable which store values temporarily.

ii. Assignment operator (=) is used to assign any value in a variable/constant while comparison operator (= =) is used to compare values.

For example:

int marks=90;

In the above statement value 90 is assigned to the variable named marks.

if(marks==40)

jTextField1.setText(“Just Pass”);

In the above if statement, value of marks is being compared with 40.

(i) Variables are named storage location to store values temporarily which can be changed during program execution.

Data type states the way the values of that type are stored, the operations that can be done on that type and the range for that type.

For example:

int marks;

In the above statement, int is the data type and marks is the name of variable which store values temporarily.

(ii) Assignment operator (=) is used to assign any value in a variable/constant while comparison operator (= =) is used to compare values.

For example:

int marks=90;

In the above statement value 90 is assigned to the variable named marks.

if(marks==40)

jTextField1.setText(“Just Pass”);

In the above if statement, value of marks is being compared with 40.

Correct option (d) None value

i.   Select count(name) from training where name like ‘Ms.%’;

ii.   Select * from training where fee is NULL;

iii.  Select city, fee from training where topic = ‘Cyber Security’;

iv.  Alter table training add feedback varchar(20); 

Sometimes we do not want to see the whole output produced by a statement with Group By clause. We want to see the output only for those groups which satisfy some condition. It means we want to put some condition on individual groups (and not on individual records). A condition on groups is applied by Having clause.

For example consider the following query:

select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type="Credit"; 

This query will create account number wise groups and instead of displaying the total amount of all type of transactions, it will only display the total of credit transactions only.

suitable command:

(i) Show Databases

(ii) Use City

(iii) Drop Database Clients

(iv) Drop table Club

(i)  Primary purpose of HTML is to design a webpage while XML is used to store and transport the data.

(ii)  Right

(iii)  Comments are added as notes or lines for understanding the purpose of an XML code. 

(iv) A comment starts with <!--and ends with -->.

Syntax for comments are as follows: 

<!--Comments-->

(v) An XML document with correct syntax is called "Well Formed".

(e)  verify whether the python application is connected to mysql database.

i.   Select count(name) from training where name like ‘Ms.%’;

ii.   Select * from training where fee is NULL;

iii.  Select city, fee from training where topic = ‘Cyber Security’;

iv.  Alter table training add feedback varchar(20); 

2301003    65000

2201002   20000

Degree: 6

Cardinality: 5

(i)  Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.

(ii)  COUNT(*) returns the number of items in a group, including NULL values and duplicates. COUNT(expression) evaluates expression for each row in a group and returns the number of non null values.

Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key.

Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key. 

A table can have multiple Candidate Keys that are unique as single column or combined multiple columns to the table. They are all candidates for Primary Key.

(i) Cadinality: 4

Degree: 5

(ii) Cardinality: 7

Degree: 6

i. New Delhi

Faridabad

Gurugram

ii.  2 

iii.  11000

iv.  Ms. Neena

Shiva has forgot to attach both the radio buttons to one button group to make them mutually exclusive.

Cartesian Product:

Number of Rows:  20

Number of Columns:  9

Degree:  9

Cardinality:  20

Degree: 6

Cardinality: 5

(i) The degree is 6 and cardinality is 5.

(ii) +------------+

|max(DOJ)|

+------------+

|1998-02-21|

+------------+

(iii) Delete from Customer_Details where Accumlt_Amt is NULL;

int sum=0, i=1;

while(i<=5)

{sum=sum+c;

i++;

}

Purpose of a lining- to finish the garment and to hide the garment’s inner construction.

Kind of a material- slippery, match/contrast with the colour of the garment.

Selection of a lining- compatible with care requirements of the rest of the garment, sufficiently opaque.

Bhanu Athaiya-1983

a. changes in body shapes of teens

b. head size of child is 1/5^th of his height

c. energetic behavior and rapidly growing body.

who designs and accessories the clothes worn by actors onscreen.

• Back neck
• Front neck
• Collar stand (along with relevant figures)

(a) Blocking off grain fabric

(b) Preshrinking

(c) Identifying right side of fabric.

Monitoring the performance of an employee.

a. Placket attachment on sleeve

b. Finishing of placket

c. Bar-tack (along with relevant figures)