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
Correct Answer :
C. Data dictionary and transaction log
Related Questions
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
jamming
password
documentation
record lock
Relational Algebra is
Data Definition Language .
Meta Language
Procedural query Language
None of the above
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
distinct values
cannot have NULL
both (A) & (B)
same as primary key
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
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
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
If the closure of an attribute set is the entire relation then the attribute set is a
superkey
candidate key
primary key
not a key
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
For correct behaviour during recovery, undo and redo operation must be
Commutative
Associative
idempotent
distributive
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain