Q. 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.

View solution

Q. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

View solution

Q. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

View solution

Q. The _______operation performs a set union of two “similarly structured” tables

View solution

Q. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

View solution

Q. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

View solution

Q. Which one of the following is a procedural language ?

View solution

Q. Student(ID, name, dept name, tot_cred)
In this query which attribute form the primary key?

View solution

Q. Using which language can a user request information from a database ?

View solution

Q. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

View solution

Q. The tuples of the relations can be of ________ order.

View solution

Q. A domain is atomic if elements of the domain are considered to be ____________ units.

View solution

Q. Department (dept name, building, budget) and Employee (employee_id , name, dept name,salary)
Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.

View solution

Q. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________

View solution

Q. Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

View solution

Q. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

View solution

Q. The term attribute refers to a ___________ of a table.

View solution

Q. The term _______ is used to refer to a row.

View solution

Q. A ________ in a table represents a relationship among a set of values.

View solution

Q. A relational database consists of a collection of

View solution