SRM RMP-MCA -20.01.2024-AN

Examine the structure of the student table: Student Table: sid, sname, contact_no Which one of these is an incorrect statement?

• select sid student_rollnumber from student;
• select sname as student_name from student;
• select contact_no "student phone number" from student;
• select sname as student name from student;

Which one of the following is a valid statement?

• The concatenation operator is represented by pipe symbol(||)
• The concatenation operator is links columns to other columns
• The concatenation operator is links columns to arithmetic expressions or constants
• All of the above

Examine the structure of the student table: Student Table:sid,sname,contact_no,doj(date of join) Identify the query for deleting all details of students who joined eight years ago?

• delete from student where months_between(sysdate,doj)>96
• delete from student where years_between(sysdate,doj)>8
• delete from student where months_between(doj,sysdate)>96
• delete from student where years_between(doj,sysdate)>8

Which one is a valid statement?

• to_char() function is used to convert number to characters
• to_char() function is used to convert date to characters
• to_char() function is used to convert characters to number
• Both A and B

Examine the structure of the STUDENT table: STUDENT_ID NUMBER Primary Key S_NAME VARCHAR2(25) S_BRANCH VARCHAR2(25) Identify the query for displying all details of students who's name start with 'K' and 3rd letter shoud be 'v'?

• select S_NAME from STUDENT where S_NAME like 'K_v%'
• select * from STUDENT where S_NAME like 'K%v_'
• select student_id,s_name,s_branch from STUDENT where S_NAME like 'K_v%'
• select * from STUDENT where S_NAME like 'k_v%'

Which one is a valid statement?

• to_date() function is used to convert number to a valid date
• to_date() function is used to convert date to characters
• to_date() function is used to convert characters to a valid date
• All of the above

Which one is a valid statement?

• Group functions returns a single row based on groups of rows
• Group functions can be appear in SELECT lists and HAVING clauses
• Group functions can be appear in SELECT lists and not in HAVING clauses
• except c

Examine the structure of the student table: Student Table:sid,sname,contact_no,doj(date of join),fee_due,branch College management has decided to know the total amount of fees due whose maximum fee due for each branch; For example,CSE branch total fee due is 50 lakhs, IT branch total fee due is 20 lakhs, ECE branch total fee due is 55 lakhs then print 55 lakhs. Which one is a valid query?

• select max(sum(fee_due)) from student group by branch
• select max(sum(fee_due)),branch from student group by branch
• select max(fee_due) from student
• select sum(fee_due) from student

Which one is a correct statement?

• GRANT command is used to share data to other users
• GRANT command can be used only on table object
• GRANT command can be used not only table,but also on views,indexes,sequences
• Both A and C

Which one is a correct statement?

• A ROLE is a group of privilages that can be assigned to a USER
• A ROLE is a group of privilages that can be assigned to other ROLE
• We can assign multiple roles to a USER or ROLE
• All of the above