×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You are given a table named Members_club containing columns named as, member_name and member_ID. What will be the result of the following SQL query?
Select member_name from Members_club order by 2 desc;2.
In an SQL Server, which of the following features is used to track the changes on a table?
3.
What will be the result of the following SQL query:
SELECT REGEXP_SUBSTR('The plane leaves 02/05/04 at 04:23 pm.',
'([0-1][0-9]|2[0-3]):[0-5][0-9]')
FROM dual;4.
In SQL, an instance of a relational schema R (F1, F2, F3) contains distinct values of F1 including NULL values. Which of the following statements is incorrect about F1?
5.
Based on the given data in the table BIRTHDAY, what will be the result of the following SQL query:
Select AVG(DISTINCT Age) AS Average, SUM (DISTINCT Age) AS Total from BIRTHDAY;
| Firstname | Age |
| Alice | 42 |
| Bob | 52 |
| Ben | 42 |
| Mike | 42 |
| Tara | 42 |
6.
What will be the result of the following SQL query:
Select REPLACE(‘GEORGE’, ‘GE’, NULL) AS result from DUAL;7.
Does the following SQL query return any rows:
SELECT *
FROM Order_Dtls
WHERE order_date_time BETWEEN
TO_DATE('31-DEC-2200', 'DD-MON YYYY')
AND TO_DATE('01/01/1900', 'MM/DD/YYYY');8.
In an SQL Server, which of the following statements is used to create the database called toys with at least 50 MB of free space and 15 MB as start size for the transaction log?
9.
In an SQL Server, which of the following integrities can be implemented using the delete trigger?
10.
Which of the following is used by an SQL server to store data when a table does not have a clustered index?