SQL Concept with Prac Q

Which of the column in the given table is Candidate Key?

• Name & ClientID

• City & Name

• Mobile and ClientId

• ClientNo & Pin

Answer explanation

This table contains ClientId and Mobile as Candidate key as these two column may contain unique values.

What will be Degree and Cardinality of Given Table?

• Degree-08

  Cardinality-05

• Degree-05

  Cardinality-08

• Degree-05

  Cardinality-09

• Degree-09

  Cardinality-05

Answer explanation

Cardinality means No. of Rows in a Table

Degree means No. of Columns in a Table.

Which Command is used to activate/ open a Database named CLUB?

(a)  

Which command is used to view structure of a Table EMPLOYEE?

(a)  

Which of the following command is correct to show name and city of Client in ascending order of their name?

• SELECT * FROM Client ORDER BY name DESC

• SELECT * FROM Client WHERE CITY ="Bombay" ORDER BY name DESC

• SELECT name, city FROM Client ORDER BY name

• SELECT name,city FROM Client ORDER BY DESC

Which command is used to view all tables in existing database named MOVIE?

(a)  

What will be result of following SQL Query?

SELECT Count(distinct(City)) FROM Client;

• 6

• 4

• 5

• NONE

Write query to display all details of Clients who work in Bombay and their names start with P.

• SELECT * FROM client WHERE name is P and city="Bombay"

• SELECT * FROM client WHERE name = P% and city="Bombay"

• SELECT * FROM client WHERE name = "P%" and city="Bombay"

• SELECT * FROM client WHERE name like "P%" and city="Bombay"

Write command to add a new record in table client with the given values?

Client No. C00010

Name: Bryan

City : Madras

Pin: 780001

Mobile : [phone]

(a)  

Which of the following query will be used to fetch city wise no. of Clients?

• Select * from Client where city is grouped;

• Select city, sum(name) from client group by city;

• Select count(*) from client group by name;

• Select city, count(*) from client group by city;