MELINIA - SEQUELVERSE - ROUND 1

Which SQL statement is used to limit the number of results returned from a query?

• Fetch

• Count

• Limit

• Top

1. Which of the following statements is true concerning routines and triggers?

• Both consist of procedural code

• Both have to be called to operate.

• Both run automatically.

• Both are stored in the database

1. SELECT COUNT(DISTINCT department) FROM employees;

What does this query calculate?

• The total number of employees in each department

• The number of distinct departments in the "employees" table

•  The total number of employees in the "employees" table

• The number of distinct employees

Embedded SQL is which of the following?

• Hard-coded SQL statements in a program language such as Java

• The process of making an application capable of generating specific SQL code on the fly

• Hard-coded SQL statements in a procedure

• Hard-coded SQL statements in a trigger

Which of the following is not a built-in function in SQL

• DATE_ADD( )

•  DATE_SUB( )

• DATE_DIFF( )

• DATE_FORMAT( )

1. When the SQL query is executed the result is?

• A blank screen

• A table

•  A row

• All of these

Which of the below is an invalid query

• SELECT Unique(name) FROM DataFlair;

• SELECT * FROM DataFlair Where experience!=0;

  
  

• Select name FROM DataFlair;

• None of these

What happens when no value is inserted in an ENUM list?

• nothing will happen

• the code will crash

• blank value is inserted

• none of the above

Which SQL constraint do we use to set some value to a field whose value has not been added explicitly

Which of the following matches the definition given below: It is an artificial key that aims to uniquely identify each record

• Primary Key

• Foreign Key

• Surrogate Key

• Composite Key