Query Quest - Internal

TEAM NAME

Which of the following statement is correct to display all the cities with the condition, temperature, and humidity whose humidity is in the range of 60 to 75 from the 'whether' table?

• SELECT * FROM weather WHERE humidity IN (60 to 75)
• SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75
• SELECT * FROM weather WHERE humidity NOT IN (60 AND 75)
• SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75

Which operator is used to concatenate strings in SQL?

• | |
• +
• &
• CONCAT

If a table has been normalized so that all determinants are candidate keys, then that table is in

• 1NF
• 2NF
• 3NF
• BCNF

Which of the following places the common data elements in order from smallest to largest?

• character, field, record, file, database
• bit, byte, character, record, field, file, database
• character, record, field, database, file
• character, file, record, field, database

Which of the following is a functional dependency?

• A → B means that for each value of A, there is exactly one value of B.
• A → B means that for each value of A, there can be multiple values of B.
• A → B means that B is a primary key.
• A → B means that A and B are both foreign keys.

Which of the following is a common method for achieving concurrency control?

• Two-Phase Locking (2PL)
• Data Redundancy
• Normalization
• Denormalization

What will be the output of the following SQL query? SELECT ROUND(123.4567, 2);

• 123.45
• 123.457
• 123.00
• 123.46

What does the EXISTS keyword do in SQL?

• Checks if a column exists in a table.
• Checks if a subquery returns any rows
• Checks if a table exists in the database.
• Checks if a value exists in a column.

Which of the following statements is true about the UNION operator?

• It combines the results of two queries and removes duplicates.
• It combines the results of two queries and keeps duplicates.
• It can only be used with SELECT statements that have the same number of columns.
• Both A and C