Subject: Information Technology
(1) All Questions are compulsory
(2) Maximum time allowed for the test is 60 minutes
(3) Each CORRECT answer will be awarded 1 mark
(4) 25 per cent marks will be deducted for each wrong answer
Sample Questions for Test Please tick (P) the correct one:
Q 1. You are designing the properties, methods, and events for components in a new VB application. There is a requirement that a customer have an ID number. How should you design the ID number?
a) as an event b) as a method c) as a property d) as a component
Q 2. When initializing the random-number generator using the Randomize statement, what happens if a number isn't supplied as argument?
a) Visual Basic generates an error b) the random-number generator is not initialized
c) the random-number generator is initialized using the current value of the system timer
d) the default value of 10 is used in place of the number
Q 3. Which of these statements is incorrect:
a) ActiveX DLLs are in-process servers b) ActiveX EXEs are out-of-process servers
c) ActiveX DLLs need to use marshalling
d) ActiveX EXEs run as seperate processes
Q. 4. Examine the following code:
public class Quiz2_3 {
public static void main( String[] args) {
int x = 010;
int y = 0x10;
int z = 10;
System.out.println(x+y+z);
}
}
Which one of the following correctly describes the behaviour when this program is compiled?
a) Compilation is successful and the output is 30.
b) Compilation is successful and the output is 36.
c) Compilation is successful and the output is 34.
d) The compiler rejects the expression y=0x10 because letters of the alphabet are not allowed in numeric constants.
e) The compiler rejects the expression y = 0x10 because a hexadecimal value cannot be assigned to an int variable.
Q5. On an operating system that treats filenames as case-sensitive, which of the following declarations are valid for a class for which the source is stored in the file Fred.java ? Select as many as apply :
a) package myPackage;
public class Fred{
Static void main( String[] args) {
/* body of Fred.main */
}
}
class Joe {
// body of class Joe
b) package myPackage;
public class FRED {
// body of class FRED
}
c) public class Fred {
int month = 1;
int day = 21;
}
d) Static void Fred.main(String[] args) {
//body of Fred.main }
6. Which of the following is not an advantage of table partioning?
a) Partition improves the performance of queries
b) It reduces amount of sorting required c) Both a & b d)None of these
Q.7. What Oracle package can be used to set a role for a user dynamically within an anonymous PL/SQL block?
a) DBMS_ROLE b) DBMS_SESSION c) DBMS_USER
d) DBMS_UTILITY e) Oracle does not provide a package for this.
Q 8. The Program Global Area (PGA) contains ALL of the following except:
a) Sort Area b) System Change Number (SCN) c) Session Information d) Cursor state
Q. 9. What PL/SQL statements ensure that all database changes brought about by SQL operations are either made permanent or undone at the same time (choose all that apply):
a) CANCEL b) CONFIRM c) None d) COMMIT e) ROLLBACK
Q10. Which of the following correctly describe the restrictions on the use of LONG columns (choose all that apply):
a). You cannot create an object type with a LONG attribute.
b). A table can contain only one LONG column.
c). LONG columns cannot appear in WHERE clauses.
d). LONG columns cannot be indexed. e). All the Above
Q.11. Which one of the following uses the correct syntax to include an applet called ButtonText in an HTML page?
a).
b).