Category: Database Mcqs

(A) Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table
(B) Grant permission to Hiruni in order to grant, select and update permission to Amali
(C) Grant permission to Amali & Hiruni to update designation of employees in the Employee table
(D) Grant permission to Amali & Hiruni to update designation of employees in the Employee table

(A) Available resources
(B) Data environment
(C) Current operations
(D) Business objectives

(A) Define the entities, attributes, relationships, connectivities, cardinalities, and constraints. Create the initial ERD segments
(B) Develop business rules. Create the initial ERD segments
(C) Develop business rules. Define the entities, attributes, relationships, connectivities, cardinalities, and constraints
(D) Define the major transaction modules. Create the initial ERD segments

(A) ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
(B) ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
(C) Both I and II
(D) None of the above

(A) IN
(B) FROM
(C) LIKE
(D) None of the above

(A) attributes
(B) entities
(C) keys
(D) indexes

(A) erson’s phone number
(B) car’s color
(C) employee’s educational background
(D) computer’s processor speed

(A) Database
(B) DBMS
(C) Data model
(D) Data