Related Questions
What is the correct answer?
4
______ keyword is used to find the number of values in a column.
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
An advantage of views is
C. Hiding of complex queries
What is the correct answer?
4
The normalization was first proposed by .
What is the correct answer?
4
Which of the following is not comparison operator?
What is the correct answer?
4
Checkpoints are a part of
D. uthorization measures.
What is the correct answer?
4
If the closure of an attribute set is the entire relation then the attribute set is a
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
Which of the following is not a recovery technique?
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
In E-R Diagram total participation is represented by
What is the correct answer?
4
Which of the following statement on the view concept in SQL is invalid?
A. All views are not updateable
B. The views may be referenced in an SQL statement whenever tables are referenced.
C. The views are instantiated at the time they are referenced and not when they are defined.
D. The definition of a view should not have GROUP BY clause in it.
What is the correct answer?
4
Which of the following is not a characteristic of a relational database model?
C. Complex logical relationship
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
For using a specific database …………… command is used.
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
As per equivalence rules for query transformation, selection operation distributes over
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
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 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 metadata is created by the
What is the correct answer?
4
For correct behaviour during recovery, undo and redo operation must be
What is the correct answer?
4
If an entity can belong to only one lower level entity then the constraint is
What is the correct answer?
4
_____ command can be used to modify a column in a table
What is the correct answer?
4
In a relational schema, each tuple is divided into fields called
What is the correct answer?
4
____specifies a search condition for a group or an aggregate.
What is the correct answer?
4
The default level of consistency in SQL is
What is the correct answer?
4
The normal form that is not necessarily dependency preserving is
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
Relational Algebra does not have
C. Aggregation operators.