Sail E0 Webinar

MCQs

Total Questions : 12 | Page 1 of 2 pages
Question 1. Which of the following is not a aggregate function ?
  1.    Avg
  2.    Sum
  3.    With
  4.    Min
 Discuss Question
Answer: Option C. -> With


With is used to create temporary relation and its not a aggregate function.


Question 2. SQL query to find the temperature in increasing order of all cities.
  1.    SELECT city FROM weather ORDER BY temperature
  2.    SELECT city, temperature FROM weather
  3.    SELECT city, temperature FROM weather ORDER BY temperature
  4.    SELECT city, temperature FROM weather ORDER BY city
 Discuss Question
Answer: Option D. -> SELECT city, temperature FROM weather ORDER BY city


The ORDER BY keyword sorts the records in ascending order by default.


Question 3. With SQL, how can you return the number of not null records in the "Persons table ?
  1.    SELECT COUNT() FROM Persons
  2.    SELECT COLUMNS() FROM Persons
  3.    SELECT COLUMNS(*) FROM Persons
  4.    SELECT COUNT(*) FROM Persons
 Discuss Question
Answer: Option A. -> SELECT COUNT() FROM Persons


COUNT(column_name) is used to count the number of rows of a table where column name is a column that does not allow NULL values.


Question 4. Which of the following is not a mathematical function ?
  1.    ATN2
  2.    POWER
  3.    PI
  4.    CEIL
 Discuss Question
Answer: Option D. -> CEIL


SQL Server has CEILING fuction to get the smallest integer greater than the specified expression.


Question 5. Which of the following SQL clauses is used to DELETE tuples from a database table ?
  1.    DELETE
  2.    REMOVE
  3.    DROP
  4.    CLEAR
 Discuss Question
Answer: Option A. -> DELETE


The SQL DELETE Query is used to delete the existing records from a table.


Question 6. LocalDB was introduced in which of the following versions of SQL Server ?
  1.    2012
  2.    2008
  3.    2014
  4.    2008 R2
 Discuss Question
Answer: Option A. -> 2012


LocalDB was introduced in SQL Server 2012 CTP3. It?s basically a new version of SQL Express, with same functionality, dedicated to developers.


Question 7. A column of type __________ may contain rows of different data types.
  1.    ntext
  2.    date
  3.    smallmoney
  4.    sql_variant
 Discuss Question
Answer: Option D. -> sql_variant


sql_variant is data type that stores values of various SQL Server-supported data types.


Question 8. Ctrl+K+K shortcut refers to ___________
  1.    Refresh IntelliSense
  2.    Add or remove a bookmark
  3.    Enable all bookmarks
  4.    Move to the next bookmark
 Discuss Question
Answer: Option B. -> Add or remove a bookmark


To toggle bookmarks on/off within SSMS, press Ctrl+K+K.


Question 9. Template Explorer is used to manage ____________
  1.    T-SQL scripts
  2.    Registered Servers
  3.    Properties
  4.    Query design
 Discuss Question
Answer: Option A. -> T-SQL scripts


Template Explorer is used to create and manage T-SQL code templates.


Question 10. Which of the following is one of the basic approaches for joining tables?
  1.    Subqueries
  2.    Union Join
  3.    Natural join
  4.    All of the Mentioned
 Discuss Question
Answer: Option D. -> All of the Mentioned




Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0