Related Questions
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
_____ command can be used to modify a column in a table
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
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
Which of the following aggregate functions does not ignore nulls in its results?.
What is the correct answer?
4
The graphical representation of a query is .
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
Which of the following is not a consequence of concurrent operations?
What is the correct answer?
4
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
What is the correct answer?
4
SQL server stores index information in the _____system table
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 one guideline to be followed while designing the database is
A. A database design may be ambiguous.
B. It should avoid/reduce the redundancy.
C. Unrelated data should be in the same table so that updating the data will be easy.
D. An entity should not have attributes.
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
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 statement on the view concept in SQL is invalid?
A. All views are not updateable
B. The views may be referenced in an SQL statement whenever tables are referenced.
C. The views are instantiated at the time they are referenced and not when they are defined.
D. The definition of a view should not have GROUP BY clause in it.
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 values of the attribute describes a particular
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 syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
What is the correct answer?
4
HSAM stands for ……….
A. Hierarchic Standard Access Method
B. Hierarchic Sequential Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
What is the correct answer?
4
Which of the following relational algebraic operations is not from set theory?
What is the correct answer?
4
In multiple granularity of locks SIX lock is compatible with
What is the correct answer?
4
The normalization was first proposed by .
What is the correct answer?
4
Drop Table cannot be used to drop a table referenced by a ______ constraint.
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
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
What is the correct answer?
4
Checkpoints are a part of
D. uthorization measures.
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
A top-to-bottom relationship among the items in a database is established by a
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.