Archive

Tag Archives: Relational database management system

There are two sections
1.technical qs -20
2.apptitute qs -25

Technical

1.Largest integer can be written from 8 bits is
a. 256
b. 255
c. 8
d. 10

2. change a hexadecimal no to octal

3. how many address lines needed to pass 1MB of data.

4. What is the function of the modulus operator in most language.
a) Sets a system environmental value to either base 10 ,base 8 or base 16
b) Returns the remainder after dividing one number by another
c) Returns the first argument raised to the second argument power
d) Prints out the actual code written to standard output rather than executing the code

5. class professor{}
class teacher: public virtual professor{};
class researcher: public virtual professor {}
class myprofessor :public teacher,public researcher {};
Referring to the sample code above ,if an object of class myprofessor were created ,how many instances of professor will it contain?
a) 0
b) 1
c) 2
d) 3

6. Modern RDBMS s perfom the following the following functionc except __.
a) Force column values in one table to match any of the values in a column of another table
b) Automatically replicate data on another server
c) Automatically create new indexes based on query history
d) Prevent unauthorized users from accessing data at the firls level

7. RDBMS triggers are typically bound to a ______and one or more
a) Table,SQL statement types
b) SQL statement type,user
c) Column,rows
d) User, table

8. What relationship is resolved by an intersecting or associative entity ?
a) Recursive
b) Mandatory one to one
c) Many to Many
d) One to One

9. Make a copy of file upper in the directory two levels up .
a) jump -2 upper
b) cp upper ../..(answer)
c) cp upper -2/
d) None of the above

10. i = 0;
j = 0;
for(j=1;j<10;j++)
i=i+1;

In the (generic) code segment above what will be the value of the variable i at completion ?
a) 0
b) 1
c) 3
d) 9
e) 10

11. Which of the following statements is true when a derivation inherits both a virtual and non-virtual instance of a base class ?
a) Each derived class object has base objects only from the non virtual instance
b) Each base class object has derived objects only from the non-virtual instance
c) Each derived class object has base objects only from the virtual instance
d) Each derived class object has a base object from the virtual instance and a base object from non-virtual instance.

12. class Word
{
public:
Word(const char*,int = 0);
};
Referring to the sample code above what is the minimum number of arguments required to call the constructor ?
a) 0
b) 1
c) 2
d) 3

13. What is the function of the modulus operator in most languages ?

a)   Sets a system environmental value to either base 10 ,base 8 or base 16
b)    Returns the remainder after dividing one number by another
c)    Returns the first argument raised to the second argument power
d)    Prints out the actual code written to standard output rather than executing the code

14. class professor{}
class teacher: public virtual professor{};
class researcher: public virtual professor {}
class myprofessor :public teacher,public researcher {};

15. Referring to the sample code above, if an object of class “myprofessor” were created ,how many instances of professor will it contain?
a) 0
b)  1
c)  2
d) 3

16. Modern RDBMS’s perfom the following the following functionc except
a) Force column values in one table to match any of the values in a column of another table
b) Automatically replicate data on another server
c) Automatically create new indexes based on query history
d) Prevent unauthorized users from accessing data at the firls level

17. Which is not the characteristics of a view ?
a)  Consumes Disk space for data
b) Multiple tables
c) Multiple rows
d)  Updateable

18.RDBMS triggers are typically bound to a ____and one or more ____
a)  Table,SQL statement types
b)  SQL statement type,user
c)   Column,rows
d)  User, tables

19. What relationship is resolved by an “intersecting” or “associative” entity ?
a)   Recursive
b)  Mandatory one to one
c)   Many to Many
d)   One to One
20.

Make a copy of file “upper” in the directory two levels up .
a)  jump -2 upper
b)  cp upper ../..
c)  cp upper -2/
d)  None of the above

