Database Management Using SQL
.
- 1.Which of the following is not a property of transactions?
- A.
Atomicity
- B.
Concurrency
- C.
Isolation
- D.
Durability
- 2.Tree structures are used to store data in
- A.
Network model.
- B.
Relational model.
- C.
Hierarchical model.
- D.
File based system.
- 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
- 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.
- 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.
- 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
- 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
- 8.DROP is a ______________ statement in SQL.
- A.
Query
- B.
Embedded SQL
- C.
DDL
- D.
DCL
- 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
- 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
- 11.ON UPDATE CASCADE ensures which of the following?
- A.
Normalization
- B.
Data Integrity
- C.
Materialized Views
- D.
All of the above.
- 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;
- 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
- 14.The SQL keyword(s) ________ is used with wildcards.
- A.
LIKE only
- B.
IN only
- C.
NOT IN only
- D.
IN and NOT IN
- 15.January 1, 2008 is Tuesday. What day of the week lies on Jan 1, 2009?
- A.
Monday
- B.
Wednesday
- C.
Thursday
- D.
Sunday
- 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
- 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');
- 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.
- 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°
- 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
Questions: 34 | Attempts: 70 | Last updated: Apr 6, 2021
-
Sample QuestionA ____ is an object that stores data in columns and rows.
Questions: 50 | Attempts: 2868 | Last updated: Sep 24, 2020
-
Sample QuestionA database can contribute to organizational success by providing managers and decision makers with timely, accurate, and relevant information based on data.
Questions: 10 | Attempts: 226 | Last updated: Jan 8, 2021
-
Sample QuestionWhich of the following is not the responsibility of the utilities component of DBMS software?
Back to top