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

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. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________

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. A domain is atomic if elements of the domain are considered to be ____________ units.

View solution

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

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. Using which language can a user request information from a database ?

View solution

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

View solution

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

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. 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 performs a set union of two “similarly structured” tables

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 _______ operator takes the results of two queries and returns only rows that appear in both result sets.

View solution

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 _________ provides a set of operations that take one or more relations as input and return a relation as an output.

View solution