Related Questions
What is the correct answer?
4
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
What is the correct answer?
4
The full form of GUI is _________
A. Government Union Internet
B. Graphical Unit Interface
C. Graphical User Interface
D. Graphical University Interface
What is the correct answer?
4
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
What is the correct answer?
4
What is a disjoint less constraint?
A. It requires that an entity belongs to no more than one level entity set.
B. The same entity may belong to more than one level.
C. The database must contain an unmatched foreign key value.
D. An entity can be joined with another entity in the same level entity set.
What is the correct answer?
4
____ table store information about database or about the system.
What is the correct answer?
4
What are the desirable properties of a decomposition
B. Dependency preservation.
What is the correct answer?
4
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
What is the correct answer?
4
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
A. Create table Employee(EMPNO int, EMPNAME char(10));
B. Create table Employee(EMPNO integer, EMPNAME String(10));
C. Create table Emplo(EMPNO number, EMPNAME string);
D. Create table Emp(EMPNO int, EMPNAME char(10));
What is the correct answer?
4
Which two files are used during operation of the DBMS?
A. Query languages and utilities
B. DML and query language
C. Data dictionary and transaction log
D. Data dictionary and query language
What is the correct answer?
4
Isolation of the transactions is ensured by
A. Transaction management
B. Application programmer
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
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
_____ command can be used to modify a column in a table
What is the correct answer?
4
A table can have only one
What is the correct answer?
4
A _____ is used to define overall design of the database
B. data definition language
What is the correct answer?
4
The cost of reading and writing temporary files while evaluating a query can be reduced by
What is the correct answer?
4
_____clause is an additional filter that is applied to the result.
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
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
Relations produced from an E-R model will always be
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
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
Which of the following concurrency control schemes is not based on the serializability property?
C. Time-stamp based locking
What is the correct answer?
4
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
What is the correct answer?
4
A data type or format is specified for each _________
What is the correct answer?
4
Tree structures are used to store data in
What is the correct answer?
4
_____is a full form of SQL.
A. Standard query language
B. Sequential query language
C. Structured query language
D. Server side query language
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
Data items grouped together for storage purposes are called a
What is the correct answer?
4
In SQL the statement select * from R, S is equivalent to
A. Select * from R natural join S.
B. Select * from R cross join S.
C. Select * from R union join S.
D. Select * from R inner join S.