Ellipses represent _____
Attributes
Explanation: None
Relationship Sets
Derived Attributes
Multivalued Attributes
Category: Databases MCQs
Which of the following structure represent the entity sets?
Which of the following structure represent the entity sets?
Rectangle
Explanation: None
Double rectangle
Diamond
Ellipse
An ER diagram can express the overall _____ of a database graphically.
An ER diagram can express the overall _____ of a database graphically.
Logical Structure
Explanation: None
View Structure
Model Structure
Architectural Structure
Variables declared inside the function are called as …
Variables declared inside the function are called as …
local variables
Explanation: None
private variables
global variables
external variables
Overloaded functions are …
Overloaded functions are …
many functions in the program
Explanation: None
functions having same variables
more than one function having same name
function having global variables
In the array, the elements are numbered from …
In the array, the elements are numbered from …
0 to 9
Explanation: None
0 to 9
1 to 10
None of the Options are Correct
Which of the following keyword is not associated with initialization of variable ?
Which of the following keyword is not associated with initialization of variable ?
All of the mentioned
Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.
DECLARE
SET
SELECT
Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function ?
Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function ?
All of the mentioned
Most of the Service broker statements cannot be included in the definition of a Transact-SQL user-defined function.
GET CONVERSATION GROUP
MOVE CONVERSATION
RECEIVE
Function cannot be used for __________ statement.
Function cannot be used for __________ statement.
Insert
We can’t use function to Insert, Update, Delete records in the database table(s).
Create
Drop
Select
RECEIVE service broker statement applies to which of the versions ?
RECEIVE service broker statement applies to which of the versions ?
2008
RECEIVE retrieves one or more messages from a queue. Depending on the retention setting for the queue, either removes the message from the queue or updates the status of the message in the queue.
2000
2005
None of the Options are Correct