The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
m - 1
m + 1
m * m
m
Correct Answer :
D. m
Related Questions
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
Procedural DML.
Non-Procedural DML.
Procedural DDL.
Non-Procedural DDL.
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.
1:1
1: Many
Many: One
Many : Many
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
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
4,0
0,0
4,5
8,5
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.
Regular
Irregular
None
Weak
What is a disjoint less constraint?
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Fields
Records
Relations
Keys
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
The part of a database management system which ensures that the data remains in a consistent state is
authorization and integrity manager
buffer manager
transaction manager
file manager
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
Vulcanizing
Galvanizing
Magnetizing
Passing UV rays
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
____ table store information about database or about the system.
SQL
System
Nested
None of these
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
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 _______
Volatile
Non - Volatile
Logical
Physical
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
jamming
password
documentation
record lock
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
Which of the following is not comparison operator?
<>
<
=<
>=
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above