The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
Correct Answer :
B. AND
Related Questions
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Union
Intersection
Difference
Join
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
Data items grouped together for storage purposes are called a
record
string
title
list
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
Operationally, if Y is deleted, so is X
existence is dependent on Y.
Operationally, if X is deleted, so is Y.
Operationally, if X is deleted, & remains the same.
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
ii) insert into
i-only
ii-only
Both of them
None of them
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
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.
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
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.
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
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
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
RAM
Flash
Hard Disk
Secondary
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
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
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
left outer join
right outer join
full outer join
inner join
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client