In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
Correct Answer :
A. Oval; An oval with an underlined attribute
Related Questions
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
The data models defined by ANSI/SPARC architecture are
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
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
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
An advantage of the database management approach is
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
The drawback of shadow paging technique are
Commit overhead
Data fragmentation
Garbage collection
All of these
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.
UPDATE S CITY = KANPUR WHERE SNO=S1
UPDATE S SET CITY = KANPUR FOR SNO=S1
UPDATE S SET CITY = KANPUR WHERE SNO=S1
UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
Which of the following statement on the view concept in SQL is invalid?
All views are not updateable
The views may be referenced in an SQL statement whenever tables are referenced.
The views are instantiated at the time they are referenced and not when they are defined.
The definition of a view should not have GROUP BY clause in it.
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
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
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
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)
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
………………… 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
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
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
Precedence graphs help to find a
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
SQL server stores index information in the _____system table
system indexes
syst indexes
sys indexes
sysind
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
Change Staff table by removing default of Assistant for position column
ALTER TABLE Staff ALTER position DROP DEFAULT;
ALTER TABLE Staff ALTER position DEFAULT;
ALTER TABLE Staff ALTER DROP DEFAULT;
MODIFY Staff ALTER position DROP DEFAULT;
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
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
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