• databases Online Quiz - 7
Back
0

databases Online Quiz - 7

Description: databases Online Quiz - 7
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

what does the query select * from table_abc where column_xyz like '%oracle%'
technology databases

  1. selects all the rows from the table having the column_xyz value starting with the word oracle

  2. selects all the rows from the table having the column_xyz value ending with the word oracle

  3. selects all the rows from the table having the column_xyz value containing the word oracle

  4. selects all the rows from the table having the column_xyz value not containing the word oracle

Show answer
Correct Option: C

Which of the following returns 123.46
technology databases

  1. abs(-123.456)

  2. trunc(123.456,2)

  3. round(123.456,2)

  4. avg(1,2,3,4,5)

Show answer
Correct Option: C

What does initcap('oracle') return?

technology databases

  1. O

  2. oracle

  3. Oracle

  4. ORACLE

Show answer
Correct Option: C

What does the function months_between('02-feb-2001','01-jan-2001') return?
technology databases

  1. 8

  2. 30

  3. 1.03225806

  4. .998989989

Show answer
Correct Option: C

What does the function next_day('14-mar-2001','tuesday') return?

technology databases

  1. '14-mar-2002'

  2. '13-mar-2001'

  3. '20-mar-2001'

  4. '14-apr-2001'

Show answer
Correct Option: C

What does trunc(datetime) do?
technology databases

  1. removes the time component from a date_time value

  2. removes the date component from a date_time value

  3. removes the day component from a date_time value

  4. removes the year component from a date_time value

Show answer
Correct Option: A

Which of the following functions is used to convert a date to a string in the specified format?

technology databases

  1. to_date(string,format)

  2. to_char(date,format)

  3. to_date(date,format)

  4. to_number(string,format)

Show answer
Correct Option: B

How to analyse presssure in the processor

technology databases

  1. % processor time >80

  2. % processor time <80

  3. Processor queue length>2

  4. Batch request/sec

  5. sql compilation./sec

  6. sql recompilation/sec

Show answer
Correct Option: B,D,E,F

IMS Db uses what kind of database management

technology databases

  1. network

  2. relational

  3. hierarchical

  4. object-oriented

Show answer
Correct Option: C

What is the advantage of IMS DB?

technology databases

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management

Show answer
Correct Option: A

Which of the following is true about DBD ?

technology databases

  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN

Show answer
Correct Option: D

A segment has 3 occurrences for a parent. This segment is called a

technology databases

  1. multiple

  2. twin

  3. sibling

  4. none of these

Show answer
Correct Option: B

What information is not included in DBD

technology databases

  1. access method

  2. segment name

  3. parameter

  4. key field length

Show answer
Correct Option: C

IMS Db uses what kind of database management

technology databases

  1. network

  2. relational

  3. hierarchical

  4. object-oriented

Show answer
Correct Option: C

What is the advantage of IMS DB?
technology databases

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management

Show answer
Correct Option: A

Which of the following is true about DBD ?

technology databases

  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN

Show answer
Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) multiple DBDs for each database - This option is incorrect. In a database management system, there is typically one DBD (Database Description) for each database. The DBD contains information about the structure and organization of the database.

Option B) none of these - This option is incorrect.

Option C) cannot be used by DL/I - This option is incorrect. DBD (Database Description) is used in conjunction with DL/I (Data Language/I) to access and manipulate data stored in hierarchical databases.

Option D) created by a process called DBDGEN - This option is correct. DBD (Database Description) is created using a process called DBDGEN. DBDGEN is a utility that generates the DBD based on the database schema and specifications.

Therefore, the correct answer is option D) created by a process called DBDGEN.

A segment has 3 occurrences for a parent. This segment is called a

technology databases

  1. multiple

  2. twin

  3. sibling

  4. none of these

Show answer
Correct Option: B

What information is not included in DBD

technology databases

  1. access method

  2. segment name

  3. parameter

  4. key field length

Show answer
Correct Option: C

IMS Db uses what kind of database management

technology databases

  1. network

  2. relational

  3. hierarchical

  4. object-oriented

Show answer
Correct Option: C

What is the advantage of IMS DB?
technology databases

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions