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
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
DBMS is a collection of _____ that enables user to create and maintain a database.
In an ER model,_____ is described in the database by storing its data.
It is an abstraction through which relationships are treated as higher level entities
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
The common column is eliminated in
approach reduces time and effort required for design and lesser risk in database management.
Protection of data from unauthorized Disclosure results in loss of _______
The set of all values that can be taken by the attribute is called as _______ of the attribute.
A logical schema
Which one is correct statement?Logical data independence provides following without changing application…
The cost of reading and writing temporary files while evaluating a query can be reduced by
What is a disjoint less constraint?
An outstanding functionality of SQL is its support for automatic_____ to the target data.
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
The relational model is based on the concept that data is organized and stored in two-dimensional tables…
The default level of consistency in SQL is
SQL server stores index information in the _____system table
Which of the following is not a consequence of concurrent operations?
Which of the following constitutes a basic set of operations for manipulating relational data?
As per equivalence rules for query transformation, selection operation distributes over
A top-to-bottom relationship among the items in a database is established by a
Relational Algebra does not have
Change Staff table by removing default of Assistant for position column
What are the desirable properties of a decomposition
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
operator is used to compare a value to a list of literals values that have been specified.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
Relations produced from an E-R model will always be
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter