Welcome to TestAdda

Please wait....

Loading
DBMS Short Test 2
|
Mark For Review

In order to maintain the consistency during transactions database provides

|
Mark For Review

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.

|
Mark For Review

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.

|
Mark For Review

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

|
Mark For Review

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

|
Mark For Review

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

|
Mark For Review

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

|
Mark For Review

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

|
Mark For Review

Which one of the following is a procedural language ?

|
Mark For Review

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

|
Mark For Review

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

|
Mark For Review

The tuples of the relations can be of ________ order.

|
Mark For Review

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

|
Mark For Review

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.

|
Mark For Review

Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?

|
Mark For Review

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?

|
Mark For Review

In case of any shut down during transaction before commit which of the following statement is done automatically ?

|
Mark For Review

Consider the following action: Transaction…..
Commit;
Rollback;
What does Rollback do?

|
Mark For Review

In order to undo the work of transaction after last commit which one should be used ?

|
Mark For Review

Which of the following makes the transaction permanent in the database ?

|
Mark For Review

A _________ consists of a sequence of query and/or update statements.

|
Mark For Review

Updates that violate __________ are disallowed .

|
Mark For Review

Insert into instructor values (10211, ’Smith’, ’Biology’, 66000); What type of statement is this ?

|
Mark For Review

Delete from r; r – relation This command performs which of the following action ?

|
Mark For Review

To remove a relation from an SQL database, we use the ______ command.

|
Mark For Review

An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces .

|
Mark For Review

The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

|
Mark For Review

Select * from employee What type of statement is this?

|
Mark For Review

Create table employee (name varchar ,id integer) What type of statement is this ?

|
Mark For Review

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

TestAdda OMR