61. Which of the following arithmetic operators in ‘C’ requires a valid value as its operand ?
(A) *
(B) +
(C) ++
(D) %
Show Answer/Hide
62. What is the correct symbol for address operator in ‘C’ ?
(A) *
(B) #
(C) ^
(D) &
Show Answer/Hide
63. Which of the following is the correct symbol for logical OR operator in ‘C’?
(A) &&
(B) ++
(C) ||
(D) >>
Show Answer/Hide
64. Which of the following is the correct.symbol for bitwise XOR operator in ‘C’ ?
(A) ~
(B) <
(C) |
(D) ^
Show Answer/Hide
65. Which of the following is a formatted input function in ‘C’?
(A) getch ()
(B) scanf ()
(C) printf ()
(D) getchar ()
Show Answer/Hide
66. Which of the following standard header files in ‘C’ defines the function fscanf()?
(A) stdlib.h
(B) stdio.h
(C) limits.h
(D) studio.h
Show Answer/Hide
67. Which of the following, types of expressions is not allowed as Switch Expression in switch…case statement in ‘C’ ?
(A) char
(B) float
(C) enum
(D) int
Show Answer/Hide
68. Which of the following statements is not true about functions in ‘C’ programming ?
(A) A function can either return nothing or a single value only.
(B) ‘C’ supports recursive functions.
(C) A function can accept zero or more arguments.
(D) A function can be defined inside another function.
Show Answer/Hide
69. What will be the output produced by the following statement in a ‘C’ program ?
printf(“%x”, 64);
(A) 40
(B) 64
(C) 80
(D) x
Show Answer/Hide
70. What is the full form of SQL ?
(A) Standard Query Learning
(B) Structured Query Language
(C) Simple Query Language
(D) Simple Queueing Language
Show Answer/Hide
71. How many layers are there in ANSI/SPARC model of database architectus
(A) 5
(B) 3
(C) 4
(D) 6
Show Answer/Hide
72. Which of the following shapes is used to represent a relationship in ER diagram of a database ?
Show Answer/Hide
73. A ______ key consists of one or more columns of a database table used to uniquely identify the records of that table.
(A) secondary
(B) foreign
(C) super
(D) primary
Show Answer/Hide
74. The Cartesian product of two database tables having two columns and four rows each will result in a relation with ______ columns and ______ rows.
(A) 4, 16
(B) 4, 8
(C) 4, 4
(D) 2, 8
Show Answer/Hide
75. Which of the following constraints in relational databases is used to enforce referential integrity ?
(A) NOT NULL
(B) FOREIGN KEY
(C) UNIQUE
(D) PRIMARY KEY
Show Answer/Hide
76. Which of the following is a DDL SQL command ?
(A) UPDATE
(B) DELETE
(C) INSERT
(D) ALTER
Show Answer/Hide
77. The ______ database tables, contain all the rows which are common in both tables.
(A) Cartesian product
(C) intersection
(B) join
(D) union
Show Answer/Hide
78. Which of the following is the correct SQL query that fetches the different ‘surname’ from employee’ table without any duplicate values ?
(A) SELECT UNIQUE surname FROM employee
(B) SELECT DUPLICATE surname FROM employee
(C) SELECT DIFFERENT surname FROM employee
(D) SELECT DISTINCT surname FROM employee
Show Answer/Hide
79. Which of the following is not a Relational Database Management System ?
(A) Oracle
(B) MongoDB
(C) MySQL
(D) MS-SQL Server
Show Answer/Hide
80. What is 2’s compliment of the binary number 00110001 ?
(A) 01001111
(B) 11001111
(C) 01001110
(D) 11001110
Show Answer/Hide