Related Questions
What is the correct answer?
4
A transaction is in state after the final statement has been executed.
What is the correct answer?
4
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
What is the correct answer?
4
Union operator is a :
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
Precedence graphs help to find a
A. Serializable schedule.
C. Deadlock free schedule.
What is the correct answer?
4
Manager salary details are hidden from the employee .This is
A. Conceptual level data hiding.
B. External level data hiding.
C. Physical level data hiding.
What is the correct answer?
4
_____ command can be used to modify a column in a table
What is the correct answer?
4
The values of the attribute describes a particular
What is the correct answer?
4
The metadata is created by the
What is the correct answer?
4
Data items grouped together for storage purposes are called a
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 relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
What is the correct answer?
4
The _______ is a set of programs to use and / or modify this data.
What is the correct answer?
4
E-R Modeling is achieved by using ____ diagrams
What is the correct answer?
4
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
B. Multi-valued dependency
What is the correct answer?
4
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
What is the correct answer?
4
The transactions like adding an employee, enrolling a student in a course are examples of _______
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
Protection of data from unauthorized Disclosure results in loss of _______
D. Discretionary Security
What is the correct answer?
4
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
A. Oval; An oval with an underlined attribute
B. Circle; A circle with bolded attribute inside it
C. Diamond; A bolded attribute
D. Square; An attribute within the square
What is the correct answer?
4
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
What is the correct answer?
4
_____ First proposed the process of normalization.
What is the correct answer?
4
For correct behaviour during recovery, undo and redo operation must be
What is the correct answer?
4
Which of the following is not a consequence of non-normalized database?
What is the correct answer?
4
Grant and revoke are _____ statements.
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
If a transaction T has obtained an exclusive lock on item Q, then T can
D. write Q but not read Q
What is the correct answer?
4
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
What is the correct answer?
4
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.
A. UPDATE S CITY = KANPUR WHERE SNO=S1
B. UPDATE S SET CITY = KANPUR FOR SNO=S1
C. UPDATE S SET CITY = KANPUR WHERE SNO=S1
D. UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
What is the correct answer?
4
______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
A. Domain Integrity Constraints
B. Referential Integrity Constraints
D. Entity Integrity Constraints