Q. ________ is a predicate that we expect the database to always satisfy

View solution

Q. State true or false: Oracle does not support complex check conditions

View solution

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