[Solved] Which of the following is the right syntax for the assertion?

McqMate

Q.	Which of the following is the right syntax for the assertion?
A.	create assertion ‘assertion-name’ check ‘predicate’;
B.	create assertion check ‘predicate’ ‘assertion-name’;
C.	create assertions ‘predicates’;
D.	all of the mentioned
Answer» A. create assertion ‘assertion-name’ check ‘predicate’;

1.5k

0

Do you find this helpful?

8

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Which one of the following is the right syntax for DECODE?
Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
To select all columns from the table the syntax is:
To select all column from the table the syntax is:
What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)
Syntax for creating views is __________
What is the process that is done to SQL before execution, to check for proper syntax and to optimize the request called?
Which of the following creates a temporary relation for the query on which it is deﬁned?
Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?
Which of the following is the formal process for deciding which attributes should be grouped together in a relation?