(A) 3 Km/h
(B) 4 Km/h
(C) 5 Km/h
(D) 6 Km/h
Author:
A boat takes 38 hrs for travelling downstream from point p to point q and coming back to a point r midway between p and q. If the velocity of the stream is 8 km/hr and the speed of the boat in still water is 28 km/hr. What is the distance between p and q?
(A) 450 KM
(B) 510 KM
(C) 640 KM
(D) 720 KM
In “One to Many” cardinality one instance of a relation is mapped with?
(A) Many instances of second entity type
(B) One instance of second entity type
(C) Primary key of 2 relations
(D) None of the above
Which of the following is not true regarding clustering?
(A) It increases the efficiency since related records are placed close to each other
(B) Clustering makes records, difficult to access
(C) suitable to relatively static situations
(D) It is a process, which means to place records from different tables to place in adjacent physical locations
Which of the following statements creates a database named IMDB?
(A) CREATE DATABASE IMDB;
(B) CREATE DB IMDB;
(C) ADD DATABASE named IMDB;
(D) CREATE IMDB DATABASE;
The __ operator allows to use wild cards in the where clause of an SQL statement The __ operator allows to use wild cards in the where clause of an SQL statement.
(A) FROM
(B) LIKE
(C) IN
(D) None of the above
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
(A) SELECT FROM * Persons
(B) SELECT * FROM Persons
(C) SELECT * WHERE Persons
(D) SELECT WHERE * Persons
Which of the following is used with INSERT command to insert values in a DB table?
(A) INTO
(B) ONTO
(C) WITH
(D) UPTO