| 1 |
In which situation does the problem of data inconsistency arise? |
Computer Science/Informatics Practices
Database and file systems |
Easy |
| 2 |
What is a database schema? |
Computer Science/Informatics Practices
Database and file systems |
Easy |
| 3 |
A school stores a student's phone number in the fee file, library file and transport file. Which limitation o… |
Computer Science/Informatics Practices
Database and file systems |
Medium |
| 4 |
In a file system, adding a new field to a file forces changes in every program that reads it. This limitation… |
Computer Science/Informatics Practices
Database and file systems |
Medium |
| 5 |
Which statement about a DBMS is correct? |
Computer Science/Informatics Practices
Database and file systems |
Hard |
| 6 |
A relation STUDENT has 5 attributes and 32 tuples. What is its degree? |
Computer Science/Informatics Practices
Relational data model |
Easy |
| 7 |
In the relational model, a single row of a relation is called a |
Computer Science/Informatics Practices
Relational data model |
Easy |
| 8 |
The set of all permissible values that an attribute can take is called its |
Computer Science/Informatics Practices
Relational data model |
Medium |
| 9 |
A table has degree 4 and cardinality 10. Three new rows are inserted and one column is dropped. What are the … |
Computer Science/Informatics Practices
Relational data model |
Medium |
| 10 |
Which of the following is NOT a property of a relation in the relational model? |
Computer Science/Informatics Practices
Relational data model |
Hard |
| 11 |
A relation has three candidate keys. How many alternate keys does it have once a primary key is chosen? |
Computer Science/Informatics Practices
Keys |
Easy |
| 12 |
Which constraint must a primary key always satisfy? |
Computer Science/Informatics Practices
Keys |
Easy |
| 13 |
In tables EMP(EmpNo, Name, DeptNo) and DEPT(DeptNo, DName), DeptNo in EMP is best described as |
Computer Science/Informatics Practices
Keys |
Medium |
| 14 |
In a SECTION table, RollNo repeats across classes, but each combination of Class and RollNo is unique. What i… |
Computer Science/Informatics Practices
Keys |
Medium |
| 15 |
A row is inserted into ORDERS with CustID = 'C9', but no customer with ID 'C9' exists in CUSTOMER, where Cust… |
Computer Science/Informatics Practices
Keys |
Hard |
| 16 |
Which relational algebra operation extracts only certain columns of a relation? |
Computer Science/Informatics Practices
Relational algebra |
Easy |
| 17 |
Relation R has degree 3 and cardinality 4; relation S has degree 2 and cardinality 5. What are the degree and… |
Computer Science/Informatics Practices
Relational algebra |
Easy |
| 18 |
A has 6 tuples and B has 4 tuples; 3 tuples are common and both are union compatible. How many tuples are in … |
Computer Science/Informatics Practices
Relational algebra |
Medium |
| 19 |
For union compatible relations A and B, what does A − B return? |
Computer Science/Informatics Practices
Relational algebra |
Medium |
| 20 |
Which statement about union compatibility is correct? |
Computer Science/Informatics Practices
Relational algebra |
Hard |