Which of the following is not comparison operator?
<>
<
=<
>=
Correct Answer :
C. =<
Related Questions
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
distinct values
cannot have NULL
both (A) & (B)
same as primary key
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None
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
………………… 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
Data items grouped together for storage purposes are called a
record
string
title
list
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
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
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
The one guideline to be followed while designing the database is
A database design may be ambiguous.
It should avoid/reduce the redundancy.
Unrelated data should be in the same table so that updating the data will be easy.
An entity should not have attributes.
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
Which of the following is not comparison operator?
<>
<
=<
>=
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
In SQL, testing whether a subquery is empty is done using
DISTINCT
UNIQUE
NULL
EXISTS
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
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
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
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
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets