Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Correct Answer :
B. Dynamic SQL
Related Questions
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
Referential integrity
controls relationships between operations of an object
controls relationships between instances of a class
controls relationships between attributes in a table
controls relationships between tables in a database
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
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
B-Tree is used for
searching data
storing data
both A and B
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
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
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
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Secondary storage
magnetic disk
magnetic tape
juke box
cache
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
View never contains derived columns.
True
False
Cant say
none
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers