Database Management System (DBMS) MCQ Questions and answers

A

Admin • 833.24K Points
Coach

Q. Which of the following data types does the SQL standard not support?

(A) char(n)
(B) String(n)
(C) varchar(n)
(D) float(n)

A

Admin • 833.24K Points
Coach

Q. Which command is used to create a new relation in SQL

(A) create table( , …)
(B) create relation( , …)
(C) new table( , …)
(D) new relation( , …)

A

Admin • 833.24K Points
Coach

Q. If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?

(A) primary key(a1, a2, a3)
(B) primary key(a1)
(C) foreign key(a1, a2) references S
(D) foreign key(a1, a2)

A

Admin • 833.24K Points
Coach

Q. What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)

(A) enter into D (a, b, C:);
(B) insert into D values (a, b, C:);
(C) insert into D (a, b, C:);
(D) insert (a, b, C:) values into D;

A

Admin • 833.24K Points
Coach

Q. Which of the following commands do we use to delete a relation (R) from a database?

(A) drop table R
(B) drop relation R
(C) delete table R
(D) delete from R

A

Admin • 833.24K Points
Coach

Q. Which of the following commands do we use to delete all the tuples from a relation (R)?

(A) delete table R
(B) drop table R
(C) delete from R
(D) drop from R

A

Admin • 833.24K Points
Coach

Q. SQL query to find the temperature in increasing order of all cities.

(A) SELECT city FROM weather ORDER BY temperature
(B) SELECT city, temperature FROM weather
(C) SELECT city, temperature FROM weather ORDER BY temperature
(D) SELECT city, temperature FROM weather ORDER BY city

A

Admin • 833.24K Points
Coach

Q. What is the meaning of LIKE ‘%0%0%’?

(A) Feature begins with two 0’s
(B) Feature ends with two 0’s
(C) Feature has more than two 0’s
(D) Feature has two 0’s in it, at any position

A

Admin • 833.24K Points
Coach

Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

(A) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
(B) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
(C) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
(D) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

A

Admin • 833.24K Points
Coach

Q. Find all the tuples having a temperature greater than ‘Paris’.

(A) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
(B) SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)
(C) SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)
(D) SELECT * FROM weather WHERE temperature > ‘Paris’ temperature

Database Management System (DBMS) MCQs with answers Page - 22

Q. Which of the following data types does the SQL standard not support?

Q. Which command is used to create a new relation in SQL

Q. If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?

Q. What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)

Q. Which of the following commands do we use to delete a relation (R) from a database?

Q. Which of the following commands do we use to delete all the tuples from a relation (R)?

Q. SQL query to find the temperature in increasing order of all cities.

Q. What is the meaning of LIKE ‘%0%0%’?

Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

Q. Find all the tuples having a temperature greater than ‘Paris’.

Add MCQ in this Category

Browse Categories