Database Management Using SQL
.
- 1.
Which of the following is not a property of transactions?
- A.
Atomicity
- B.
Concurrency
- C.
Isolation
- D.
Durability
Correct Answer
B. Concurrency -
- 2.
Tree structures are used to store data in
- A.
Network model.
- B.
Relational model.
- C.
Hierarchical model.
- D.
File based system.
Correct Answer
C. Hierarchical model. -
- 3.
A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.
- A.
2NF
- B.
3NF
- C.
BCNF
- D.
1NF
Correct Answer
B. 3NF -
- 4.
What is data integrity?
- A.
It is the data contained in database that is non redundant.
- B.
It is the data contained in database that is accurate and consistent.
- C.
It is the data contained in database that is secured.
- D.
It is the data contained in database that is shared.
Correct Answer
B. It is the data contained in database that is accurate and consistent. -
- 5.
In SQL the statement select * from R, S is equivalent to
- A.
Select * from R natural join S.
- B.
Select * from R cross join S.
- C.
Select * from R union join S.
- D.
Select * from R inner join S.
Correct Answer
B. Select * from R cross join S. -
- 6.
A train passes a station platform in 36 seconds and a man standing on the platform in 20 seconds. If the speed of the train is 54 km/hr, what is the length of the platform?
- A.
120 m
- B.
240 m
- C.
300 m
- D.
None of these
Correct Answer
B. 240 m -
- 7.
A person crosses a 600 m long street in 5 minutes. What is his speed in km per hour?
- A.
3.6
- B.
7.2
- C.
8.4
- D.
10
Correct Answer
B. 7.2 -
- 8.
DROP is a ______________ statement in SQL.
- A.
Query
- B.
Embedded SQL
- C.
DDL
- D.
DCL
Correct Answer
C. DDL -
- 9.
Which of the following ensures the atomicity of the transaction?
- A.
Transaction management component of DBMS
- B.
Application Programmer
- C.
Concurrency control component of DBMS
- D.
Recovery management component of DBMS
Correct Answer
A. Transaction management component of DBMS -
- 10.
A vendor bought toffees at 6 for a rupee. How many for a rupee must he sell to gain 20%?
- A.
3
- B.
4
- C.
5
- D.
6
Correct Answer
C. 5 -
- 11.
ON UPDATE CASCADE ensures which of the following?
- A.
Normalization
- B.
Data Integrity
- C.
Materialized Views
- D.
All of the above.
Correct Answer
B. Data Integrity -
- 12.
Which of the following is valid SQL for an Index?
- A.
CREATE INDEX ID;
- B.
CHANGE INDEX ID;
- C.
ADD INDEX ID;
- D.
REMOVE INDEX ID;
Correct Answer
A. CREATE INDEX ID; -
- 13.
A is thrice as good as workman as B and therefore is able to finish a job in 60 days less than B. Working together, they can do it in:
- A.
20 days
- B.
22.5 days
- C.
25 days
- D.
30 days
Correct Answer
B. 22.5 days -
- 14.
The SQL keyword(s) ________ is used with wildcards.
- A.
LIKE only
- B.
IN only
- C.
NOT IN only
- D.
IN and NOT IN
Correct Answer
A. LIKE only -
- 15.
January 1, 2008 is Tuesday. What day of the week lies on Jan 1, 2009?
- A.
Monday
- B.
Wednesday
- C.
Thursday
- D.
Sunday
Correct Answer
C. Thursday -
- 16.
Which of the following are the five built-in functions provided by SQL?
- A.
COUNT, SUM, AVG, MAX, MIN
- B.
SUM, AVG, MIN, MAX, MULT
- C.
SUM, AVG, MULT, DIV, MIN
- D.
SUM, AVG, MIN, MAX, NAME
Correct Answer
A. COUNT, SUM, AVG, MAX, MIN -
- 17.
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'
- A.
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
- B.
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
- C.
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
- D.
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Correct Answer
D. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); -
- 18.
The SQL keyword BETWEEN is used:
- A.
For ranges.
- B.
To limit the columns displayed.
- C.
As a wildcard.
- D.
None of the above is correct.
Correct Answer
A. For ranges. -
- 19.
A clock is started at noon. By 10 minutes past 5, the hour hand has turned through:
- A.
145°
- B.
150°
- C.
155°
- D.
160°
Correct Answer
C. 155° -
- 20.
Introducing a woman, Shashank said, "She is the mother of the only daughter of my son." How that woman is related to Shashank?
- A.
Daughter
- B.
Sister-in-law
- C.
Wife
- D.
Daughter-in-law
Correct Answer
D. Daughter-in-law -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 15, 2022Quiz Edited by
ProProfs Editorial Team -
May 09, 2020Quiz Created by
Prasad Mutkule
Back to top