0

databases Online Quiz - 183

Description: databases Online Quiz - 183
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Perform Object Java Oriented

  2. Plain Object Java Old

  3. Platform Oriented Java Object

  4. Plain Old Java Object


Correct Option: D

Examine this TRUNCATE TABLE command: - 68 - TRUNCATE TABLE departments; Which statements are true about the command?

  1. All extents are released.

  2. All rows of the table are deleted.

  3. Any associated indexes are truncated.

  4. No undo data is generated for the table's rows.


Correct Option: B,C,D

You are logged on to a client. You do not have a secure connection from your client to the host where your Oracle database is running. Which authentication mechanism allows you to connect to the database using the SYSDBA privilege?

  1. Control file authentication

  2. Password file authentication

  3. Data dictionary authentication

  4. Operating system authentication


Correct Option: B
  1. The resulting index may contain deleted entries.

  2. A new index is built using an existing index as the data source.

  3. Queries cannot use the existing index while the new index is being built.

  4. During a rebuild, sufficient space is needed to accommodate both the old and the new


Correct Option: B,D
  1. STARTUP

  2. STARTUP OPEN

  3. STARTUP MOUNT

  4. STARTUP NOMOUNT


Correct Option: D

Which data dictionary view shows the available free space in a certain tablespace?

  1. DBA_EXTENTS

  2. V$FREESPACE

  3. DBA_FREE_SPACE

  4. DBA_FREE_EXTENTS


Correct Option: C

what are the three main components in Hibernate architecture?

  1. Connection Management

  2. Bean Management

  3. Transaction Management

  4. Object relational mapping

  5. Relational Management


Correct Option: A,C,D

Can a query defining the 'view' include the ORDER BY clause?

  1. True

  2. False


Correct Option: A

A CLOB (character large object) data type store upto____character?

  1. 1,147,483,647

  2. 2,147,483,647

  3. 3,147,483,647

  4. 4,147,483,647


Correct Option: B

How many defaults can be placed on one column of a Table?

  1. 50

  2. up to 1000

  3. 10,000

  4. N number


Correct Option: D

Suppose emp table contains 5 records then Select 1 from emp; o/p ?

  1. 5

  2. 1

  3. five times 1

  4. one time 5


Correct Option: C

What is the difference between GROUP BY and ORDER BY clause in SQL?

  1. GROUP BY controls presentation of rows and ORDER BY controls presentation of columns for results of SELECT statement

  2. GROUP BY controls presentation of columns and ORDER BY controls presentation of rows for results of SELECT statement

  3. GROUP BY orders rows in query's return and ORDER BY orders columns in query's return

  4. none


Correct Option: A

How we will browse IMS data Base

  1. FILE AID

  2. BIND

  3. PLAN

  4. NONE


Correct Option: A

IS IT POSSIBLE TO UPDATE KEY FIELD OF A SEGMENT?

  1. True

  2. False


Correct Option: A

WHAT ARE THE CONTROL BLOCKS IN IMS DB?

  1. DBD

  2. PSB

  3. PCB

  4. IMSCB


Correct Option: A,B,C

IS IT POSSIBLE A SEGMENT WITH OUT PARENT?

  1. True

  2. False


Correct Option: A

WHICH FIELD IS USED TO IDENTIFY THE OCCURENCE OF THE SEGMENT?

  1. SEARCH FIELD

  2. KEY FIELD

  3. BOTH

  4. NONE


Correct Option: B

What are the processing modes available in IMS DB?

  1. BATCH DL/I

  2. MPP

  3. BMP

  4. ALL


Correct Option: D

NUMBER OF PCBS ALLOWED IN A PSB?

  1. 15

  2. 255

  3. 1

  4. NO LIMITATIONS


Correct Option: D

MAXIMUM NUMBER OF FIELDS ALLOWED PER SEGMENT?

  1. 15

  2. 255

  3. 1000

  4. 1


Correct Option: B
- Hide questions