Question 1

MYISAM is the default mysql search engine?

technology databases

True
False

Answer

Correct Option: A

Question 2

The follwing command is used to take the mysql backup?

technology databases

mysql
mysqlbackup
mysqldump
mydump

Answer

Correct Option: C

Question 3

The syntax means that "mysqladmin -u root password NEWPASSWORD"

technology databases

To update or change the root password
To setup root password for first time
A and B
None of the above

Answer

Correct Option: B

Question 4

Which one is mysql configuraion file?

technology databases

/etc/my.conf
/etc/my.cnf
/etc/mysq.conf
/etc/mysql.cnf

Answer

Correct Option: B

Question 5

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?

technology databases

SET NOCOUNT ON
SET ARITHABORT ON
SET NOCOUNT OFF
SET ARITHABORT OFF

Answer

Correct Option: A

Question 6

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?

technology databases

SET NOCOUNT OFF
SET XACT_ABORT ON
SET NOCOUNT ON
SET XACT_ABORT OFF

Answer

Correct Option: C

Question 7

When SET ANSI_NULLS is OFF then which one is true?

technology databases

A SELECT statement that uses WHERE column_name = NULL returns no results
A SELECT statement that uses WHERE column_name = NULL returns the rows that have null values in column_name.
A SELECT statement that uses WHERE column_name = NULL will throw error.
A SELECT statement that uses WHERE column_name = NULL returns all the rows.

Answer

Correct Option: B

Question 8

When SET QUOTED_IDENTIFIER is ON which will be true?

technology databases

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

Answer

Correct Option: B

Question 9

Which one is true?

technology databases

Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to OFF
setting ANSI_WARNINGS to ON will not affect ARITHABORT settings
Both are same
Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to ON

Answer

Correct Option: D

Question 10

Which is not a mandatory background process in Oracle9i

technology databases

PMON
DBWR
MMON
CKPT

Answer

Correct Option: A

Question 11

How many controfiles can be created in a Oracle Database

technology databases

8
7
10
3

Answer

Correct Option: A

Question 12

What does ADDM stands for?

technology databases

Automatic Database Diagnostic Monitor
Automatic Diagnostic Database Monitor
Automatic Data Diagnostic Monitor
None of the above

Answer

Correct Option: A

Question 13

Multiplexing of controlfiles means:

technology databases

True
False

Answer

Correct Option: A

Question 14

How do you gather statistics in Oracle 10g

technology databases

AWR
Statspack
TKProf
Utlb/Utle

Answer

Correct Option: A,B,C

Question 15

What is default Pctused in Oracle?

technology databases

20
30
40
50

Answer

Correct Option: C

Question 16

In which tablespace AWR data is stored

technology databases

SYSTEM
USERS
SYSAUX
INDEX

Answer

Correct Option: C

Question 17

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

It would be created only if a unique index is manually created first.
It would be created and would ues an automatically created no unique index
It would be created and would use an automatically created unique index
It would be created and reamins in a disabled state because no index is specified in the command

Answer

Correct Option: C

Question 18

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
100
10
Error

Answer

Correct Option: B

Question 19

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

SCOTT would be not able to query the OE.ORDERS tables
SCOTT would be able to query the OE.ORDERS tables
The revoke statment would remove the SELECT privilege from SCOTT as well as from the role r1
The revoke statment would give an error because the select privilege has been granted to the role r1

Answer

Correct Option: B

Question 20

Evalute the follwing SQL statements? ALTER TABLE HR.EMP SET UNUSED ( MGR_ID ); which statements is true ?

technology databases

Any constraints defined on the MGR_ID column would be removed by the above command
Any views created on the EMP table that include the MGR_ID column would have to bve dropped and re-created
Any index created on the MGR_ID column would continue to exists until the DROP UNUSED COLUMNS command is executed.
Any synonym existing on the EMP table would have to be re-created

Answer

Correct Option: D

Description: databases Online Quiz - 69
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 69

Find more quizzes from top tags