PGT Computer Science (Level-3), (HTET Practice MCQs) (Part-III)Total Questions: 10061. What is the effect of the following C code?A. It prints 1, 1.5, 2, 2.5, 3, 3.5, 4, 4.5, 5, and stopsB. It prints 1, 2, 3, 4, 5, and stopsC. It prints 1, 2, 3, 4, 5, and repeats foreverD. It prints 1, 1, 1, 1, 1, and repeats foreverCorrect Answer: D. It prints 1, 1, 1, 1, 1, and repeats forever62. Consider the following declaration in C:char a[]; char *p; Which of the following statement is not a valid statement?A. p = a;B. p = a + 2;C. a = p;D. p = & a[2];Correct Answer: C. a = p;63. Consider the following C code:{int a = 5, b = 9; float r; r = b/a:} What is the value of r?A. 1.8B. 1.0C. 2.0D. 0.0Correct Answer: B. 1.064. Function overloading is a concept in which:A. a function is used to implement lots of tasks at the same time.B. a function is called too many number of times by another function.C. a function provides common interface to the user to carry out possibly different functions in each call.D. a function is computationally too expen-sive for the system to handle.Correct Answer: C. a function provides common interface to the user to carry out possibly different functions in each call.65. Which of the following is true?A. A "static" member of a class cannot be inherited by its derived class.B. A "static" member of a class can be initialized only within the class it is a member of.C. A "static" member of a class can be initialized before an object of that class is created.D. Since "static" member of a class is actually a global element, it does not require a class/object qualifier to access it independently of class/object.Correct Answer: C. A "static" member of a class can be initialized before an object of that class is created.66. A superkey for an entity consits of:A. one attribute onlyB. at least two attributesC. at most two attributesD. one or more attributesCorrect Answer: D. one or more attributes67. Which of the following set of keywords constitutes a mapping in SQL?A. SELECT, FROM, TABLEB. SELECT, FROM, WHEREC. CONNECT, TABLE, CREATED. SELECT, TABLE, INSERTCorrect Answer: B. SELECT, FROM, WHERE68. If a relation is in 2NF then:A. every candidate key is a primary keyB. every non-prime attribute is fully functionally dependent on each relation keyC. every attribute is functionally independentD. every relational key is a primary keyCorrect Answer: B. every non-prime attribute is fully functionally dependent on each relation key69. Which of the following is true?A. A relation in 3NF is always in BCNFB. A relation in BCNF is always in 3NFC. BCNF and 3NF are totally differentD. A relation in BCNF is in 2NF but not in 3NFCorrect Answer: B. A relation in BCNF is always in 3NF70. Which of the following is true?Consider the query: SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEMI_MARK = SEM2_MARK?;A. It gives the name of the student whose marks in semester 1 and semester 2 are same.B. It gives all the names and roll nos of those students whose marks in semester 1 and semester 2 are same.C. It gives the names of all the students whose marks in semester 1 and semester 2 are same.D. It gives roll numbers of all students whose marks in semester 1 and semester 2 are same.Correct Answer: C. It gives the names of all the students whose marks in semester 1 and semester 2 are same.Submit Quiz« Previous12345678910Next »
