Crowdly

Add to Chrome

Questions Bank (1485981 total)

Using optimized sorting algorithms does not significantly reduce the number of required runs.

The precedence graph is using an undirected graph

True

False

View this question

Retrieve the current salary of an employee

Which SQL query retrieves the current salary of an employee with emp_no = 20005?

SELECT salary FROM employees WHERE emp_no = 20005;

❌

SELECT salary FROM salaries WHERE emp_no = 20005;

❌

SELECT salary FROM salaries WHERE emp_no = 20005 AND to_date = '9999-01-01';

✅

SELECT salary FROM dept_emp WHERE emp_no = 20005;

❌

View this question

Find the job title of an employee

Which SQL query retrieves the title of an employee with emp_no = 30001?

SELECT title FROM titles WHERE emp_no = 30001;

SELECT title FROM titles WHERE emp_no = 30001 AND to_date = '9999-01-01';

SELECT title FROM salaries WHERE emp_no = 30001;

SELECT title FROM employees WHERE emp_no = 30001;

View this question

Retrieve employee birth dates

Which SQL query retrieves the birth date of the employee with emp_no = 10500?

SELECT birth_date FROM employees WHERE emp_no = 10500;

✅

SELECT birth_date FROM employees WHERE first_name = 'John';

❌

SELECT birth_date FROM salaries WHERE emp_no = 10500;

❌

SELECT emp_no FROM employees WHERE birth_date = '1990-05-10';

❌

View this question

Find employees in a specific department

Which SQL query retrieves the employee numbers of all employees working in department 'd002'?

SELECT emp_no FROM dept_emp WHERE dept_no = 'd002';

✅

SELECT emp_no FROM departments WHERE dept_no = 'd002';

❌

SELECT emp_no FROM salaries WHERE dept_no = 'd002';

❌

SELECT dept_no FROM employees WHERE dept_no = 'd002';

❌

View this question

Commited is an attribute that does not represent a valid state of a transaction

True

False

View this question

In a fully distributed locking scheme, locks on a copy of an object are maintained on the node where the copy is stored, leading to potential contention when writing an object across multiple nodes

SQL Injection represents masking or verifying the signs in the user's input data, within SQL databases

Union operation can be optimized using both sorting and hashing approaches

Previous
1
140242
140243
140244
140245
140246
148599
Next

Telegram Instagram TikTok Question Bank

Add to Chrome