Tag: databases

Questions Related to databases

Which is not a mandatory background process in Oracle9i
technology databases

  1. PMON

  2. DBWR

  3. MMON

  4. CKPT

Show answer
Correct Option: A

How many controfiles can be created in a Oracle Database
technology databases

  1. 8

  2. 7

  3. 10

  4. 3

Show answer
Correct Option: A

What does ADDM stands for?

technology databases

  1. Automatic Database Diagnostic Monitor

  2. Automatic Diagnostic Database Monitor

  3. Automatic Data Diagnostic Monitor

  4. None of the above

Show answer
Correct Option: A

Multiplexing of controlfiles means:

technology databases

  1. True

  2. False

Show answer
Correct Option: A

How do you gather statistics in Oracle 10g
technology databases

  1. AWR

  2. Statspack

  3. TKProf

  4. Utlb/Utle

Show answer
Correct Option: A,B,C

What is default Pctused in Oracle?

technology databases

  1. 20

  2. 30

  3. 40

  4. 50

Show answer
Correct Option: C

In which tablespace AWR data is stored

technology databases

  1. SYSTEM

  2. USERS

  3. SYSAUX

  4. INDEX

Show answer
Correct Option: C
  1. 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?
technology databases

  1. It would be created only if a unique index is manually created first.

  2. It would be created and would ues an automatically created no unique index

  3. It would be created and would use an automatically created unique index

  4. It would be created and reamins in a disabled state because no index is specified in the command

Show answer
Correct Option: C

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?
technology databases

  1. 1

  2. 100

  3. 10

  4. Error

Show answer
Correct Option: B

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?

technology databases

  1. SCOTT would be not able to query the OE.ORDERS tables

  2. SCOTT would be able to query the OE.ORDERS tables

  3. The revoke statment would remove the SELECT privilege from SCOTT as well as from the role r1

  4. The revoke statment would give an error because the select privilege has been granted to the role r1

Show answer
Correct Option: B