DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
- Manager salary details are hidden from the employee .This is
- ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
- A data type or format is specified for each _________
- A _____ is used to define overall design of the database
- The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
- For correct behaviour during recovery, undo and redo operation must be
- Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
- Data items grouped together for storage purposes are called a
- A top-to-bottom relationship among the items in a database is established by a
- When an E-R diagram is mapped to tables, the representation is redundant for
- A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
- _____ database is used to provide statistical information or summaries of values based on various criteria.
- ______ keyword is used to find the number of values in a column.
- Which of the following is a reason to model data?
- The statement that is executed automatically by the system as a side effect of the modification of the…
- The clause alter table in SQL can be used to
- Which of the following is not comparison operator?
- approach reduces time and effort required for design and lesser risk in database management.
- If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
- A logical schema
- ______is a special type of integrity constraint that relates two relations & maintains consistency across…
- Data independence means
- In E-R Diagram total participation is represented by
- Change Staff table by removing default of Assistant for position column
- E-R Modeling is achieved by using ____ diagrams
- Drop Table cannot be used to drop a table referenced by a ______ constraint.
- The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
- Cascading rollback is avoided in all protocol except
- In SQL, testing whether a subquery is empty is done using
- SQL server stores index information in the _____system table