Home › Quizzes › Database Management Systems (NCO)

Database Management Systems (NCO)

Data Base Management systems

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

A computer contains several records. What does each record contain?

  1. Bytes
  2. Words
  3. Fields
  4. Database
  5. _
Question 2 Multiple Choice (Single Answer)

What type of language is used by most of the DBMS for helping their users to access data?

  1. High level language
  2. Query language
  3. SQL
  4. 4GL
  5. _
Question 3 Multiple Choice (Single Answer)

Which language has recently become the defacto standard for interfacing application programs with relational database systems?

  1. Oracle
  2. SQL
  3. dBASE
  4. 4GL
  5. _
Question 4 Multiple Choice (Single Answer)

In any hierarchy of data organisation, what is the smallest entity to be processed as a single unit called?

  1. Data field
  2. Data record
  3. Data file
  4. Database
  5. _
Question 5 Multiple Choice (Single Answer)

Which OEM tool will we use to create a logical object in which rollback segments are stored?

  1. Data Manager
  2. Schema Manager
  3. Storage Manager
  4. Instance Manager
  5. _
Question 6 Multiple Choice (Single Answer)

Which of the following SQL commands would you use to query data?

  1. DROP
  2. SELECT
  3. ALTER
  4. INSERT
  5. _
Question 7 Multiple Choice (Single Answer)

Which type of system would be insert/delete intensive?

  1. DSS
  2. OLTP
  3. Data warehouse
  4. DML
  5. _
Question 8 Multiple Choice (Single Answer)

Which protocol should be configured from the client-side before you attempt to use the host-naming method?

  1. BEQ
  2. IPC
  3. TCP/IP
  4. DECNet
  5. _
Question 9 Multiple Choice (Single Answer)

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

  1. Full media
  2. Graphics media
  3. Multimedia
  4. Hypertext
  5. _
Question 10 Multiple Choice (Single Answer)

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

  1. Bits
  2. Characters
  3. Data field
  4. Schema
  5. _
Question 11 Multiple Choice (Single Answer)

Which background process periodically reclaims space used by temporary segments that are no longer being used?

  1. SMON
  2. PMON
  3. ARCH
  4. DBWR
  5. _
Question 12 Multiple Choice (Single Answer)

Which of the following constraints should you use to ensure that the combination of values in the JOB and TITLE columns in the EMPLOYEE table is unique?

  1. NULL
  2. CHECK
  3. UNIQUE
  4. FOREIGN KEY
  5. _
Question 13 Multiple Choice (Single Answer)

Which logical database structure can be switched between read-write and read-only status?

  1. Extent
  2. Segment
  3. Database
  4. Tablespace
  5. _
Question 14 Multiple Choice (Single Answer)

Which Net8 architecture layer provides a common protocol interface to industry standard protocols?

  1. OCI
  2. TNS
  3. Protocol
  4. Application
  5. _
Question 15 Multiple Choice (Single Answer)

Which of the following types of storage structures can be used to create three tables that will be frequently joined based on similar key column values?

  1. LOB
  2. Hash cluster
  3. Nested table
  4. Index cluster
  5. _
← Back to Quizzes