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

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

Choose incorrect statement.

Normalization is used to remove total dublication of data

Normalization is used to remove insertion Anomalies

Normalization is used to remove update and deletion Anomalies

Normalization is used to avoid data redundancy

Normalization process can not be achieved by.

Combining the tables into one table

Introducing new rows into a table.

Introducing new columns into a table.

Decomposing the tables from one table

Consider the following tables and choose the transitive dependency table

Student table:sid,cid,sname,marks,grade

Student table:sid,sname,branch,phone_number

Marks Grade:lomarks,himarks,grade

Student table:sid,sname,branch,mail_id

Consider the following tables and choose multi valued attribute table

Student table:sid,sname,branch,phone_numbers

Student table:sid,sname,branch,phone_number

Marks Grade:lomarks,himarks,grade

Student table:sid,cid,sname,marks,grade

SRM RMP-MCA -20.01.2024-AN

Authored by CCC info@ccc.training

English

Professional Development

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

15 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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%'

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

20 questions

MI3 Voc Test 7.1

Quiz

•

Professional Development

20 questions

Banking & finance

Quiz

•

Professional Development

15 questions

Articles

Quiz

•

8th Grade - Professio...

10 questions

Possesive pronouns

Quiz

•

Professional Development

12 questions

Verbs of the senses - LOOK LIKE, LOOK, LOOK AS IF AND AS

Quiz

•

Professional Development

15 questions

Sports definitions

Quiz

•

1st Grade - Professio...

12 questions

B1 Sports

Quiz

•

Professional Development

11 questions

Never have I ever

Quiz

•

Professional Development

Popular Resources on Wayground

6 questions

PRIDE Always and Everywhere

Presentation

•

12th Grade

20 questions

Lab Safety Quiz

Quiz

•

6th Grade

26 questions

KOR Review Kahoot Questions

Quiz

•

8th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

12 questions

Unit Zero lesson 2 cafeteria

Presentation

•

9th - 12th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

10 questions

Riddles Riddles fun Riddles

Quiz

•

6th - 12th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

Discover more resources for English

10 questions

Soup, Salad, or Sandwich?

Quiz

•

1st Grade - Professio...

20 questions

Employability Skills

Quiz

•

Professional Development

9 questions

How to Email your Teacher

Quiz

•

Professional Development

25 questions

2023 Pop Culture Trivia

Quiz

•

Professional Development

20 questions

Cinema Camera Angles

Quiz

•

9th Grade - Professio...

20 questions

Sports trivia

Quiz

•

Professional Development

21 questions

Shop Safety

Quiz

•

Professional Development