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.
[wpdreams_ajaxsearchlite]

GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?

by

(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 … Read more

What are the fourth and fifth steps in developing a POS?

by

(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 [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct … Read more

Which of the following is the correct syntax for adding a new column into an existing table?

by

(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 [showhide type=”post” more_text=”►Correct Option” less_text=”Show less…”] Correct Option is: B [/showhide]