IBPS SO IT DBMS

#Model_Paper_1_fb_com_bankibpssoit

Student(ID, name, dept name, tot_cred) In this query which attribute form the primary key? a) Name b) Dept c) Tot_cred d) ID [https://bankibpssoit.blogspot.in]

Which one of the following is a procedural language ? a) Domain relational calculus b) Tuple relational calculus c) Relational algebra [https://bankibpssoit.blogspot.in] d) Query language

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple. a) Select b) Join [https://bankibpssoit.blogspot.in] c) Union d) Intersection

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match. a) Join b) Cartesian product [https://bankibpssoit.blogspot.in] c) Intersection d) Set difference

The _______operation performs a set union of two “similarly structured” tables a) Union [https://bankibpssoit.blogspot.in] b) Join c) Product d) Intersect

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is a) Join b) Projection c) Select [https://bankibpssoit.blogspot.in] d) Union

The _______ operator takes the results of two queries and returns only rows that appear in both result sets. a) Union b) Intersect [https://bankibpssoit.blogspot.in] c) Difference d) Projection

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys. a) Schema diagram [https://bankibpssoit.blogspot.in] b) Relational algebra c) Database diagram d) Schema flow

The _________ provides a set of operations that take one or more relations as input and return a relation as an output. a) Schematic representation b) Relational algebra [https://bankibpssoit.blogspot.in] c) Scheme diagram d) Relation flow