BANKING COMPUTER AWARENESS QUESTIONS | bank,ssc,railway,upsc,mppsc,engineering,GATE

 DBMS QUESTIONS

 

1:The users who use easy-to-use menu are called

A.	Sophisticated end users
B.	Naïve users.
C.	Stand-alone users.
D.	Casual end user
	Answer
	Option: B

2:    Which database level is closest to the users?

A.	External
B.	Internal
C.	Physical
D.	Conceptual
	Answer
	Option: A

3:   Which are the two ways in which entities can participate in a relationship?

A.	Passive and active
B.	Total and partial
C.	Simple and Complex
D.	All of the above
	Answer
	Option: B

4:   The result of the UNION operation between R1 and R2 is a relation that includes

A.	All the tuples of R1
B.	All the tuples of R2
C.	All the tuples of R1 and R2
D.	All the tuples of R1 and R2 which have common columns
	Answer Option: C

5:    A set of possible data values is called

A.	Attribute
B.	Degree.
C.	Tuple.
D.	Domain.
	Answer
	Option: D 6:   Which of the operations constitute a basic set of operations for manipulating relational data? A. Predicate calculus B. Relational calculus C. Relational algebra D. None of the above Answer Option: C 7:   Which of the following is another name for weak entity? A. Child B. Owner C. Dominant D. All of the above Answer  Option: A 8:   Which of the following database object does not physically exist? A. Base table B. Index C. View D. None of the above Answer  Option: C 9:   NULL is A. The same as 0 for integer B. The same as blank for character C. The same as 0 for integer and blank for character D. Not a value Answer  Option: D 10:    Which of the following is record based logical model? A. Network Model B. Object oriented model C. E-R Model D. None of these Answer  Option: A 11.A data dictionary is a special file that contains: A. The name of all fields in all files. B. The width of all fields in all files. C. The data type of all fields in all file D. All of the above   Answer     Option: D 12:    A file manipulation command that extracts some of the records from a file is called A. SELECT B. PROJECT C. JOIN D. PRODUCT   Answer     Option: A 13:    A primary key is combined with a foreign key creates A. Parent-Child relationship between the tables that connect them B. Many to many relationship between the tables that connect them. C. Network model between the tables that connect them. D. None of the above   Answer     Option: A 14:    In E-R Diagram derived attribute are represented by A. Ellipse B. Dashed ellipse C. Rectangle D. Triangle   Answer     Option: B 15:   Cross Product is a: A. Unary Operator B. Ternary Operator C. Binary Operator D. Not an operator   Answer     Option: C