Related Questions
What is the correct answer?
4
It is an abstraction through which relationships are treated as higher level entities
What is the correct answer?
4
The full form of GUI is _________
A. Government Union Internet
B. Graphical Unit Interface
C. Graphical User Interface
D. Graphical University Interface
What is the correct answer?
4
Data items grouped together for storage purposes are called a
What is the correct answer?
4
The normal form that is not necessarily dependency preserving is
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
Wait-for graph is used for
A. detecting view serializability.
B. detecting conflict serializability.
What is the correct answer?
4
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
What is the correct answer?
4
Relational Algebra is
A. Data Definition Language .
C. Procedural query Language
What is the correct answer?
4
In E-R Diagram total participation is represented by
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
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
What is the correct answer?
4
The collection of information stored in a database at a particular moment is called as ......
B. instance of the database
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
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
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
What is the correct answer?
4
As per equivalence rules for query transformation, selection operation distributes over
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
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
In SQL, testing whether a subquery is empty is done using
What is the correct answer?
4
In an E-R diagram double lines indicate
B. Multiple participation.
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
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
_____is a full form of SQL.
A. Standard query language
B. Sequential query language
C. Structured query language
D. Server side query language
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
Shadow paging has
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
_____ command can be used to modify a column in a table
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
The metadata is created by the
What is the correct answer?
4
………………… approach reduces time and effort required for design and lesser risk in database management.
A. Single global database