databases Online Quiz - 69
|Description: databases Online Quiz - 69|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
MYISAM is the default mysql search engine?
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 SET QUOTED_IDENTIFIER is ON which will be true?
Which one is true?
Which is not a mandatory background process in Oracle9i
How many controfiles can be created in a Oracle Database
What does ADDM stands for?
Multiplexing of controlfiles means:
How do you gather statistics in Oracle 10g
What is default Pctused in Oracle?
In which tablespace AWR data is stored
- Evalute the CREAT TABLE Statement: CREATE TABLE products (prod_id NUMBER(6) CONSTRAINT PROD_ID_PK PRIMARY KEY, product_name VARCHAR2(10)) ; Which statement is true regarding the PROD_ID_PK constraint?
Evalute the CREAT SEQUENCE Statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE ; The Sequence seq1 has generated upto the maximum limit of 200 .you issue the following SQL statement SELECT seq1.NEXTVAL from dual ; what is the output?
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 ?