(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
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
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