Which two files are used during operation of the DBMS?
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
Also checkout these categories
Software Engineering MCQ Reproductive System MCQ Electrostatics MCQ Additional Chemistry (Inorganic) MCQ Change of State MCQ Microsoft Word MCQ Choosing the correct sentence MCQ Phylum - Pisces MCQ Multimedia and Graphics MCQ Odd Man Out MCQ s-Block Element MCQ Bio-Chemistry MCQ
- Data items grouped together for storage purposes are called a
- Union operator is a :
- Immediate database modification technique uses
- Which of the following constitutes a basic set of operations for manipulating relational data?
- ____specifies a search condition for a group or an aggregate.
- Isolation of the transactions is ensured by
- A logical schema
- _____ command can be used to modify a column in a table
- The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
- operator is used to compare a value to a list of literals values that have been specified.
- DFD stands for
- If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship…
- Checkpoints are a part of
- An outstanding functionality of SQL is its support for automatic_____ to the target data.
- In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
- The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
- Which of the following is a reason to model data?
- Tree structures are used to store data in
- Drop Table cannot be used to drop a table referenced by a ______ constraint.
- Which of the following is true for network structure?
- For correct behaviour during recovery, undo and redo operation must be
- As per equivalence rules for query transformation, selection operation distributes over
- The middleware databases in which the business rules act are applicable to _______ tier architectures
- In an E-R diagram double lines indicate
- DBMS is a collection of _____ that enables user to create and maintain a database.
- The ______ indexes are forced to store only record IDs in the data structure and require at least one…
- Which of the following ensures the atomicity of the transaction?
- A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
- The size of a data item is called its _______, which can be a field of some record or may be a larger…
- Which one is true statement :