databases Online Quiz - 213
Description: databases Online Quiz - 213 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Attempted
0/20
Correct 0
Score 0
‹
›
What will be the Output for the Below Query Select * from Retailer where rtrid = (select top 3 Rtrid from retailer)
What will be the Output for the Below Query
How many Primary Key can be set for an table
Which of the joins are available in SQL i) Inner Join ii) Left Outer Join iii) Cross Join iv) Self Join
A User Defined Function can Return
A Trigger can be for
- With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
- With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
- With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
- Which SQL keyword is used to sort the result-set? SORT BY ORDER BY SORT ORDER
- With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
- With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?