Related Questions
What is the correct answer?
4
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
What is the correct answer?
4
______ keyword is used to find the number of values in a column.
What is the correct answer?
4
SQL server stores index information in the _____system table
What is the correct answer?
4
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
What is the correct answer?
4
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
What is the correct answer?
4
The middleware databases in which the business rules act are applicable to _______ tier architectures
What is the correct answer?
4
DBMS helps achieve
A. Centralized control of data
What is the correct answer?
4
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
What is the correct answer?
4
Which of the following is not a consequence of concurrent operations?
What is the correct answer?
4
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
What is the correct answer?
4
The metadata is created by the
What is the correct answer?
4
____ table store information about database or about the system.
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
Precedence graphs help to find a
A. Serializable schedule.
C. Deadlock free schedule.
What is the correct answer?
4
The normalization was first proposed by .
What is the correct answer?
4
An advantage of the database management approach is
A. data redundancy increases
B. data is dependent on programs
C. data is integrated and can be accessed by multiple programs
What is the correct answer?
4
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
What is the correct answer?
4
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
What is the correct answer?
4
The graphical representation of a query is .
What is the correct answer?
4
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
C. SQL server service manager
What is the correct answer?
4
In an E-R diagram double lines indicate
B. Multiple participation.
What is the correct answer?
4
Data independence means
A. data is defined separately and not included in programs.
B. programs are not dependent on the physical attributes of data
C. programs are not dependent on the logical attributes of data
What is the correct answer?
4
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
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
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
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
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
What is the correct answer?
4
For correct behaviour during recovery, undo and redo operation must be
What is the correct answer?
4
Which of the following constitutes a basic set of operations for manipulating relational data?
What is the correct answer?
4
The drawback of shadow paging technique are