_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
- The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
- The language that requires a user to specify the data to be retrieved without specifying exactly how…
- The size of a data item is called its _______, which can be a field of some record or may be a larger…
- Relationships among relationships can be represented in an-E-R model using
- Which one is true statement :
- An outstanding functionality of SQL is its support for automatic_____ to the target data.
- In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
- Which of the following is not a logical database structure?
- Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
- Which one is correct statement?Logical data independence provides following without changing application…
- Tree structures are used to store data in
- Which is the best file organization when data is frequently added or deleted from a file?
- Which of the following addressing modes permits relocation without any change over in the code?
- Which of the following aggregate functions does not ignore nulls in its results?.
- The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
- Shadow paging has
- ………………… approach reduces time and effort required for design…
- Union operator is a :
- By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
- When an E-R diagram is mapped to tables, the representation is redundant for
- A list consists of last names, first names, addresses and pin codes. If all people in the list have…
- operator is used to compare a value to a list of literals values that have been specified.
- A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
- The transactions like adding an employee, enrolling a student in a course are examples of _______
- The data models defined by ANSI/SPARC architecture are
- The _______ is a set of programs to use and / or modify this data.
- A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
- As per equivalence rules for query transformation, selection operation distributes over
- DBMS is a collection of _____ that enables user to create and maintain a database.
- The relational model is based on the concept that data is organized and stored in two-dimensional tables…