Which of the following aggregate functions does not ignore nulls in its results?.
COUNT .
COUNT (*)
MAX
MIN
Correct Answer :
B. COUNT (*)
Related Questions
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
In SQL, testing whether a subquery is empty is done using
DISTINCT
UNIQUE
NULL
EXISTS
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
None
Multi
Single
Concurrent
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
Which of the following is true for network structure?
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM
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
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
Database
Data
Transaction
Record
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
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 a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
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 weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
Direct
Indirect
Existence
No
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 a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
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
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
The clause alter table in SQL can be used to
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational