A Java Quiz
Settings
A Java Quiz
- 1.JTable has which of the following functions?
- A.
It stores data
- B.
It renders data
- C.
Both of the above
- D.
None of the above
- 2.Statement.executeUpdate(); method is used for fetching the data from the database from netbeans?
- A.
True
- B.
False
- 3.Statement.executeUpdate(); method is used for fetching the data from the database from netbeans?
- A.
True
- B.
False
- 4.JOptionPane.showInputDialog() will return?
- A.
Int
- B.
String
- C.
Double
- D.
Object
- 5.Which of the following needs to be imported for java jdbc connectivity JFrame project from netbeans?
- A.
Javax.sql.*;
- B.
Java.sql.*;
- C.
Javac.sql.*;
- D.
Java.sql;
- 6.You want to take the input of Hobbies from the user, ie Sports, Movies , Traveling etc which of the following controls would be the most suitable?
- A.
Radio Button
- B.
Check Box
- C.
Text Field
- D.
Combo box
- 7.Which of the following SQL objects will store the data retrieved through a Query?
- A.
Connection
- B.
Driver
- C.
Statement
- D.
ResultSet
- 8.Which of the following needs to be imported for java jdbc connectivity JFrame project from netbeans?
- A.
Javax.sql.*;
- B.
Java.sql.*;
- C.
Javac.sql.*;
- D.
Java.sql;
- 9.Class.forName() method is used for?
- A.
Firing the query
- B.
Getting the connection
- C.
Registering the Driver
- D.
None of the above
- 10.round and pow are methods of?
- A.
Util package
- B.
Math package
- C.
Lang package
- D.
Net package
- 11.Which keyword is used for implementing inheritance in java?
- A.
Implements
- B.
Extends
- C.
Inherits
- D.
Derives
- 12.Combination of two or more different kinds of inheritances is called?
- A.
Combination Inheritance
- B.
Hybrid Inheritance
- C.
Hierarchical Inheritance
- D.
Multiple Inheritance
- 13.Calender is a static class?
- A.
True
- B.
False
- 14.Java is object oriented language because it supports classes and encapsulation?
- A.
True
- B.
False
- 15.Which of the following is used to add or delete from a JList?
- A.
DefaultListModel
- B.
ListModel
- C.
AddElement()
- D.
RemoveElement()
- 16.for using date and calender which package should be imported?
- A.
Math
- B.
Util
- C.
Net
- D.
Applet
- 17.The overloaded methods are distinguished by both the return type and signature of the method?
- A.
True
- B.
False
- 18.How many types of dialogs are supported by jOptionPane?
- A.
1
- B.
2
- C.
3
- D.
4
- 19.Each row of a JTable in java is added using?
- A.
String
- B.
Object
- C.
Component
- D.
Panel
- 20.Which of the following methods is used by DefaultTableModel class to add rows to table.
- A.
AddElement()
- B.
AddRow()
- C.
AddRow(Object newrow)
- D.
AddRows()
- 21.Arrange the events in the order they need to be carried out 1. Extract data from result set 2. import the sql package 3. Execute Query 4.Open a connection
- A.
1,3,2,4
- B.
4,3,2,1
- C.
3,2,4,1
- D.
2,4,3,1
- 22.The MySql service is available by default at which of the following ports?
- A.
6303
- B.
3606
- C.
3303
- D.
3306
- 23.The Statement.executeQuery() will return?
- A.
Int
- B.
String
- C.
Object
- D.
ResultSet
- 24.Super keyword is used for which of the two purposes?
- A.
Refer to base class members with same name as in derived class in the derived class
- B.
Calling the base class destructors
- C.
To create new objects of the base class
- D.
Passing parameters to base class constructor
- 25.The Statement.executeUpdate() will return?
- A.
Int
- B.
String
- C.
Object
- D.
ResultSet
- 26.The overloaded methods are distinguished by both the return type and signature of the method?
- A.
True
- B.
False
- 27.How many types of dialogs are supported by jOptionPane?
- A.
1
- B.
2
- C.
3
- D.
4
- 28.JDBC can be used only from java?
- A.
True
- B.
False
- 29.Each row of a JTable in java is added using?
- A.
String
- B.
Object
- C.
Component
- D.
Panel
- 30.ODBC can be used from any front end?
- A.
True
- B.
False
- 31.JOptionPane.showConfirmDialog() will return which of the following?
- A.
Int
- B.
String
- C.
Object
- D.
ResultSet
- 32.Which of the following methods is used by DefaultTableModel class to add rows to table.
- A.
AddElement()
- B.
AddRow()
- C.
AddRow(Object newrow)
- D.
AddRows()
- 33.Savepoints need to be named?
- A.
True
- B.
False
- 34.By default autocommit is on?
- A.
True
- B.
False
- 35.Arrange the events in the order they need to be carried out 1. Extract data from result set 2. import the sql package 3. Execute Query 4.Open a connection
- A.
1,3,2,4
- B.
4,3,2,1
- C.
3,2,4,1
- D.
2,4,3,1
- 36.Till a user commits a transaction other users can not see the changed value during the progress of the transaction , which of the ACID properties does the above specify?
- A.
A
- B.
C
- C.
I
- D.
D
- 37.The MySql service is avialable by default at which of the following ports?
- A.
6303
- B.
3606
- C.
3303
- D.
3306
- 38.One transaction can have only one DML statement?
- A.
True
- B.
False
- 39.Any DDL statement will automatically commit a tracnsatcion under progress?
- A.
True
- B.
False
- 40.Which of the following are the two advantages of Inheritence?
- A.
Code Reuse
- B.
Method contention
- C.
Models Real World
- D.
Low level data representation
- 41.Protected data members are accessible outside the class in which defined?
- A.
True
- B.
False
- 42.Which of the following two are determinants of the Signature of a class?
- A.
Return Type
- B.
Super Class
- C.
Datatype of parameters
- D.
Number of Parameters
- 43.JOptionPane.showConfirmDialog() will return which of the following?
- A.
Int
- B.
String
- C.
Object
- D.
ResultSet
- 44.Class level variables are declared ?
- A.
Outside the class
- B.
In the constructor
- C.
In the beginning of the class definition
- D.
In any method of the class
- 45.Savepoints need to be named?
- A.
True
- B.
False
- 46.do -- while loop is exit controlled loop?
- A.
True
- B.
False
- 47.By default autocommit is on?
- A.
True
- B.
False
- 48.Durability of a transaction means?
- A.
The longer time it takes to execute
- B.
The shorter time it takes to execute
- C.
Permanance of changes made
- D.
Transaction can be undone
- 49.Till a user commits a transaction other users can not see the changed value during the progress of the transaction , which of the ACID properties does the above specify?
- A.
A
- B.
C
- C.
I
- D.
D
- 50.You make payment for your air reservation through your mobile, this is an example of?
- A.
E-commerce
- B.
M-commerce
- C.
Brick and Mortar Model
- D.
Payment Gateway
- 51.One transaction can have only one DML statement?
- A.
True
- B.
False
- 52.Any DDL statement will automatically commit a tracnsatcion under progress?
- A.
True
- B.
False
- 53.Which of the following two are advantages of e-Governance?
- A.
Increased Paperwork
- B.
Reduced Corruption
- C.
Reduced Paperwork
- D.
Increased Paperwork
- 54.Which of the following are the two advantages of Inheritence?
- A.
Code Reuse
- B.
Method contention
- C.
Models Real World
- D.
Low level data representation
- 55.In relational terminology a row is also called?
- A.
Horizonts
- B.
Attribute
- C.
Domain
- D.
Tuple
- 56.Protected data members are accessible outside the class in which defined?
- A.
True
- B.
False
- 57.There can be only one Primary Key in the Table?
- A.
True
- B.
False
- 58.Which of the following two are determinants of the Signature of a class?
- A.
Return Type
- B.
Super Class
- C.
Datatype of parameters
- D.
Number of Parameters
- 59.There can be only one alternate key in a table?
- A.
True
- B.
False
- 60.A table level primary key constraint is created when two or more columns form the Primary Key?
- A.
True
- B.
False
- 61.Class level variables are declared ?
- A.
Outside the class
- B.
In the constructor
- C.
In the beginning of the class definition
- D.
In any method of the class
- 62.Commit and Rollback are exemples of?
- A.
DDL Statements
- B.
DML
- C.
DCL
- D.
TCL
- 63.do -- while loop is exit controlled loop?
- A.
True
- B.
False
- 64.Grant and Revoke are examples of________ statements?
- A.
DML
- B.
DDL
- C.
TCL
- D.
DCL
- 65.Durability of a transaction means?
- A.
The longer time it takes to execute
- B.
The shorter time it takes to execute
- C.
Permanance of changes made
- D.
Transaction can be undone
- 66.You make payment for your air reservation through your mobile, this is an example of?
- A.
E-commerce
- B.
M-commerce
- C.
Brick and Mortar Model
- D.
Payment Gateway
- 67.There can be only one unique key in a Table?
- A.
True
- B.
False
- 68.There can be only one NOT NULL column in a table?
- A.
True
- B.
False
- 69.Which of the following two are advantages of e-Governance?
- A.
Increased Paperwork
- B.
Reduced Corruption
- C.
Reduced Paperwork
- D.
Increased Paperwork
- 70.In relational terminology a row is also called?
- A.
Horizonts
- B.
Attribute
- C.
Domain
- D.
Tuple
- 71.Dta members and methods are packed together in the class, this principle is known as________.
- A.
Abstraction
- B.
Encapsulation
- C.
Data Hiding
- D.
Inheritence
- 72.There can be only one Primary Key in the Table?
- A.
True
- B.
False
- 73.Working at a particular level of abstraction with out considering background details is known as________?
- A.
Inheritence
- B.
Data Hiding
- C.
Abstraction
- D.
Encapsulation
- 74.There can be only one alternate key in a table?
- A.
True
- B.
False
- 75.Which of the following is not a option type value of JOptionPane?
- A.
-1
- B.
0
- C.
2
- D.
3
- 76.A table level primary key constraint is created when two or more columns form the Primary Key?
- A.
True
- B.
False
- 77.A cross join is created by using two tables. First table has 5 rows , second table has three rows, the result has how many rows?
- A.
8
- B.
15
- C.
10
- D.
30
- 78.Commit and Rollback are exemples of?
- A.
DDL Statements
- B.
DML
- C.
DCL
- D.
TCL
- 79.Which of the following is immutable?
- A.
StringBUffer
- B.
String
- C.
Int
- D.
Float
- 80.Grant and Revoke are examples of________ statements?
- A.
DML
- B.
DDL
- C.
TCL
- D.
DCL
- 81.There can be only one unique key in a Table?
- A.
True
- B.
False
- 82.Which of the two types of inheritence java does not support?
- A.
Hybrid
- B.
Single
- C.
Multilevel
- D.
Hierarchical
- E.
Multiple
- 83.There can be only one NOT NULL column in a table?
- A.
True
- B.
False
- 84.You can save time by creating your website?
- A.
Using HTML
- B.
Using DreamWeaver
- C.
Using Word
- 85.A in ACID stands for?
- 86.D in ACID stands for?
- 87.Which of the following are the two advantages of e-learning?
- A.
You can learn at your own pace
- B.
There is no human touch
- C.
It is interactive
- D.
You need a computer and internet connectivity togo on with it
- 88.Dta members and methods are packed together in the class, this principle is known as________.
- A.
Abstraction
- B.
Encapsulation
- C.
Data Hiding
- D.
Inheritence
- 89.Which of the following topologies have the advantage of short cable length?
- A.
Star
- B.
Bus
- C.
Ring
- D.
Tree
- 90.Working at a particular level of abstraction with out considering background details is known as________?
- A.
Inheritence
- B.
Data Hiding
- C.
Abstraction
- D.
Encapsulation
- 91.In which of the following topologies there is a dependence on the central node for functioning?
- A.
Ring
- B.
Tree
- C.
Graph
- D.
Star
- 92.Which of the following is not a option type value of JOptionPane?
- A.
-1
- B.
0
- C.
2
- D.
3
- 93.WiMax technology is used in?
- A.
PAN
- B.
WAN
- C.
LAN
- D.
DAN
- 94.A cross join is created by using two tables. First table has 5 rows , second table has three rows, the result has how many rows?
- A.
8
- B.
15
- C.
10
- D.
30
- 95.P in PAN stands for____________________.
- 96.Which of the following is immutable?
- A.
StringBUffer
- B.
String
- C.
Int
- D.
Float
- 97.Which of the following are open source softwares?
- A.
Mozilla Firefox
- B.
Mac OX
- C.
Windows 7
- D.
Linux
- 98.Which one type of inheritence java does not support?
- A.
Hybrid
- B.
Single
- C.
Multilevel
- D.
Hierarchical
- E.
Multiple
- 99.You can save time by creating your website?
- A.
Using HTML
- B.
Using DreamWeaver
- C.
Using Word
- 100.Abstract class is a class which can be instantiated?
- A.
True
- B.
False
- 101.Which of the following are the two advantages of e-learning?
- A.
You can learn at your own pace
- B.
There is no human touch
- C.
It is interactive
- D.
You need a computer and internet connectivity togo on with it
- 102.R in RAD stands for?
- 103.A foreign key can not refer to the same table primary key?
- A.
True
- B.
False
- 104.Which of the following topologies have the advantage of short cable length?
- A.
Star
- B.
Bus
- C.
Ring
- D.
Tree
- 105.A while loop will execute at least once irrespective of the condition specified in the loop?
- A.
True
- B.
False
- 106.In which of the following topologies there is a dependence on the central node for functioning?
- A.
Ring
- B.
Tree
- C.
Graph
- D.
Star
- 107.Which of the following is a cross of Text Field and List?
- A.
ComboBox
- B.
Check Box
- C.
Radio Button
- D.
PasswordField
- 108.WiMax technology is used in?
- A.
PAN
- B.
WAN
- C.
LAN
- D.
DAN
- 109.A group of logically related classes is called a?
- A.
Project
- B.
Solution
- C.
Group
- D.
Package
- 110.P in PAN stands for____________________.
- 111.Which of the following are open source softwares?
- A.
Mozilla Firefox
- B.
Mac OX
- C.
Windows 7
- D.
Linux
- 112.Which protocol does the Apache server use?
- A.
TCL
- B.
HTTP
- C.
SSL
- D.
FTP
- 113.Which of the following means of internet connectivity has the maximum reach?
- A.
Radio Waves
- B.
Fibre Optics
- C.
Satellite Connection
- D.
Nicrowaves
- 114.Apache server also known as HTTP server is a ___ server?
- A.
File
- B.
Web
- C.
Cloud
- D.
Cluster
- 115.Abstract class is a class which can be instantiated?
- A.
True
- B.
False
- 116.R in RAD stands for?
- 117.Which of the following topologies features direct connection between all participating nodes?
- A.
Star
- B.
Mesh
- C.
Tree
- D.
Ring
- 118.A foreign key can not refer to the same table primary key?
- A.
True
- B.
False
- 119.A while loop will execute at least once irrespective of the condition specified in the loop?
- A.
True
- B.
False
- 120.Which of the following principles does the optical fibre use for transmission?
- A.
Reflection
- B.
Refraction
- C.
Total internal reflection
- D.
Total internal refraction
- 121.Which of the following is a cross of Text Field and List?
- A.
ComboBox
- B.
Check Box
- C.
Radio Button
- D.
PasswordField
- 122.ASCII is a _________ bit code?
- A.
6
- B.
7
- C.
8
- D.
9
- 123.A group of logically related classes is called a?
- A.
Project
- B.
Solution
- C.
Group
- D.
Package
- 124.ISCII is a _________bit code?
- A.
6
- B.
7
- C.
8
- D.
9
- 125.Which protocol does the Apache server use?
- A.
TCL
- B.
HTTP
- C.
SSL
- D.
FTP
- 126.A firewall generally sits on ?
- A.
Web server
- B.
Proxy server
- C.
Data server
- D.
Application server
- 127.Apache server also known as HTTP server is a ___ server?
- A.
File
- B.
Web
- C.
Cloud
- D.
Cluster
- 128.The natural join uses the on condition to specify which columns are equal?
- A.
True
- B.
False
- 129.The natural join is a equi join?
- A.
True
- B.
False
- 130.The set autocommit will enable or disable the autocommit option only for current session?
- A.
True
- B.
False
- 131.There is a table emp(eno,ename,deptno) Another table dept(dno,dname,mgr) I can create a natural Join using the above table structures?
- A.
True
- B.
False
- 132.Which of the following topologies features direct connection between all participating nodes?
- A.
Star
- B.
Mesh
- C.
Tree
- D.
Ring
- 133.A fibre optics medium can carry upto following messages at a time using light pulses?
- A.
1
- B.
100
- C.
1 million
- D.
10 million
- 134.Which of the following principles does the optical fibre use for transmission?
- A.
Reflection
- B.
Refraction
- C.
Total internal reflection
- D.
Total internal refraction
- 135.Which of the following two are selection statements?
- A.
For
- B.
While
- C.
If
- D.
Switch
- 136.ASCII is a _________ bit code?
- A.
6
- B.
7
- C.
8
- D.
9
- 137.The following is the structure of employee table emp( eno,ename, basic, dept) eno is the primary key? I can create a group by statement by using eno column?
- A.
True
- B.
False
- 138.The following is the structure of employee table emp( eno,ename, basic, dept,mgr) eno is the primary key? In the above table which are the candidate keys for grouping of records? (Select two)
- A.
Basic
- B.
Dept
- C.
Mgr
- D.
Ename
- 139.
![What query should be written to find the name of all managers? (Based on the following table).
- ProProfs]( "What query should be written to find the name of all managers? (Based on the following table).")
What query should be written to find the name of all managers? (Based on the following table).- A.
Select *(mgr) from emp;
- B.
Select mgr from emp;
- C.
Select distinct mgr from emp;
- D.
Select count(distinct mgr) from emp;
- 140.A firewall generally sits on ?
- A.
Web server
- B.
Proxy server
- C.
Data server
- D.
Application server
- 141.
![What is the output of the following query?
select sum(Basic) from Employee where eno>=5;
- ProProfs]( "What is the output of the following query?
select sum(Basic) from Employee where eno>=5;")
What is the output of the following query? select sum(Basic) from Employee where eno>=5;- A.
1000
- B.
2000
- C.
3000
- D.
4000
- 142.The natural join uses the on condition to specify which columns are equal?
- A.
True
- B.
False
- 143.
![Which eno will be displayed by the following query?
select * from Employee where Ename like 'M%'; - ProProfs]( "Which eno will be displayed by the following query?
select * from Employee where Ename like 'M%';")
Which eno will be displayed by the following query? select * from Employee where Ename like 'M%';- A.
5
- B.
1
- C.
2
- D.
7
- 144.The natural join is a equi join?
- A.
True
- B.
False
- 145.There is a table emp(eno,ename,deptno) Another table dept(dno,dname,mgr) I can create a natural Join using the above table structures?
- A.
True
- B.
False
- 146.A fibre optics medium can carry upto following messages at a time using light pulses?
- A.
1
- B.
100
- C.
1 million
- D.
10 million
- 147.
![How many records will be displayed by the following Query?
select count(distinct Mgr) from Employee?
- ProProfs]( "How many records will be displayed by the following Query?
select count(distinct Mgr) from Employee?")
How many records will be displayed by the following Query? select count(distinct Mgr) from Employee?- A.
1
- B.
2
- C.
3
- D.
4
- 148.Other than Eno which other columns could be used as Primary keys? Select all that apply?
- A.
Ename
- B.
Mgr
- C.
Salary
- D.
Basic
- 149.Which of the following two are selection statements?
- A.
For
- B.
While
- C.
If
- D.
Switch
- 150.The following is the structure of employee table emp( eno,ename, basic, dept) eno is the primary key? I can create a group by statement by using eno column?
- A.
True
- B.
False
- 151.The following is the structure of employee table emp( eno,ename, basic, dept,mgr) eno is the primary key? In the above table which are the candidate keys for grouping of records? (Select three)
- A.
Basic
- B.
Dept
- C.
Mgr
- D.
Ename
- 152.
![What query should be written to find the name of all managers? (Based on the following table).
- ProProfs]( "What query should be written to find the name of all managers? (Based on the following table).")
What query should be written to find the name of all managers? (Based on the following table).- A.
Select *(mgr) from emp;
- B.
Select mgr from emp;
- C.
Select distinct mgr from emp;
- D.
Select count(distinct mgr) from emp;
- 153.A MAN is larger than a WAN.
- A.
True
- B.
False
- 154.
![What is the output of the following query?
select sum(Basic) from Employee where eno>=5;
- ProProfs]( "What is the output of the following query?
select sum(Basic) from Employee where eno>=5;")
What is the output of the following query? select sum(Basic) from Employee where eno>=5;- A.
1000
- B.
2000
- C.
3000
- D.
4000
- 155.The MAC address of a networking device can be assigned by using software code, ie it is configurable.
- A.
True
- B.
False
- 156.
![How many records will be displayed by the following query?
select * from Employee where Basic>2000;
- ProProfs]( "How many records will be displayed by the following query?
select * from Employee where Basic>2000;")
How many records will be displayed by the following query? select * from Employee where Basic>2000;- A.
1
- B.
2
- C.
3
- D.
4
- 157.
![How many records will be displayed by the following Query?
select count(distinct Mgr) from Employee?
- ProProfs]( "How many records will be displayed by the following Query?
select count(distinct Mgr) from Employee?")
How many records will be displayed by the following Query? select count(distinct Mgr) from Employee?- A.
1
- B.
2
- C.
3
- D.
4
- 158.Other than Eno which other columns could be used as Primary keys? Select all that apply?
- A.
Ename
- B.
Mgr
- C.
Salary
- D.
Basic
- 159.Descriptive Web Site names are converted into numerical ones by which of the following?
- A.
Switch
- B.
Hub
- C.
Web server
- D.
Dns server
- 160.
![How many rows will be displayed by the following query?
select dept,sum(salary) from Employee group by Dept having avg(salary)>=2500; - ProProfs]( "How many rows will be displayed by the following query?
select dept,sum(salary) from Employee group by Dept having avg(salary)>=2500;")
How many rows will be displayed by the following query? select dept,sum(salary) from Employee group by Dept having avg(salary)>=2500;- A.
1
- B.
2
- C.
3
- D.
4
- 161.Which of the following two are true about Ogg Vorbis
- A.
Its a video compression format
- B.
Its a audio compression format
- C.
It is open source
- D.
It is proprietary
- 162.Which of the following ( select all) that are true about PHP?
- A.
It is open source
- B.
Used for server side applications
- C.
It is proprietary
- D.
It is used for dynamic pages
- E.
It is used to create static pages
- 163.A firewall caches internet pages of the LAN which are frequently requested.
- A.
True
- B.
False
- 164.A firewall protects the Company LAN from outside threats.
- A.
True
- B.
False
- 165.Having clause can be used without group by clause?
- A.
True
- B.
False
- 166.A MAN is larger than a WAN.
- A.
True
- B.
False
- 167.The MAC address of a networking device can be assigned by using software code, ie it is configurable.
- A.
True
- B.
False
- 168.Unicode can represent how many characters?
- A.
8,240
- B.
90,140
- C.
94,140
- D.
60,140
- 169.What is the size of Unicode character?
- A.
1 bit
- B.
4 bits
- C.
1 byte
- D.
2 bytes
- 170.Which of the following table constraint is used to provide a Default Value to the column?
- A.
Auto
- B.
Automatic
- C.
Default
- D.
Check
- 171.IP address contains how many octetes?
- A.
3
- B.
4
- C.
256
- D.
255
- 172.Ubuntu is open source _________?
- A.
Browser
- B.
OS
- C.
Document Reader
- D.
Spreadsheet
- 173.Descriptive Web Site names are converted into numerical ones by which of the following?
- A.
Switch
- B.
Hub
- C.
Web server
- D.
Dns server
- 174.Open Office is a ________?
- A.
Suite like MS Office
- B.
OS
- C.
Browser
- D.
Spreadsheet
- 175.Which of the following two are true about Ogg Vorbis
- A.
Its a video compression format
- B.
Its a audio compression format
- C.
It is open source
- D.
It is proprietary
- 176.Which of the following are true with respect to XML? ( Select all that are true).
- A.
XML is case sensitive
- B.
XML is case insensitive
- C.
IN XML tags are predefined
- D.
IN XML tags are created
- 177.Which of the following ( select all) that are true about PHP?
- A.
It is open source
- B.
Used for server side applications
- C.
It is proprietary
- D.
It is used for dynamic pages
- E.
It is used to create static pages
- 178.Having clause can be used without group by clause?
- A.
True
- B.
False
- 179.The title tag is is to be defined in which section?
- A.
Head
- B.
Body
- C.
Html
- D.
Table
- 180.Which of the following two MYSQL clauses are always used together? (Select two)
- A.
Group By
- B.
Where
- C.
Order By
- D.
Having
- 181.Which of the following tags will create a bulleted list?
- A.
OL
- B.
UL
- C.
BL
- D.
BUL
- 182.Which of the following two tble constraints are alike ? ( Select Two )
- A.
Primary Key
- B.
Default
- C.
Unique
- D.
Foreign key
- 183.Which of the following table constraint is used to provide a Default Value to the column?
- A.
Auto
- B.
Automatic
- C.
Default
- D.
Check
- 184.Ubuntu is open source _________?
- A.
Browser
- B.
OS
- C.
Document Reader
- D.
Spreadsheet
- 185.Open Office is a ________?
- A.
Suite like MS Office
- B.
OS
- C.
Browser
- D.
Spreadsheet
- 186.A break statement in Java will only break the inner loop, in case of nested loops.
- A.
True
- B.
False
- 187.There can be only one Foreign key in a table?
- A.
True
- B.
False
- 188.Which of the following are true with respect to XML? ( Select all that are true).
- A.
XML is case sensitive
- B.
XML is case insensitive
- C.
IN XML tags are predefined
- D.
IN XML tags are created
- 189.There can be only one Primary Key in a table.
- A.
True
- B.
False
- 190.Degree of a table is?
- A.
No of rows
- B.
No of columns
- C.
Rows * columns
- D.
Rows/ columns
- 191.Which three of the following are the functions of XML?
- A.
Store data
- B.
Format data
- C.
Transmit Data
- D.
Structure data
- E.
Unstructure Data
- 192.cardinality of a table is?
- A.
No of rows
- B.
No of columns
- C.
Rows * columns
- D.
Rows/ columns
- 193.The title tag is is to be defined in which section?
- A.
Head
- B.
Body
- C.
Html
- D.
Table
- 194.There are n1 rows in first table, n2 rows in second table. The cross join of the two tables will have how many rows?
- A.
N1 + n2
- B.
N1 * n2
- C.
N1 / n2
- D.
N2 / n1
- 195.Which of the following tags will create a bulleted list?
- A.
OL
- B.
UL
- C.
BL
- D.
BUL
- 196.Complex data structures are found in?
- A.
Conceptual level
- B.
Physical level
- C.
External Level
- D.
View Level
- 197.Which three of the following are DML commands in MySql?
- A.
Create Table
- B.
Insert
- C.
Update
- D.
Delete
- E.
Drop Table
- 198.Logical structures like table and Views are found in?
- A.
Physical level
- B.
Conceptual level
- C.
External Level
- D.
View Level
- 199.Which two of the following are DDL commands in MySql?
- A.
Create Table
- B.
Insert
- C.
Update
- D.
Delete
- E.
Drop Table
- 200.A break statement in Java will only break the inner loop, in case of nested loops.
- A.
True
- B.
False
- 201.A view can be used to rename a column?
- A.
True
- B.
False
- 202.There can be only one Foreign key in a table?
- A.
True
- B.
False
- 203.Which topology has the advantage of short cable length? ( 1 word )
- 204.There can be only one Primary Key in a table.
- A.
True
- B.
False
- 205.Which topology is hierarchical in nature? ( 1 Word )
- 206.which command is used to drop a column? ( two words )
- 207.Degree of a table is?
- A.
No of rows
- B.
No of columns
- C.
Rows * columns
- D.
Rows/ columns
- 208.Which command is used to drop a table? ( two words)
- 209.cardinality of a table is?
- A.
No of rows
- B.
No of columns
- C.
Rows * columns
- D.
Rows/ columns
- 210.There are n1 rows in first table, n2 rows in second table. The cross join of the two tables will have how many rows?
- A.
N1 + n2
- B.
N1 * n2
- C.
N1 / n2
- D.
N2 / n1
- 211.In MYSql _________ keyword is used to check for null values?( 1 word )
- 212.Complex data structures are found in?
- A.
Conceptual level
- B.
Physical level
- C.
External Level
- D.
View Level
- 213.Which of the following two constitutes data independence?
- A.
Physical
- B.
Non-Clustered
- C.
Cluster
- D.
Logical
- 214.Logical structures like table and Views are found in?
- A.
Physical level
- B.
Conceptual level
- C.
External Level
- D.
View Level
- 215.In Which of the following data independence low level physical files may be changed but logical level remains the same?
- A.
Physical
- B.
Non-Clustered
- C.
Cluster
- D.
Logical
- 216.Which of the following are functions of views? ( Any Two )
- A.
Renaming Columns
- B.
Simplifying queries
- C.
Complicating queries
- D.
Counting columns
- 217.A view can be used to rename a column?
- A.
True
- B.
False
- 218.Copper Cables are generally restricted to 100 metres.
- A.
True
- B.
False
- 219.Which topology has the advantage of short cable length? ( 1 word )
- 220.Which topology is hierarchical in nature? ( 1 Word )
- 221.Fiber cable has high transmission loss?
- A.
True
- B.
False
- 222.Which command is used to drop a table? ( two words)
- 223.Which of the following are column constraints in a Table?
- A.
Check
- B.
Exists
- C.
Not Null
- D.
Between
- E.
Default
- 224.In MYSql _________ keyword is used to check for required columns?( 2 words )
- 225.Which of the following two constitutes data independence?
- A.
Physical
- B.
Non-Clustered
- C.
Cluster
- D.
Logical
- 226.In Which of the following data independence low level physical files may be changed but logical level remains the same?
- A.
Physical
- B.
Non-Clustered
- C.
Cluster
- D.
Logical
- 227.Which of the following are the true about fiber cables?
- A.
It has higher bandwidth than copper cables
- B.
It has lower bandwidth than copper cables
- C.
It is easy to tap
- D.
It is difficult to tap
- 228.While(1) { System.out.println("Hello World"): } The above loop will run
- A.
1 time
- B.
5 times
- C.
100 times
- D.
It is an infinite loop
- 229.Copper Cables are generally restricted to 100 metres.
- A.
True
- B.
False
- 230.While(1); { System.out.println("Hello World"): } What is the error in the above piece of code
- A.
A semicolon after while
- B.
A semicolon after System.out.println
- C.
S should be lowercase in system.out.println
- D.
There are no errors
- 231.Which of thefollowing aretrue about fibre cables?(Select two)
- A.
They are lighter than copper cables
- B.
They are heavier than copper cables
- C.
They are used mostly in backbone networks
- D.
It has high transmission loss
- 232.LI in HTML stands for?
- A.
List Iterator
- B.
Link Item
- C.
List Item
- D.
Link Iterator
- 233.Which of the following is just like the bullted list in HTML?
- A.
OL
- B.
UL
- C.
IL
- D.
PL
- 234.Fiber cable has high transmission loss?
- A.
True
- B.
False
- 235.snapdeal.com is a ?
- A.
E-learning site
- B.
E-commerce site
- C.
E-governance site
- D.
M-commerce site
- 236.Which command is used to remove rows from a table from the database?
- A.
Delete
- B.
Drop
- C.
Remove
- D.
Clear
- 237.Shiksha.com and MeritNation.com are ___________ websites?
- A.
E-commerce
- B.
E-governance
- C.
E-learning
- D.
M-commerce
- 238.What will happen if you forget to give where condition after update command?
- A.
It will be a MySql ereror
- B.
It will not update any row
- C.
It will update all rows of table
- D.
Nothing happens
- 239.Incometaxindia.gov.in is a url of?
- A.
E-commerce site
- B.
M-commerce site
- C.
E-governance site
- D.
Educational site
- 240.Transactions can be created only by grouping DDL statements together?
- A.
True
- B.
False
- 241.Statement stmt; stmt=con.createConnection(); stmt.executeUpdate(); // What is the return type of this statement? What is the return type of this statement? stmt.executeUpdate()
- A.
Int
- B.
Object
- C.
Resultset
- D.
String
- 242.Haryana.nic.in is a url of?
- A.
E-commerce site
- B.
M-commerce site
- C.
E-governance site
- D.
Educational site
- 243.Statement stmt; stmt=con.createConnection(); stmt.executeQuery(); // What is the return type of this statement? What is the return type of this statement? stmt.executeQuery()
- A.
Int
- B.
Object
- C.
Resultset
- D.
String
- 244.Alter table command can be used to drop the Primary KeY?
- A.
True
- B.
False
- 245.Alter table command can be used to add the Primary KeY to a table?
- A.
True
- B.
False
- 246.LI in HTML stands for?
- A.
List Iterator
- B.
Link Item
- C.
List Item
- D.
Link Iterator
- 247.What is the return type of Math.pow() ?
- A.
Int
- B.
Float
- C.
Double
- D.
String
- 248.Which of the following is just like the bullted list in HTML?
- A.
OL
- B.
UL
- C.
IL
- D.
PL
- 249.Concat() is a method of which class?
- A.
StringBuffer
- B.
String
- C.
Math
- D.
System
- 250.Which command is used to remove a table from the database?
- A.
Delete
- B.
Drop
- C.
Remove
- D.
Clear
- 251.Which command is used to remove rows from a table from the database?
- A.
Delete
- B.
Drop
- C.
Remove
- D.
Clear
- 252.What will happen if you forget to give where condition after update command?
- A.
It will be a MySql ereror
- B.
It will not update any row
- C.
It will update all rows of table
- D.
Nothing happens
- 253.Transactions can be created only by grouping DDL statements together?
- A.
True
- B.
False
- 254.Statement stmt; stmt=con.createConnection(); stmt.executeUpdate(); // What is the return type of this statement? What is the return type of this statement? stmt.executeUpdate()
- A.
Int
- B.
Object
- C.
Resultset
- D.
String
- 255.Statement stmt; stmt=con.createConnection(); stmt.executeQuery(); // What is the return type of this statement? What is the return type of this statement? stmt.executeQuery()
- A.
Int
- B.
Object
- C.
Resultset
- D.
String
- 256.Alter table command can be used to drop the Primary KeY?
- A.
True
- B.
False
- 257.Alter table command can be used to add the Primary KeY to a table?
- A.
True
- B.
False
- 258.What is the return type of Math.pow() ?
- A.
Int
- B.
Float
- C.
Double
- D.
String
- 259.Which of the following fonts are used by windows and Mac?
- A.
True Type
- B.
Open Type
- C.
CTF
- D.
MRT
- 260.Which of the following fonts are used to represent 64,000 characters?
- A.
True Type
- B.
Open Type
- C.
CTF
- D.
MRT
- 261.Html is the root tag of a html document?
- A.
True
- B.
False
- 262.Body is the root tag of a html document?
- A.
True
- B.
False
- 263.Which two of the following are protocols?
- A.
FTP
- B.
TTP
- C.
SMHT
- D.
HTTP
- 264.<b> will make a word?
- A.
Italicized
- B.
Underlined
- C.
Bold
- D.
Upper Case
- 265.Order by clause in Mysql is used to
- A.
Sort in ascending order
- B.
Sort in descending order
- C.
Sort in ascending or descending order
- D.
Give the fields datewise
- 266.CAT 5 cable can be used for a length upto?
- A.
100 metres
- B.
200 metres
- C.
300 metres
- D.
400 metres
- 267.CAT 6 cable can be used for a length upto?
- A.
100 metres
- B.
200 metres
- C.
300 metres
- D.
400 metres
- 268.Select ascii("BABITA"); will return
- A.
65
- B.
66
- C.
97
- D.
98
- 269.The maximum value dayofyear() function can return is?
- A.
128
- B.
365
- C.
366
- D.
720
- 270.What is the result of the following? String str="Hi There"; int len=str.length(); System.out.prinltln(len);
- A.
7
- B.
8
- C.
9
- D.
6
- 271.What will be the output of the following? Date d=new Date(); lblMsg.setText(d);
- A.
Date with time
- B.
Date without time
- C.
Time without date
- D.
Error
- 272.What will be the result of the following? String str="Ravi"; StringBuffer sb=new StringBuffer(str); int len=str.length(); for(int i=0;i
- A.
RXvX
- B.
Rxvi
- C.
RXvi
- D.
None of the above
- 273.What will be the result of the following? String str="Ravi"; StringBuffer sb=new StringBuffer(str); int len=str.length(); for(int i=0;i
- A.
RXvX
- B.
Rxvi
- C.
RXvi
- D.
Ravi
- 274.Calendar class is an abstract class.
- A.
True
- B.
False
- 275.Calendar class is found in which package?
- A.
Math
- B.
Util
- C.
Lang
- D.
Net
- 276.System and String classes are defined in which package?
- A.
Lang
- B.
Net
- C.
Io
- D.
Applet
- 277.Which package is imported by default in java?
- A.
Sys
- B.
System
- C.
Lang
- D.
Io
- 278.Indiapost.gov.in and passportindia.gov.in are examples of?
- A.
E-Commerce sites
- B.
E-Governance sites
- C.
Educational Sites
- D.
Commercial sites
- 279.Which of the following tag is used for table heading style?
- A.
Tr
- B.
Th
- C.
Theader
- D.
Tfoot
- 280.Which of the following tag is used for table head section?
- A.
Tr
- B.
Th
- C.
Thead
- D.
Tfoot
- 281.Transliteration of Indian Languages means?
- A.
TYping using hindi key map
- B.
Using English phonetics to type Indian languages
- C.
Using scanner
- D.
Using Indian languages font
- 282.WE can use Indian language key map to type in Iindian languages?
- A.
True
- B.
False
- 283.If it is a composite primary key, it ought to be a table level constraint at the time of definition and not a column constraint.
- A.
True
- B.
False
- 284.A row is also called a ?
- A.
Tuple
- B.
Attribute
- C.
Column
- D.
Single data
- 285.A css file is used to?
- A.
Format the data
- B.
Structure the data
- C.
Transform the data
- D.
Hide the data
- E.
Encrypt the data
- 286.A XML document which adheres to a DTD is called?
- A.
Well formed
- B.
Valid
- C.
Structured
- D.
Formatted
- 287.A XML document which follows all the rules of XML but may not adhere to a DTD is called?
- A.
Well formed
- B.
Valid
- C.
Structured
- D.
Formatted
- 288.Which of the following two types can be used to clear a radio button rb1 belonging to radio group rg1.
- A.
Rb1.clear();
- B.
Rb1.setSelected(false);
- C.
Rg1.setSelected(false);
- D.
Rg1.clearSelection();
- 289.Which of the following controls can be used to submit a form?
- A.
Check box
- B.
Radio button
- C.
Text area
- D.
Submit button
- 290.Which of the following controls can be used to show cities in a HTML form?
- A.
Check box
- B.
Radio button
- C.
Text area
- D.
List or Combobox
- 291.Which property of List or Combobox can be used to show which items are displayed?
- A.
List
- B.
Model
- C.
Items
- D.
Values
- 292.If int a=10,b=20 what is the result of the following expression b+a*b*a
- A.
4040
- B.
2020
- C.
6000
- D.
3000
- 293.True type fonts were developed by
- A.
Apple
- B.
Microsoft
- C.
Dell
- D.
Nokia
- 294.True type fonts are
- A.
4 Bits
- B.
8 Bits
- C.
16 Bits
- D.
32 Bits
- 295.Open type fonts are
- A.
4 Bits
- B.
8 Bits
- C.
16 Bits
- D.
32 Bits
- 296.Open type fonts are same as Unicode?
- A.
True
- B.
False
- 297.Which of the following are true about Java Class Constructors?
- A.
They are used to initialize the data members
- B.
Their return type is void
- C.
Their accessibility is public
- D.
WE can have only one constructor for a class
- 298.Which one of the following is true regarding public static void main(String args[])
- A.
It is the driver function
- B.
WE can have two main functions for a class
- C.
The arguments of the main function are optional
- 299.SWAGAT (State Wide Attention on Grievances through Application of Technology) is the e-Governance program of?
- A.
Maharashtra
- B.
Gujarat
- C.
Kerala
- D.
UP
- 300.Which of the following HTML control is like ComboBox control of Java?
- A.
ComboOption
- B.
OptionType
- C.
Select
- D.
RadioButton
- 301.A radio button is defined by using which tag in HTML?
- A.
Radio
- B.
Radio Button
- C.
Input
- D.
Output
- 302.Which of the following is entry coltrolled loop?
- A.
Do while
- B.
While
- C.
For
- D.
Switch
- 303.Which of the following is exit coltrolled loop?
- A.
Do while
- B.
While
- C.
For
- D.
Switch
- 304.In case of nesting a Break statement will break the?
- A.
Innermost Loop
- B.
Outermost Loop
- C.
The loop in which break is placed
- D.
None of the above
- 305.Which of the following is a collection of objects of different types?
- A.
Object
- B.
Class
- C.
Blue Print
- D.
Method
- 306.This is the instantiation of a class?
- A.
Object
- B.
Method
- C.
Constructor
- D.
Destructor
- 307.Which of the following is the abbreviation of Hypertext Preprocessor?
- A.
HPML
- B.
HP
- C.
PHP
- D.
Apache
- 308.Which of the following are the selection options of a ListBox?( Select Three)
- A.
SINGLE_RANGE
- B.
SINGLE_SELECTION
- C.
SINGLE_INTERVAL_SELECTION
- D.
MULTIPLE_INTERVAL_SELECTION
- E.
MULTIPLE_RANGE
- 309.String object is immutable ?
- A.
True
- B.
False
- 310.StringBuffer object is immutable ?
- A.
True
- B.
False
- 311.What is the output of the following program? int a,b; String str="20"; a=Integer.parseInt(str); b=a+10; System.out.println(""+(a+b));
- A.
30
- B.
40
- C.
50
- D.
60
- 312.String str1,str2,str3; str1="1"; str2="0"; str3="100"; int a,b,c; str1=str1+str2; a=Integer.parseInt(str1); b=Integer.parseInt(str3); c=a+b; System.out.println(""+c); what is the value of c?
- A.
110
- B.
101
- C.
102
- D.
103
- 313.<i> will make a word?
- A.
Italicized
- B.
Underlined
- C.
Bold
- D.
Upper Case
- 314.String str="123"; StringBuffer sb=new StringBuffer(str); sb.reverse(); String str1=sb.toString(); String str2=str1+str; System.out.println(str2); What is the output of the above code?
- A.
123
- B.
321
- C.
123321
- D.
321123
- 315.What is a single word name for bulk mail?
- 316.Dropping a table will delete both table structure and data.
- A.
True
- B.
False
- 317.Once a table structure is created it can not be modified.
- A.
True
- B.
False
- 318.Alter table option can be used for which of the following?
- A.
Add row
- B.
Add Column
- C.
Remove Row
- D.
Remove Column
- 319.Which of the following tags are used with HTML tables?
- A.
Tr
- B.
Td
- C.
Th
- D.
Table
- E.
Ul
- F.
Hr
- G.
Tbody
Back to top