A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
- Union operator is a :
- DBMS is a collection of _____ that enables user to create and maintain a database.
- The size of a data item is called its _______, which can be a field of some record or may be a larger…
- A _____ is a logical unit of database processing that includes one or more data access operations that…
- ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
- Which one is true statement :
- In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
- In multiple granularity of locks SIX lock is compatible with
- Which of the following is not a logical database structure?
- Which of the following relational algebraic operations is not from set theory?
- Which of the following is a reason to model data?
- An advantage of the database management approach is
- The data models defined by ANSI/SPARC architecture are
- In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
- The clause alter table in SQL can be used to
- A list consists of last names, first names, addresses and pin codes. If all people in the list have…
- SQL server stores index information in the _____system table
- Which of the following aggregate functions does not ignore nulls in its results?.
- For using a specific database …………… command is used.
- Which is the best file organization when data is frequently added or deleted from a file?
- _____ is a utility to capture a continuous record of server activity and provide auditing capability.
- Relational Algebra is
- Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
- Grant and revoke are _____ statements.
- The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
- Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
- ______is a special type of integrity constraint that relates two relations & maintains consistency across…
- ………………… approach reduces time and effort required for design…
- The full form of GUI is _________
- A top-to-bottom relationship among the items in a database is established by a