Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
Correct Answer :
C. Confidentiality
Related Questions
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 collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
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
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
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
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
Domain Integrity Constraints
Referential Integrity Constraints
Domain Constraints
Entity Integrity Constraints
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
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.
_____ command can be used to modify a column in a table
alter
update
set
create
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
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.
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
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
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.