Aptitude Section.
21. Question like A is engg. B is doctor C is artist etc then few condition related to them  you have give answer to 4 or 5 qs on these conditions .
22.  same as above with different data and conditions.
23.   3 qs onfinding error in english sentences
24.  If father is three times as old as son . 5 years ago he was 4 times age of his son what is son age.
25. Same as above but now daughter and mother joined in and age in question is that of daughter.
26. A figure is given find no of traingles in this figure
27. Same as above but figure is diffrent and find no of squares and triangles.

1. Which of the following best explains life cycle of Defect ?
a) Defect Found -> Defect Logged -> Defect Debugged -> Defect Closed -> Defect Rechecked
b) Defect Found -> Defect Debugged -> Defect Reported -> Defect Rechecked -> DefectClosed
c) Defect Debugged -> Defect Found -> Defect Closed -> Defect Reported -> DefectRechecked
d) Defect Found -> Defect Logged -> Defect Debugged -> Defect Rechecked -> Defect Closed

2. Which group does Winrunner ,Load Runner ,SQA Suite fall under ?
a) Databases
b) Automated Test Tools
c) Operating Systems
d) Rapid Application Development Tool

3.  i = 0;
j = 0;
for(j=1;j<10;j++)
i=i+1;
In the (generic) code segment above what will be the value of the variable i at completion ?
a) 0
b) 1
c) 3
d) 9

4. Which of the following statements is true when a derivation inherits both a virtual and non-virtual instance of a base class ?
a) Each derived class object has base objects only from the non virtual instance
b) Each base class object has derived objects only from the non-virtual instance
c) Each derived class object has base objects only from the virtual instance
d) Each derived class object has a base object from the virtual instance and a base object from non-virtual instance.

5.  class Word
{
public:
Word(const char*,int = 0);
};
Referring to the sample code above what is the minimum number of arguments required to call the constructor ?
a) 0
b) 1
c) 2
d) 3

6. Which one of the following represents a correct and safe declaration of NULL ?
a) typedef((void *)0) NULL;
b) typedef NULL(char *)0;
c) #define NULL((void *)0)
d) #define NULL((char*)0)

7. #include <iostraem>
Referring to the sample code above ,which of the following could you use to make the standars I/O Stream classes accessible without requiring the scope resolution operator ?
a) using namespace std::iostream
b) using namespace std;
c) using namespace iostream ;
d) using iostream;

8. Which one of the following statements allocates enough space to hold an array of 10 integers that are initialized to 0 ?
a) int *ptr = (int *) calloc(10,sizeof(int));
b) int *ptr = (int *) alloc( 10*sizeof(int));
c) int *ptr = (int *) malloc( 10*sizeof(int));
d) int *ptr = (int *)calloc(10*sizeof(int));

9. What function will read a specified number of elements from a file ?
a) fread()
b) readfile()
c) fileread()
d) gets()

10. What is the largest value an integer can hold in a Standard C compiler ?
a) 32767
b) 65536
c) 2147483647
d) INT_MAX

11. With every use of memory allocation function should be used to release allocated memory which is no longer needed ?
a) dropmem()
b) dealloc()
c) release()
d) free()

12.  int a=1;
int ab=4;
int main()
{
int b=3,a=2;
printf(“%i*/%i*/%*/i”,a,b,ab);
}

13.  kernal execute the first process when system is start—
ans :- init();

14. process id of kernal
(a) 1
(b) 0
(c) 2
(d) none

15.  Which one of the following represents a correct and safe declaration of NULL ?
a) typedef((void *)0) NULL;
b) typedef NULL(char *)0;
c) #define NULL((void *)0)
d) #define NULL((char*)0)

16. Which one of the following statements allocates enough space to hold an array of 10 integers that are initialized to 0 ?
a) int *ptr = (int *) calloc(10,sizeof(int));
b) int *ptr = (int *) alloc( 10*sizeof(int));
c) int *ptr = (int *) malloc( 10*sizeof(int));
d) int *ptr = (int *)calloc(10*sizeof(int));.