Clause that apply aggregate functions to get a single result tuple for each group, is known to be
If attribute of relation schema R is member of some candidate key then this type of attributes are classified as
If in JOIN operation, conditions of JOIN operation are not satisfied then results of operation is
Two masses 7.5 kg and 6.7 kg are attached to ends of an inextensible string passes over a frictionless pulley. Its tension when both masses are moving vertically will be equal to
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
SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view
Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause
The cost of 2 chairs and 3 tables is Rs.1300. The cost of 3 chairs and 2 tables is Rs.1200. The cost of each table is more than that of each chair by
In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index
Which one is true about clustered index
WIF enables you to create a custom token. To be able to use the token, you must create a custom token handler by overriding which of the following
Which is a bottom-up approach to database design that design by examining the relationship between attributes
Create table employee (name varchar ,id integer) What type of statement is this
The difference between simple and compound interests compounded annually on a certain sum of money for 2 years at 4% per annum is Rs 1. Find the sum