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
- Protection of data from unauthorized Disclosure results in loss of _______
- What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
- Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
- Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
- The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
- DBMS helps achieve
- The _______ is a set of programs to use and / or modify this data.
- Isolation of the transactions is ensured by
- Immediate database modification technique uses
- Which of the following constitutes a basic set of operations for manipulating relational data?
- The ______ indexes are forced to store only record IDs in the data structure and require at least one…
- _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
- Cascading rollback is avoided in all protocol except
- When an E-R diagram is mapped to tables, the representation is redundant for
- An advantage of the database management approach is
- It is an abstraction through which relationships are treated as higher level entities
- Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
- Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
- A ______ module is typically designed so that it will run on a user workstation or personal computer.
- ______ keyword is used to find the number of values in a column.
- The common column is eliminated in
- _____clause is an additional filter that is applied to the result.
- The part of a database management system which ensures that the data remains in a consistent state is
- _____ First proposed the process of normalization.
- The data in the database at a particular moment of time is called the _______
- In SQL the statement select * from R, S is equivalent to
- ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
- An outstanding functionality of SQL is its support for automatic_____ to the target data.
- Which normal form is considered adequate for normal relational database design?
- The normalization was first proposed by .