(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
Tag: DBMS Mcqs
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
Small organizations usually have complex management structure.
(A) True
(B) False
A __ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
(A) Strong
(B) Weak
(C) Business
(D) Relationship
A super key that does not contain a subset of attributes that is itself a superkey is called a?
(A) Candidate Key
(B) Primary Key
(C) Super Key
(D) Secondary Key