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)
Correct Answer :
A. is the entire database.
Related Questions
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
The index table has …… Columns.
1
2
3
4
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
The ability to modify the conceptual schema without causing any change to the application program is known as
Physical data independence
Logical data independence
External data independence
Static data
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
Triggers are also called
active rules
passive rules
inferences
none of the above
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Which of the following is not an Aggregate function?
Min
Max
Select
Avg