databases Online Quiz - 69
|Description: databases Online Quiz - 69|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
The follwing command is used to take the mysql backup?
Which one is mysql configuraion file?
When we use SELECT and DML statement in SQL, SQL server returns a message which specify the number of rows effected by these statements. How to disable this?
when you execute a T-SQL statement (INSERT, UPDATE, SELECT, DELETE) in a new query window, you see a message that says how many rows affected in the result window. How to disable this?
Which one is true?
What is default Pctused in Oracle?
OE and SCOTT are the users in the DB.the ORDERS tables is owned by OE.Evalute the statements by the DBA in the following sequence: CREATE ROLE r1; GRANT SELECT ,INSERT ON OE.ORDERS TO r1; GRANT r1 TO SCOTT; GRANT SELECT ON OE.ORDERS TO SCOTT; REVOKE SELECT ON OE.ORDERS FROM SCOTT; what is the output after executing the statements?
Evalute the follwing SQL statements? ALTER TABLE HR.EMP SET UNUSED ( MGR_ID ); which statements is true ?