(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
Tag: DBMS Mcq
Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age; The statement has a syntax error?
(A) The statement displays the entire fields from emp in which the Empname is ALI in any order
(B) The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age
(C) The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age
(D) None of the above
Which of the following is a String function in SQL?
(A) Count
(B) LEN
(C) SQRT
(D) SIN
Truncate command responses time is __ as compared to delete command.
(A) Poor
(B) Same
(C) Better
(D) Worst
Which of the following is not true regarding clustering ?
(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 record from different tables to places in adjacent physical locations.
Update command belong to which type of classification?
(A) DML
(B) DDL
(C) DCL
(D) DQL
Grant belong to which types of SQL command classification?
(A) DML
(B) DDL
(C) DCL
(D) DQL
In SQL queries, while creating tables or relations in database, key columns may be specified by?
(A) Bull
(B) Not Null
(C) Data Type
(D) None of the above