SQL
1. Point out the wrong statement :
a) SQL injection vulnerabilities occur whenever input is used in the construction of an SQL query without being adequately constrained or sanitized
b) SQL injection allows an attacker to access the SQL servers and execute SQL code under the privileges of the user used to connect to the database
c) The use of PL-SQL opens the door to these vulnerabilities
d) None of the mentioned
2. Which of the following is not a limitation of view?
a) ORDER BY Does Not Work
b) Index Created on View Used Often
c) Cross Database Queries Not Allowed in Indexed View
d) Adding Column is Expensive by Joining Table Outside View
3. Which of the following is one of the basic approaches for joining tables?
a) Subqueries
b) Union Join
c) Natural join
d) All of the Mentioned
4. A Boolean data type that can take values true, false, and ____________
a) 1
b) 0
c) Null
d) Unknown
5. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?
a) Equi-join
b) Cartesian join
c) Outer join
d) Natural join
7. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
a) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
b) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
c) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
d) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70
8. Which of the following FORWARD ONLY Cursor is populated at the time of creation ?
a) KEYSET
b) FORWARD_ONLY STATIC
c) FAST_FORWARD
d) All of the mentioned
9. Which of the following functions are similar ?
a) RANK and NTILE
b) RANK and DENSE_RANK
c) DENSE_RANK and NTILE
d) None of the mentioned
10. LAST_VALUE comes in the category of :
a) Ranking window function
b) Associate window function
c) Analytic window functions
d) All of the mentioned
{"name":"SQL", "url":"https://www.quiz-maker.com/QVTDY4W","txt":"1. Point out the wrong statement :, 2. Which of the following is not a limitation of view?, 3. Which of the following is one of the basic approaches for joining tables?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}