Related Questions
What is the correct answer?
4
An outstanding functionality of SQL is its support for automatic_____ to the target data.
What is the correct answer?
4
Manager salary details are hidden from the employee .This is
A. Conceptual level data hiding.
B. External level data hiding.
C. Physical level data hiding.
What is the correct answer?
4
In an E-R diagram double lines indicate
B. Multiple participation.
What is the correct answer?
4
The set of all values that can be taken by the attribute is called as _______ of the attribute.
What is the correct answer?
4
The default level of consistency in SQL is
What is the correct answer?
4
If a transaction T has obtained an exclusive lock on item Q, then T can
D. write Q but not read Q
What is the correct answer?
4
In SQL the word natural can be used with
What is the correct answer?
4
When an E-R diagram is mapped to tables, the representation is redundant for
B. weak relationship sets
D. strong relationship sets
What is the correct answer?
4
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
What is the correct answer?
4
Shadow paging has
What is the correct answer?
4
Dependency preservation is not guaranteed in
What is the correct answer?
4
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
What is the correct answer?
4
Processed data is called _____
What is the correct answer?
4
Which of the following ensures the atomicity of the transaction?
A. Transaction management component of DBMS
B. Application Programmer
C. Concurrency control component of DBMS
D. Recovery management component of DBMS
What is the correct answer?
4
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
What is the correct answer?
4
Which of the following is true for network structure?
A. It is a physical representation of the data.
B. It allows many to many relationship.
C. It is conceptually simple.
D. It will be the dominant database of the future.
What is the correct answer?
4
Grant and revoke are _____ statements.
What is the correct answer?
4
A relational database developer refers to a record as
What is the correct answer?
4
For using a specific database …………… command is used.
What is the correct answer?
4
Which of the following addressing modes permits relocation without any change over in the code?
C. PC relative addressing
D. Base register addressing
What is the correct answer?
4
_____ command can be used to modify a column in a table
What is the correct answer?
4
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.
A. UPDATE S CITY = KANPUR WHERE SNO=S1
B. UPDATE S SET CITY = KANPUR FOR SNO=S1
C. UPDATE S SET CITY = KANPUR WHERE SNO=S1
D. UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
What is the correct answer?
4
The collection of information stored in a database at a particular moment is called as ......
B. instance of the database
What is the correct answer?
4
_____ First proposed the process of normalization.
What is the correct answer?
4
____specifies a search condition for a group or an aggregate.
What is the correct answer?
4
_____ database is used to provide statistical information or summaries of values based on various criteria.
What is the correct answer?
4
If the closure of an attribute set is the entire relation then the attribute set is a
What is the correct answer?
4
Which of the following is not a consequence of concurrent operations?
What is the correct answer?
4
The normalization was first proposed by .
What is the correct answer?
4
Checkpoints are a part of
D. uthorization measures.