Structured Query Language Multiple Choice Questions and Answers for Interview | Objective Type Questions

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

Questions
11 Which command is used to add a column to an existing table ?
A Create
B Update
C Alter
D None of these

Answer: Option [C]
12 Which one is not an aggregate function in SQL ?
A Count
B Mean
C Min
D All are aggregate function

Answer: Option [B]
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
13 Which one of the following is a valid join type ?
A natural
B full outer join
C on
D using

Answer: Option [B]
14 One of the following steps is not involved in processing a query :
A parsing and translation
B optimization
C evaluation
D distribution

Answer: Option [D]
15 Which of the following statement on the view concept in SQL is invalid ?
A all views are not updatable
B the views may be referenced in an SQL statement whenever tables are referenced
C the views are instantiated at the time they are referenced and not when they are defined
D the definition of a view should not have GROUP BY clause in it

Answer: Option [D]

Random GK Questions

Q. At which Harappan site have traces of a horse been found ?
Q. Sarkaria Commission was constituted to give its report on
Q. Per capita income is obtained by dividing National Income by
Q. What is the implication of the Central Government granting Special Status to a State?
Q. In India, present trend of rapid urbanization is due to:
Q. Which of the following is not helpful in controlling money supply?

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics