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

Q. Which of the following is used to input the entry and give the result in a variable in a procedure ?

View solution

Q. The format for compound statement is

View solution

Q. Repeat
sequence of statements;
__________________
end repeat

Fill in the correct option :

View solution

Q. Which of the following is the correct format for if statement ?

View solution

Q. A stored procedure in SQL is a___________

View solution

Q. Temporary stored procedures are stored in _________ database.

View solution