________ is a program that performs some common action on database data and also stored in the database.
Stored Procedure
Well Done. Your Answer is Correct Keep it Up!
Trigger
Stored Function
None of the options are correct
Category: Computer Science
______ is NOT a type of constraint in SQL language?
______ is NOT a type of constraint in SQL language?
ALTERNATE KEY
Well Done. Your Answer is Correct Keep it Up!
UNIQUE
PRIMARY KEY
FOREIGN KEY
When the wildcard in a WHERE clause is useful?
When the wildcard in a WHERE clause is useful?
When an exact match is not possible in a SELECT statement.
Well Done. Your Answer is Correct Keep it Up!
When an exact match is required in a SELECT statement.
When an exact match is required in a CREATE statement.
When an exact match is not possible in a CREATE statement.
Which operator is used to compare the NULL values in SQL?
Which operator is used to compare the NULL values in SQL?
IS
Well Done. Your Answer is Correct Keep it Up!
IN
Equal
None of the options are correct
A sequence in SQL can generate a maximum number:
A sequence in SQL can generate a maximum number:
38 digits
Well Done. Your Answer is Correct Keep it Up!
39 digits
40 digits
37 digits
What is the difference between a PRIMARY KEY and a UNIQUE KEY?
What is the difference between a PRIMARY KEY and a UNIQUE KEY?
We can have only one primary key in a table while we can have multiple unique keys
Well Done. Your Answer is Correct Keep it Up!
None of the options is correct
Primary key can store null value, whereas a unique key cannot store null value.
Primary key cannot be a date variable whereas unique key can be
Group of operations that form a single logical unit of work is known as
Group of operations that form a single logical unit of work is known as
Transaction
Well Done. Your Answer is Correct Keep it Up!
Unit
Network
View
Which of the following is the basic approaches for joining tables?
Which of the following is the basic approaches for joining tables?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
Union JOIN
Natural JOIN
Subqueries
Which statement is true regarding procedures?
Which statement is true regarding procedures?
They include procedural and SQL statements.
Well Done. Your Answer is Correct Keep it Up!
They work similarly to the functions.
It does not need unique names.
It cannot be created with SQL statements.
A CASE SQL statement is ________?
A CASE SQL statement is ________?
A way to establish an IF-THEN-ELSE in SQL
Well Done. Your Answer is Correct Keep it Up!
A way to establish a loop in SQL.
A way to establish a data definition in SQL
All options are correct