(A) True
(B) False
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.
Identify the basic part(s) of a SELECT statement?
(A) SELECT
(B) FROM
(C) Both SELECT and FROM
(D) DISTINCT
REVOKE is a __ statement.
(A) Data Definition
(B) Control access
(C) Data manipulation
(D) Data description
__ User Interface is preferred over __ User Interface with respect to user.
(A) Easy to understand, efficient
(B) Hard to understand, efficient
(C) Easy to understand, effective
(D) Hard to understand, effective
GRANT is a __ Command.
(A) DCL
(B) DML
(C) DDL
(D) None of the above
Which of the following is incorrect about alter table statement?
(A) Cannot be used to modify type or size of an existing column
(B) Can be used to delete a column
(C) Can not be used to create a new table
(D) Can be used to add column in the existing table
Value of a function in SQL is always determined by the input parameters.
(A) True
(B) False
Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.
(A) True
(B) False