operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
Correct Answer :
A. Like
Related Questions
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
_____ command can be used to modify a column in a table
alter
update
set
create
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
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.
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM
Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
If a transaction T has obtained an exclusive lock on item Q, then T can
read Q
write Q
both read and write Q
write Q but not read Q
The statement that is executed automatically by the system as a side effect of the modification of the database is
backup
assertion
recovery
trigger
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
Which two files are used during operation of the DBMS?
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
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
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
A _____ is used to define overall design of the database
code
data definition language
application program
schema
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.