Related Questions
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
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
A top-to-bottom relationship among the items in a database is established by a
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
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
Dependency preservation is not guaranteed in
What is the correct answer?
4
SQL server stores index information in the _____system table
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
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
A. It will result in a deadlock situation.
B. It will immediately be rejected.
C. It will immediately be granted.
D. It will be granted as soon as it is released by A .
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
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
If the closure of an attribute set is the entire relation then the attribute set is a
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 ______ 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 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
Which of the following is not a property of transactions?
What is the correct answer?
4
DBMS is a collection of _____ that enables user to create and maintain a database.
What is the correct answer?
4
The set of all values that can be taken by the attribute is called as _______ of the attribute.
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
operator is used to compare a value to a list of literals values that have been specified.
What is the correct answer?
4
______is a preferred method for enforcing data integrity
What is the correct answer?
4
______ keyword is used to find the number of values in a column.
What is the correct answer?
4
Relations produced from an E-R model will always be
What is the correct answer?
4
A table can have only one
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
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
The keyword to eliminate duplicate rows from the query result in SQL is
What is the correct answer?
4
Which of the following is not a recovery technique?
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
Processed data is called _____