Linux Certification Quiz

1

Instructions For Quiz

This Mock Test has 15 Questions
Each Question is of 1 marks so total 15 marks
Multiple Choice Questions with only ONE valid answer

2

1) How many bytes can be stored by varchar?* This field is required.

Upto 2000 bytes

Upto 3000 bytes

Upto 4000 bytes

Upto 1000 bytes

3

2) Select the number of bytes that can be stored by the varchar2.* This field is required.

Upto 1000 bytes

Upto 3000 bytes

Upto 4000 bytes

Upto 2000 bytes

4

3) The maximum size for a raw in a table in* This field is required.

26764 bytes.

30767bytes.

28766bytes.

32767 bytes.

5

4) A BLOB data type is a varying length_________string which is used to store two gigabytes memory* This field is required.

Hexadecimal

Decimal

Octal

Binary

6

5) What is DML?* This field is required.

Data Manipulation Language

Distributed Manipulation Language

Dynamic Manipulation Language

Dynamic Modeling Language

7

6) Select the command which is used for character by character substitution.* This field is required.

REPLACE

TRANSLATE

DISTINCT

TRANSMIT

8

7) Duplicate rows can be removed by using the keyword _________ in the select statement.* This field is required.

DELETE

DUPLICATE

DISTINCT

DESTROY

9

8) What is NOT aggregate functions?* This field is required.

Sum

Substract

Count

Average

10

9) Which of the following is a type of Subquery* This field is required.

Correlated sub query

Corrected sub query

Collected sub query

Non-Corrugated sub query

11

10) Which of the following is NOT a temporal data type?* This field is required.

Time Data Type

Date Data Type

Internal Data Type

TimeStamp Data Type

12

11) Select the command which is used to delete the duplicate rows in the table.* This field is required.

ROWINO

ROWID

ROWNAME

ROWIDNO

13

12) Which of the following is NOT an attribute of cursor.* This field is required.

%FOUND

%NOT FOUND

%ISOPEN

%OPEN

14

13)How can we store pictures in the database?* This field is required.

Long Raw Data type

Long Data type

Float Raw Data type

Double t Raw Data type

15

14) Select the constraint used to validate that values in the given column meet the specific criteria.* This field is required.

DEFAULT

NOT NULL

NULL

CHECK

16

15) SSelect the Oracle database object used for performance tuning* This field is required.

Tablespace

Sequence

Index

Table