| Table : Sargam | ||||||||
| AlbumID | Album | Cost | Qty | Singer | ||||
| 1001 | SAHER | 150 | 4 | JAGJEET SINGH | ||||
| 1002 | MADHUSHALA | 250 | 2 | MANNA DEY | ||||
| 1003 | IBADAT | 180 | 6 | MOHD.RAFI | ||||
| 1004 | KISMAT | 180 | 5 | MOHD.RAFI | ||||
| 1005 | HALCHAL | 200 | 8 | KISHORE KUMAR | ||||
| 1006 | BLACK | 210 | 4 | MICHEL | ||||
| 1007 | PASSION | 200 | 3 | SHAKIRA | ||||
| 1008 | NAMESAKE | 190 | 3 | MADONA | ||||
| 1009 | MELODIES | 220 | 7 | ASHA BHOSLE | ||||
| 1010 | CATWALK | 155 | 5 | MADONA | ||||
| 1011 | GOLDEN MELODIES | 250 | 10 | LATA MANGESHKAR | ||||
| A. Write the SQL statements to do the following tasks : | 5 | |||||||
| 1 | Write the statement to create the above mentioned table | |||||||
| 2 | Display details of all female employees who are permanent in ascending order of their name | |||||||
| 3 | Display name, designation and empID of all employees who have joined in the year 2000 | |||||||
| 4 | Display name,designtion and department of all employee having basicpay more than30000 and less | |||||||
| than 60000 | ||||||||
| 5 | Display EmpID, name and Birthdate of all male employees born in the month of september | |||||||
| B. Write the Output generated by the following commands : | 3 | |||||||
| 1 | Select Left(empname,5), empID from employee where basic pay>65000; | |||||||
| 2 | Select empID as "Employee ID", empname, basicpay+1000 from employee where designation="A%"; | |||||||
| 3 | update employee set status ="permanent" where year(apptdate)>2005; | |||||||
Wednesday, 7 September 2016
| Table : Employee | |||||||||
| EmpID | EmpName | Designation | Dept | ApptDate | BirthDate | BasicPay | Status | Gender | |
| 101 | Amrit Pal | Admin | HRD | 7-Jul-2000 | 5-Feb-1969 | 70000 | Permanent | Male | |
| 102 | Amrita Arora | Operator | Software | 8-Apr-2001 | 6-Jun-1974 | 20000 | Permanent | Female | |
| 103 | Anand Raj | Programmer | Software | 5-Aug-1998 | 5-May-1975 | 55000 | Permanent | Male | |
| 104 | Kanika Verma | Programmer | Software | 12-Jun-2003 | 25-Jun-1970 | 50000 | Permanent | Female | |
| 105 | Gopal Rai | Operator | Software | 3-Apr-2000 | 25-Aug-1980 | 25000 | Permanent | Male | |
| 106 | Kishori Lal | Peon | Software | 4-Dec-2006 | 4-Sep-1976 | 15000 | Temporary | Male | |
| 107 | Amritesh Singh | Manager | Software | 15-Jan-2000 | 30-Sep-1976 | 65000 | Permanent | Male | |
| 108 | Reema Pal | Manager | HRD | 2-Feb-2002 | 7-Jul-1981 | 60000 | Permanent | Female | |
| 109 | Nandini Mehta | Assistant | HRD | 23-Jun-2008 | 9-Sep-1974 | 40000 | Temporary | Female | |
| 110 | Komal Arora | Assistant | Software | 24-Feb-2000 | 3-Mar-1971 | 45000 | Permanent | Female | |
| A. Write the SQL statements to do the following tasks : | |||||||||
| 1 | Write the statement to create the above mentioned table | ||||||||
| 2 | Display details of all female employees who are permanent in ascending order of their name | ||||||||
| 3 | Display name, designation and empID of all employees who have joined in the year 2000 | ||||||||
| 4 | Display name,designtion and department of all employee having basicpay more than30000 and less | ||||||||
| than 60000 | |||||||||
| 5 | Display EmpID, name and Birthdate of all male employees born in the month of september | ||||||||
| B. Write the Output generated by the following commands : | |||||||||
| 1 | Select Left(empname,5), empID from employee where basic pay>65000; | ||||||||
| 2 | Select empID as "Employee ID", empname, basicpay+1000 from employee where designation="A%"; | ||||||||
| 3 | update employee set status ="permanent" where year(apptdate)>2005; | ||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MySQL
(Chapter 10 - Functions in
HTML)
1. Write the
purpose of the following functions :
a) Curdate()
b) Sysdate()
c) Dayofweek(date)
d) DayofMonth(date)
e) Dayofyear(date)
f) Power(4,2)
2. Write the
output of the following functions :
a) Concat(“Super”,”Hero”)
b) Substr(“teenager”,5,3)
c) Rtrim(“ hello friends “);
d) Left(“Informatics
Practices”,6)
e) Lcase(“GovinDa”)
Sunday, 4 September 2016
Chap 1 and 4 IP Assignments
SHAHEED RAJPAL D.A.V.PUBLIC SCHOOL,
DAYANAND VIHAR
Assignment - 4 (2016-17)
Informatics Practices
Class – XI
(Computer
Hardware)
1. Expand the following abbreviations :
MAR, MDR, CU, DVD, ALU,VDU, MICR, OCR,CPU, USB, RAM, ROM, IPO
2. Identify the following and name the device /
component :
a)
It is
the most commonly used output device looks like a TV screen. Uses CRT display.
b)
It is
used to listen to the audio output of the computer.
c)
It
controls and coordinates the communication among all the components of the
computer. It is a component of CPU.
d)
It is
responsible to perform arithmetic calculations and logical operations on the
computer.
e)
It is
the primary memory of computer that stores the data temporarily.
f)
It is
the primary memory responsible for the booting of the system and can only be
read.
g)
It
captures your image or video as data for computer with a good quality and is
commonly used for web chats or video conferencing.
h)
It is
used to make the communication possible by carring data from one component to
another.
i)
It is a
device to convert images of text into machine editable text. It is widely used
to convert books and documents into electronic files.
j)
It is a
device that takes human finger prints as input to maintain and identify data.
It is generally used for marking attendance of employees in an organization.
k)
It is
and input device consisting of sticks that pivots on a base. It is used to play
video games.
l)
It is
the temporary memory of the computer which is used for primary storage I
computer to hold active information of data and instructions.
m) It is the most commonly used secondary
storage device attached to a computer for storing data permanently.
3. Pair the following memory units which are
equivalent in size.
2Bytes, 1 nibble, 1024 MB, 1024 Bytes, 1 byte, 4
bits
1024 GB, 1 KB,
4 nibbles, 1 GB, 8 bits, 1TB
4. Define :
a)
Ports
b)
Communication
Bus
c)
Secondary
Memory
d)
Primary
Memory
e)
Memory
Unit
5. Explain the functioning of a computer with
the help of a diagram.
6. Differentiate between :
a)
Touch
screen and Mouse
b)
Primary
Memory and Secondary Memory
c)
Control
Unit and ALU
d)
Serial
port and Parallel port
e)
Data bus
and Control bus
f)
RJ 11
port and RJ 45 port
g)
Scanner
and OCR
h)
Laser
Printer and Inkjet Printer
i)
Speaker
and Microphone
j)
Plotter
and Dot Matrix Printer
k)
RAM and
ROM
7. Give five examples of each :
a)
Input
Devices
b)
Output
devices
c)
Secondary
Storage devices
SHAHEED RAJPAL D.A.V.PUBLIC SCHOOL,
DAYANAND VIHAR
Assignment - 5 (2016-17)
Informatics Practices
Class – XI
(Netbeans JAVA)
1. Why do we use NetBeans? Write its features.
2. Expand the following terms : IDE, GUI
3. Differentiate between :
a)
Properties
Window and Inspector window
b)
Project
Window and Palette window
c)
Design
window and Source window
d)
Label
control and Password control
e)
TextField
control and TextArea control
f)
RadioButton
control and Checkbox control
g)
Button
control and Button Group control
4. Write the purpose of :
a)
Integer.parseInt()
function
b)
Double.parseDouble()
function
c)
Integer.toString()
d)
Double.toString()
e)
concat()
f)
System.exit(0)
g)
JOptionPane.showMessageDialog()
h)
getText()
i)
setText()
5. Identify and underline the errors in the
following code and then rewrite the statement :
a)
jOptionpane.ShowMessageDialog(null,”
Welcome “ + jTextfield1.getText() + “ to the world of computer programming”);
b)
JOptionpane.showMessageDialog(Null,”Always be a winner”)
c)
JOptionPane. showMessageDialog(null,”Hello “ +
jTextField2.setText());
d)
JoptionPane.showMessageDialog(null,”Hard Work Leads to
Success”)
e)
jTextArea.settext(“welcome
all”);
f)
JTextfield1.getText(“India
is a Democratic Country”);
g)
jtextField2.
Set Text(“Hello \n world);
6. Identify the swing control :
a)
Which
control is used to group the RadioButtons in the form.
b)
To write
multiple line of text
c)
To
accept single line of text
d)
To
accept single line of text and convert each character in a common symbol
e)
To
accept multiple options
f)
To
accept atleast one option
g)
To take
action on the form by writing code into it.
h)
To give
information about a control
7. Which properties can be set for the following
swing controls :
a)
To give
title to a Form
b)
To set
font for a textfield
c)
To set
background color for a label control
d)
To write
text in multiple lines in a textArea control
e)
To add
scroll bars to a textarea
f)
To
change text of a label or textfield control
8. What will be the output of the following
commands :
a)
jTextArea1.setText(“Save
Water \n Every drop means life”);
b)
jTextArea1.setText(“India
has various festivals\nNational\t and \t Religious”);
c)
jTextArea2.setText(“Don’t
pollute the nature’s beauty,\n its our basic duty.”);
d)
jTextArea1.setText(“No
Crackers\tNo Pollution\n\nthis is our resolution”);
e)
jTextArea1.setText(“Save
Tiger \nSave Wildlife”);
f)
jTextArea1.setText(“Mera\tBharat\tMahan”);
9. Identify and label the
controls :
10. Design a GUI Form in JAVA to Accept adm.no, name
and streams (science, commerce and humanities) of a student. The application must have a
reset and exit button. Use appropriate labels and controls. Write the code for
Reset to clear data from the TextField controls and Exit button to terminate
the form.
11. Design a GUI Form in JAVA to Accept account
no., name and type of account (Saving or Current) of a customer. The application must have a
reset and exit button. Use appropriate labels and controls. Write the code for
Reset to clear data from the TextField controls and Exit button to terminate
the form.
12. Consider the following form and write the
code for the buttons as directed :
a)
On clicking
Writer button it displays a message“ is a Writer” in message box
b)
On
clicking Painter button it displays a message“ is a Painter” in message box
c)
When we
click on the Exit button the form terminates.
13. The following form accepts 2 number and displays the result in the third textfield
according to the button clicked. Write the code for Add button, subtract
button, multiply button and divide button. Also write code for clear button to
clear all the text fields and Close button to terminate the form.
Subscribe to:
Posts (Atom)