Related Questions
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
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 data in the database at a particular moment of time is called the _______
What is the correct answer?
4
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
What is the correct answer?
4
_____ command can be used to modify a column in a table
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
Relations produced from an E-R model will always be
What is the correct answer?
4
Grant and revoke are _____ statements.
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
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
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
If an entity can belong to only one lower level entity then the constraint is
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
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
What is the correct answer?
4
Which of the following is not comparison operator?
What is the correct answer?
4
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
A. Oval; An oval with an underlined attribute
B. Circle; A circle with bolded attribute inside it
C. Diamond; A bolded attribute
D. Square; An attribute within the square
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
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 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
______is a preferred method for enforcing data integrity
What is the correct answer?
4
Relational Algebra is
A. Data Definition Language .
C. Procedural query Language
What is the correct answer?
4
SQL server stores index information in the _____system table
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
The rule that a value of a foreign key must appear as a value of some specific table is called a
A. Referential constraint.
D. Functional dependency.
What is the correct answer?
4
_____clause is an additional filter that is applied to the result.
What is the correct answer?
4
In SQL the word natural can be used with
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
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
C. the compound key first name and last name
What is the correct answer?
4
A data type or format is specified for each _________
What is the correct answer?
4
According to the levels of abstraction, the schema at the intermediate level is called