KV KAUSANI CLASS XII A PAI CS

28
Created on By Kamini Singhal

PA1 XIIA CS

1 / 34

Enter Your Name

2 / 34

Enter your email ID

3 / 34

SECTION-A  MCQ

4 / 34

Which command is used to remove the entire table?

5 / 34

Which clause is used to arrange data in format Z to A?

6 / 34

Total number of rows of a relation is known as?

7 / 34

Which command is used to change the structure of a relation?

8 / 34

Which keyword is used to accept only one record from set of duplicate records?

9 / 34

SECTION-B   TRUE/FALSE

10 / 34

Sign function always returns 0.

11 / 34

Update command is used to change values of a tuple.

12 / 34

Join is used to join two tables on the basis of common column.

13 / 34

Check the given SQL command and find it is correct or not.

Select* from emp where rollno 5;

14 / 34

Month(now) returns 7 .     For date 22-7-2020

15 / 34

SECTION-C-    FILL IN THE BLANKS

16 / 34

_______________ keyword is used to arrange data in ascending or descending order.

17 / 34

______________ is a single row function.

18 / 34

_____________ function is used to find the total number of characters of a string.

19 / 34

___________ clause is used to grouping values based on some criteria.

20 / 34

Commit commands comes under which SQL command category?

21 / 34

SECTION-D   FIND  THE  OUTPUT

22 / 34

Output of :

LENGTH(“good morning”)

23 / 34

Output of:

SQRT(169)

24 / 34

Output of:

FNAME=”VIVEK”   LNAME=”GOEL”

CANCAT(LNAME, FNAME)

25 / 34

Output of:

LTRIM(”    BOOK”)

26 / 34

Output of:

SIGN(-25)

27 / 34

SUBSTR(“PREODIC TEST”,1,3)

28 / 34

SECTION-E   SHORT ANSWER TYPE QUESTIONS & QUERIES

29 / 34

Write a query to add one row in student table with given information:

(1, ‘abc’,46,123456)

30 / 34

Write a query to remove a row of table student for rollno 5.

31 / 34

Write a query to add one more column phoneno to table student.

32 / 34

Write a query to find total marks (column marks) of table student.

33 / 34

Write SQL command to display name, rollno and grade according to the age in increasing order.

34 / 34

Define the following terms:

Refrential Integrity, Vew, Domain, Cartesian Product, Natural Join

Your score is

The average score is 80%

0%

Close Menu