0

databases Online Quiz - 69

Description: databases Online Quiz - 69
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

MYISAM is the default mysql search engine?

  1. True

  2. False


Correct Option: A
  1. To update or change the root password

  2. To setup root password for first time

  3. A and B

  4. None of the above


Correct Option: B
  1. /etc/my.conf

  2. /etc/my.cnf

  3. /etc/mysq.conf

  4. /etc/mysql.cnf


Correct Option: B

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?

  1. SET NOCOUNT ON

  2. SET ARITHABORT ON

  3. SET NOCOUNT OFF

  4. SET ARITHABORT OFF


Correct Option: A
  1. A SELECT statement that uses WHERE column_name = NULL returns no results

  2. A SELECT statement that uses WHERE column_name = NULL returns the rows that have null values in column_name.

  3. A SELECT statement that uses WHERE column_name = NULL will throw error.

  4. A SELECT statement that uses WHERE column_name = NULL returns all the rows.


Correct Option: B

When SET QUOTED_IDENTIFIER is ON which will be true?

  1. Identifiers can be delimited by double quotation marks, and literals can not be delimited by single quotation marks

  2. Identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks

  3. Identifiers can not be delimited by double quotation marks, and literals must be delimited by single quotation marks

  4. Identifiers can not be delimited by double quotation marks, and literals can not be delimited by single quotation marks


Correct Option: B
  1. Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to OFF

  2. setting ANSI_WARNINGS to ON will not affect ARITHABORT settings

  3. Both are same

  4. Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to ON


Correct Option: D

How many controfiles can be created in a Oracle Database

  1. 8

  2. 7

  3. 10

  4. 3


Correct Option: A
  1. Automatic Database Diagnostic Monitor

  2. Automatic Diagnostic Database Monitor

  3. Automatic Data Diagnostic Monitor

  4. None of the above


Correct Option: A

How do you gather statistics in Oracle 10g

  1. AWR

  2. Statspack

  3. TKProf

  4. Utlb/Utle


Correct Option: A,B,C

In which tablespace AWR data is stored

  1. SYSTEM

  2. USERS

  3. SYSAUX

  4. INDEX


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


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?

  1. 1

  2. 100

  3. 10

  4. Error


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?

  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


Correct Option: B
  1. Any constraints defined on the MGR_ID column would be removed by the above command

  2. Any views created on the EMP table that include the MGR_ID column would have to bve dropped and re-created

  3. Any index created on the MGR_ID column would continue to exists until the DROP UNUSED COLUMNS command is executed.

  4. Any synonym existing on the EMP table would have to be re-created


Correct Option: D
- Hide questions