Q. What statement is used to define a new assertion in SQL?

View solution

Q. Which of the following is not a valid Date and Time data type?

View solution

Q. What is a timestamp?

View solution

Q. What does p indicate in the following data type?
time(p)

View solution

Q. What is a default value?

View solution

Q. Which of the following is an illegal data type in SQL

View solution

Q. State true or false: Users can define new data types in SQL

View solution

Q. What does the following statement do?
create table temp_inst like institute

View solution

Q. Which of the following is a privilege in SQL standard?

View solution

Q. The _________ statement is used in SQL to confer authorization.

View solution

Q. revoke select on takes from amit;
What does the above query perform?

View solution

Q. Which of the following is/are a function of dynamic SQL?

View solution

Q. What is the full form of JDBC?

View solution

Q. State true or false: Developers cannot write their own functions into SQL

View solution

Q. Which of the following are not a part of PL/SQL

View solution

Q. The part of SQL that deals with the SQL supports constructs is called as _______

View solution

Q. A _________ is a statement that the system executes whenever a database is modified

View solution

Q. State true or false: Recursive queries are permitted in SQL

View solution

Q. How many different types of drivers are present in JDBC?

View solution

Q. Which JDBC Driver is the most efficient of all the JDBC drivers?

View solution