DBMS
| Description: DBMS Database ConceptsRelational Functions of DBMSSQL | |
| Number of Questions: 15 | |
| Created by: Jatin Goyal | |
| Tags: DBMS Database Concepts Relational Functions of DBMS SQL |
The process of assigning similar objects/entities to object classes/entity type is known as
A subclass can be in more than one class or subclass relationship. What is the name of this process?
To filter the tuples of a relation on which it is applied based on some condition mentioned is called _________.
How can you define a weak entity type?
Which of the following terms describe(s) strong entity type?
Which of the following terms is used to describe minimal super key?
With reference to a table which key resides in another table?
Which key or part of that key cannot contain a null value?
From which of the following keys does a database designer choose a primary key?
Which of the following queries corresponds to finding the name and number of employees in each department?
Which predicate is not use in SQL?
SELECT ename FROM emp WHERE ename LIKE \'S%\'; Which of the following names can be selected by the above query?
Which of the following commands makes the updates performed by the transaction permanent in the database?
SELECT ename FROM emp WHERE ename LIKE '%A_E%'; Which name from the following names can selected by the above query?
Which query among following can give more than one name (employee name or ename)?