Q. In order to maintain the consistency during transactions database provides

View solution

Q. Which of the following is used to get back all the transactions back after rollback ?

View solution

Q. ______ will undo all statements up to commit?

View solution

Q. Domain constraints, functional dependency and referential integrity are special forms of _________

View solution

Q. Create index studentID_index on student(ID);
Here which one denotes the relation for which index is created ?

View solution

Q. Values of one type can be converted to another domain using which of the following ?

View solution

Q. CREATE DOMAIN YearlySalary NUMERIC(8,2)
CONSTRAINT salary VALUE test __________;

In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:

View solution

Q. In contemporary databases the top level of the hierarchy consists of ______ each of which can contain _____

View solution

Q. The database administrator who authorizes all the new users, modifies database and takes grants privilege is

View solution

Q. Which of the following is a basic form of grant statement ?

View solution

Q. Which of the following is used to access the database server at time of executing the program and get the data from the server accordingly ?

View solution

Q. Which of the following header must be included in java program to establish database connectivity using JDBC ?

View solution

Q. DriverManager.getConnection(_______ , ______ , ______)
What are the two parameters that are included ?

View solution

Q. Which of the following invokes functions in sql ?

View solution

Q. Which of the following function is used to find the column count of the particular resultset ?

View solution

Q. Which of the following is a following statement is a prepared statements ?

View solution

Q. Which of the following is used as the embedded SQL in COBOL ?

View solution

Q. Which of the following is used to distinguish the variables in SQL from the host language variables ?

View solution

Q. The update statement can be executed in host language using

View solution

Q. Which of the following is used to access large objects from a database ?

View solution