Related Questions
What is the correct answer?
4
Which of the following is a reason to model data?
A. Understand each user's perspective of data
B. Understand the data itself irrespective of the physical representation
C. Understand the use of data across application areas
What is the correct answer?
4
A relational database developer refers to a record as
What is the correct answer?
4
The rule that a value of a foreign key must appear as a value of some specific table is called a
A. Referential constraint.
D. Functional dependency.
What is the correct answer?
4
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
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
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
What is the correct answer?
4
_____clause is an additional filter that is applied to the result.
What is the correct answer?
4
The keyword to eliminate duplicate rows from the query result in SQL is
What is the correct answer?
4
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
A. Operationally, if Y is deleted, so is X
B. existence is dependent on Y.
C. Operationally, if X is deleted, so is Y.
D. Operationally, if X is deleted, & remains the same.
What is the correct answer?
4
Isolation of the transactions is ensured by
A. Transaction management
B. Application programmer
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
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
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
Union operator is a :
What is the correct answer?
4
The default level of consistency in SQL is
What is the correct answer?
4
Which of the following aggregate functions does not ignore nulls in its results?.
What is the correct answer?
4
What is data integrity?
A. It is the data contained in database that is non redundant.
B. It is the data contained in database that is accurate and consistent.
C. It is the data contained in database that is secured.
D. It is the data contained in database that is shared.
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
In E-R Diagram total participation is represented by
What is the correct answer?
4
The part of a database management system which ensures that the data remains in a consistent state is
A. authorization and integrity manager
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
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
What is the correct answer?
4
Which of the following is not a logical database structure?
What is the correct answer?
4
In a relational schema, each tuple is divided into fields called
What is the correct answer?
4
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
What is the correct answer?
4
____ table store information about database or about the system.
What is the correct answer?
4
Relational Algebra does not have
C. Aggregation operators.
What is the correct answer?
4
Grant and revoke are _____ statements.
What is the correct answer?
4
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
What is the correct answer?
4
Dependency preservation is not guaranteed in