Related Questions
What is the correct answer?
4
Immediate database modification technique uses
D. Neither undo nor redo.
What is the correct answer?
4
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
What is the correct answer?
4
Which two files are used during operation of the DBMS?
A. Query languages and utilities
B. DML and query language
C. Data dictionary and transaction log
D. Data dictionary and query language
What is the correct answer?
4
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
What is the correct answer?
4
An advantage of views is
C. Hiding of complex queries
What is the correct answer?
4
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
What is the correct answer?
4
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
What is the correct answer?
4
The data models defined by ANSI/SPARC architecture are
A. Conceptual, physical and internal
B. Conceptual, view and external
C. Logical, physical and internal
D. Logical, physical and view
What is the correct answer?
4
In an ER model,_____ is described in the database by storing its data.
What is the correct answer?
4
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
What is the correct answer?
4
Relations produced from an E-R model will always be
What is the correct answer?
4
Grant and revoke are _____ statements.
What is the correct answer?
4
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
What is the correct answer?
4
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
A. It will result in a deadlock situation.
B. It will immediately be rejected.
C. It will immediately be granted.
D. It will be granted as soon as it is released by A .
What is the correct answer?
4
____ table store information about database or about the system.
What is the correct answer?
4
In SQL the word natural can be used with
What is the correct answer?
4
An advantage of the database management approach is
A. data redundancy increases
B. data is dependent on programs
C. data is integrated and can be accessed by multiple programs
What is the correct answer?
4
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
What is the correct answer?
4
………………… approach reduces time and effort required for design and lesser risk in database management.
A. Single global database
What is the correct answer?
4
HSAM stands for ……….
A. Hierarchic Standard Access Method
B. Hierarchic Sequential Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
What is the correct answer?
4
The data in the database at a particular moment of time is called the _______
What is the correct answer?
4
The set of all values that can be taken by the attribute is called as _______ of the attribute.
What is the correct answer?
4
SQL server stores index information in the _____system table
What is the correct answer?
4
In 2NF
A. No functional dependencies (FDs) exist.
B. No multivalued dependencies (MVDs) exist.
D. No partial MVDs exist.
What is the correct answer?
4
A top-to-bottom relationship among the items in a database is established by a
What is the correct answer?
4
A ______ module is typically designed so that it will run on a user workstation or personal computer.
What is the correct answer?
4
A _____ is used to define overall design of the database
B. data definition language
What is the correct answer?
4
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
What is the correct answer?
4
DBMS is a collection of _____ that enables user to create and maintain a database.
What is the correct answer?
4
_____is a full form of SQL.
A. Standard query language
B. Sequential query language
C. Structured query language
D. Server side query language