It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
Correct Answer :
B. DDL and DML.
Related Questions
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
Which of the following is not a database object?
index
sequence
cursor
trigger
Noiseless channel has ……… types of protocols.
2
3
4
5
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
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
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
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
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
Authorization command in SQL
Allow
Access
Grant
none of the above
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital