In SQL, what is the purpose of the LIKE operator? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which of the following is a non-aggregate function in SQL?
Correct Answer: Option B
Explanation:
LENGTH() (or LEN()) is a string function that returns the length of a string, not an aggregate. SUM, COUNT, AVG are aggregates.
LENGTH() (or LEN()) is a string function that returns the length of a string, not an aggregate. SUM, COUNT, AVG are aggregates.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following describes an 'Entity' in database terms?
Correct Answer: Option C
Explanation:
An Entity is a distinguishable real-world object, place, person, or concept captured within a database schema (e.g., Customer, Product).
An Entity is a distinguishable real-world object, place, person, or concept captured within a database schema (e.g., Customer, Product).
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which of the following is a valid SQL statement to create a view?
Correct Answer: Option D
Explanation:
Both syntaxes are valid: CREATE VIEW view_name AS SELECT ... and with column aliases.
Both syntaxes are valid: CREATE VIEW view_name AS SELECT ... and with column aliases.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!