Header Ads

Showing posts from March 28, 2021Show all
Which two statements complete a transaction? A. DELETE employees; B. DESCRIBE employees; C. ROLLBACK TO SAVEPOINT C; D. GRANT SELECT ON employees TO SCOTT; E. ALTER TABLE employees MODIFY COLUMN sal; F. Select MAX(sal) FROM employees WHERE department_id=20;

Which two statements complete a transaction? A. DELETE employees; B. DESCRIBE employees; C. ROLLBACK TO SAVEPOINT C; D. GRANT SELECT ON employees TO SCOTT; E. ALTER TABLE employees MODIFY COLUMN sal; F. Select MAX(sal) FROM employees WHERE department_id=20; 5:53 AM

What TCL commands are supported by SQL?

What TCL commands are supported by SQL? 5:52 AM

What the function is of redo and undo logs?

What the function is of redo and undo logs? 5:50 AM

What do you understand by ACID properties of database transaction?

What do you understand by ACID properties of database transaction? 5:49 AM

Why do understand by transaction COMMIT and ROLLBACK?

Why do understand by transaction COMMIT and ROLLBACK? 5:47 AM

What to you understand by a database transaction?

What to you understand by a database transaction? 5:46 AM

What is a savepoint?

What is a savepoint? 5:44 AM

What are the two ways in which multiple transactions can be executed?

What are the two ways in which multiple transactions can be executed? 5:43 AM

Define a transaction.

Define a transaction. 5:41 AM

Consider the following tables Item and Customer. Write SQL commands for the statement (i) to (iv) and give outputs for SQL queries (v) to (viii)

Consider the following tables Item and Customer. Write SQL commands for the statement (i) to (iv) and give outputs for SQL queries (v) to (viii) 5:40 AM

What do you understand by the candidate key and cardinality of a relation in relational data base?

What do you understand by the candidate key and cardinality of a relation in relational data base? 5:39 AM

What do you understand by the terms primary key and degree of a relation in relational data base?

What do you understand by the terms primary key and degree of a relation in relational data base? 5:38 AM

What is difference between char and varchar?

What is difference between char and varchar? 5:36 AM

How SQL commands are are classified?

How SQL commands are are classified? 5:35 AM

Differeniate WHERE and HAVING clause?

Differeniate WHERE and HAVING clause? 5:32 AM

Identify the error? DELETE ALL FROM TABLE EMP;

Identify the error? DELETE ALL FROM TABLE EMP; 5:31 AM

What is error in following statement? UPDATE EMPL;

What is error in following statement? UPDATE EMPL; 5:29 AM

What is NOT NULL constraint?

What is NOT NULL constraint? 5:28 AM

What is NOW() function in MySql?

What is NOW() function in MySql? 5:27 AM

How would you display system date as the result of a query?

How would you display system date as the result of a query? 5:26 AM

Which keyword eliminates redundant data in from a query result?

Which keyword eliminates redundant data in from a query result? 5:25 AM

What is null value in MySql?

What is null value in MySql? 5:24 AM

Maximum how many characters can be stored in a (i) text literals (ii) numeric literal

Maximum how many characters can be stored in a (i) text literals (ii) numeric literal 5:23 AM

What are DML commands?

What are DML commands? 5:22 AM