The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
Correct Answer :
C. metadata
Related Questions
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
Noisy channel has ……… .. types of protocols
two
three
four
none
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes