Question 1

1)Which function is used to get the Current System Date and Time

technology databases

GetSystemDate()
GetDate()
GetCurrentDateTime()
None

Answer

Correct Option: B

Question 2

What will be the Output for the Below Query Select * from Retailer where rtrid = (select top 3 Rtrid from retailer)

technology databases

Return Top 3 Row in the Retailer Table
Return Error
Return No Record
Return all Records from Retailer Table

Answer

Correct Option: B

Question 3

Which function is used to get the Current System Date and Time

technology databases

GetSystemDate()
GetDate()
GetCurrentDateTime()
None

Answer

Correct Option: B

Question 4

What will be the Output for the Below Query

technology databases

Return Top 3 Row in the Retailer Table
Return Error
Return No Record
Return all Records from Retailer Table

Answer

Correct Option: B

Question 5

How many Primary Key can be set for an table

technology databases

10
1
2
Infinite

Answer

Correct Option: A

Question 6

What will be the Output for Select Abs(25-45)

technology databases

Abs is not a recognized function name
-20
20
None

Answer

Correct Option: C

Question 7

Which of the joins are available in SQL i) Inner Join ii) Left Outer Join iii) Cross Join iv) Self Join

technology databases

All the Above
i) and ii)
i), ii) and iii)
None

Answer

Correct Option: A

Question 8

How many Output Parameters can be set for an Stored Procedure

technology databases

One
More than One
None
Stored Procedure Does not support Output Parameter

Answer

Correct Option: B

Question 9

A User Defined Function can Return

technology databases

One Value
More than One Value
No Value
User Defined Function will not return Value

Answer

Correct Option: B

Question 10

A Trigger can be for

technology databases

Stored Procedure
Function
Table
View

Answer

Correct Option: C

Question 11

Which of the following is not a group function?

technology databases

Min( )
Sqrt( )
Sum( )
max( )

Answer

Correct Option: B

Question 12

Which SQL statement is used to extract data from a database?

technology databases

Open
Get
Extract
None of the Above

Answer

Correct Option: C

Question 13

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"?

technology databases

SELECT * FROM Persons WHERE FirstName='%a%'
SELECT * FROM Persons WHERE FirstName='a'
SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Answer

Correct Option: D

Question 14

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

technology databases

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
SELECT FirstName='Peter', LastName='Jackson' FROM Persons
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
None

Answer

Correct Option: C

Question 15

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"?

technology databases

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
SELECT LastName>'Hansen' AND LastName
None

Answer

Correct Option: B

Question 16

Which SQL keyword is used to sort the result-set? SORT BY ORDER BY SORT ORDER

technology databases

SORT BY
ORDER BY
SORT
ORDER

Answer

Correct Option: B

Question 17

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

technology databases

SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons ORDER FirstName DES

Answer

Correct Option: C

Question 18

With SQL, how can you insert a new record into the "Persons" table?

technology databases

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
None

Answer

Correct Option: C

Question 19

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

technology databases

INSERT INTO Persons ('Olsen') INTO LastName
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons (LastName) VALUES ('Olsen')
None

Answer

Correct Option: C

Question 20

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

technology databases

DELETE ROW FirstName='Peter' FROM Persons
DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE FirstName='Peter' FROM Persons
None

Answer

Correct Option: B

Description: databases Online Quiz - 213
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 213

Find more quizzes from top tags