Related Questions
What is the correct answer?
4
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
What is the correct answer?
4
The clause alter table in SQL can be used to
C. alter the default values of an attribute
What is the correct answer?
4
Which of the following aggregate functions does not ignore nulls in its results?.
What is the correct answer?
4
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
What is the correct answer?
4
______is a preferred method for enforcing data integrity
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
In an ER model,_____ is described in the database by storing its data.
What is the correct answer?
4
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
What is the correct answer?
4
As per equivalence rules for query transformation, selection operation distributes over
What is the correct answer?
4
Wait-for graph is used for
A. detecting view serializability.
B. detecting conflict serializability.
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
The middleware databases in which the business rules act are applicable to _______ tier architectures
What is the correct answer?
4
A logical schema
A. is the entire database
B. Describes how data is actually stored on disk.
C. is a standard way of organizing information into accessible parts.
What is the correct answer?
4
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
What is the correct answer?
4
Dependency preservation is not guaranteed in
What is the correct answer?
4
Which normal form is considered adequate for normal relational database design?
What is the correct answer?
4
A relational database developer refers to a record as
What is the correct answer?
4
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
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
Which is the best file organization when data is frequently added or deleted from a file?
What is the correct answer?
4
A data type or format is specified for each _________
What is the correct answer?
4
The transactions like adding an employee, enrolling a student in a course are examples of _______
What is the correct answer?
4
____ table store information about database or about the system.
What is the correct answer?
4
For correct behaviour during recovery, undo and redo operation must be
What is the correct answer?
4
A transaction is in state after the final statement has been executed.
What is the correct answer?
4
Which of the following is not a characteristic of a relational database model?
C. Complex logical relationship
What is the correct answer?
4
Which of the following is a reason to model data?
A. Understand each user's perspective of data
B. Understand the data itself irrespective of the physical representation
C. Understand the use of data across application areas
What is the correct answer?
4
______ keyword is used to find the number of values in a column.
What is the correct answer?
4
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
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.