Home › Quizzes › Database Management System

Database Management System

DBMS

26 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

What would be the output of the following SQL query?
SQL>select trunc(19.989776,1) from dual;

  1. 20.0
  2. 19.0
  3. 19.9
  4. None of these
Question 2 Multiple Choice (Single Answer)

Which of the following statements is used in SQL along with aggregate functions?

  1. Order by
  2. Union
  3. Group by
  4. None of these
Question 3 Multiple Choice (Single Answer)

What would be the output of the following SQL query?
SQL> select ltrim(' Harish') from dual;

  1. 'Hari'
  2. 'Rish'
  3. 'Harish'
  4. None of these
Question 4 Multiple Choice (Single Answer)

Which of the following is the default table available in SQL environment, used for mathematical calculation?

  1. emp
  2. dual
  3. dept
  4. none of these
Question 5 Multiple Choice (Single Answer)

Which of the following pools in System Global Area is a memory area used by the Oracle streams product for its functioning?

  1. Streams pool
  2. Large pool
  3. Java pool
  4. None of these
Question 6 Multiple Choice (Single Answer)

Which of the following areas in the Program Global Area, contains bind information and runtime memory structures?

  1. Session memory
  2. SQL work area
  3. Private SQL area
  4. None of these
Question 7 Multiple Choice (Single Answer)

______________ processes are created in Oracle to handle requests made by user processes.

  1. Background
  2. User
  3. Server
  4. None of these
Question 8 Multiple Choice (Single Answer)

Which of the following caches in SGA is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures?

  1. Data dictionary cache
  2. Library cache
  3. Database buffer cache
  4. None of these
Question 9 Multiple Choice (Single Answer)

Which of the following views from Data Dictionary gives information about various database objects?

  1. USER_ALL_DBA_TABLES
  2. USER_ALL_DBA_OBJECTS
  3. USER_ALL_DBA_INDEXES
  4. None of these
Question 10 Multiple Choice (Single Answer)

Which of the following editions of Oracle9i prompts you to select individual components to instal from the components available?

  1. Enterprise edition
  2. Standard
  3. Personal edition
  4. Custom
Question 11 Multiple Choice (Single Answer)

Which of the following avoids the display of identical columns from two tables in an SQL query?

  1. Equi Join
  2. Non-Equi join
  3. Natural join
  4. None of these
Question 12 Multiple Choice (Single Answer)

In Redo Log file, which of the following files contains a number of parameters that can be used to configure the Oracle9i instance?

  1. The archive file
  2. The parameter file
  3. The password file
  4. None of these
Question 13 Multiple Choice (Single Answer)

Which of the following objects in SQL is a virtual table that draws its data from the result of an SQL SELECT statement?

  1. View
  2. Table
  3. Index
  4. None of these
Question 14 Multiple Choice (Single Answer)

Which of the following symbols is used to perform outer join operation in two tables?

  1. -
  2. *
  3. /
  4. +
Question 15 Multiple Choice (Single Answer)

Which of the levels in three-schema architecture describes the relationships exist among data?

  1. Internal level
  2. External level
  3. Conceptual level
  4. None of the above
Question 16 Multiple Choice (Single Answer)

Which of the following fragmentations requires the grouping of attributes into sets that are referenced in the similar manner by applications?

  1. Primary fragmentation
  2. Vertical fragmentation
  3. Horizontal fragmentation
  4. None of the above
Question 17 Multiple Choice (Single Answer)

Which of the following is the second layer in the query processing, responsible to localise the query's data using data distribution information?

  1. Global Query Optimisation
  2. Local Query Optimisation
  3. Data localisation
  4. None of the above
Question 18 Multiple Choice (Single Answer)

__________ is the SQL command, which provides object privileges to other users.

  1. Revoke
  2. Delete
  3. Grant
  4. Drop
Question 19 Multiple Choice (Single Answer)

Which of the following is the design approach, used in vertical fragmentation in which the global relations are progressively split into fragments?

  1. The split approach
  2. The grouping approach
  3. Top-down approach
  4. None of the above
Question 20 Multiple Choice (Single Answer)

Which of the following is the smallest unit of allocation in an Oracle database?

  1. Segment
  2. Extent
  3. Database block
  4. None of these
Question 21 Multiple Choice (Single Answer)

Which of the following SQL functions returns the last day of the month from the current date or date specified by the user?

  1. ADD_MONTHS()
  2. LAST_DAY()
  3. NEXT_DAY()
  4. MONTHS_BETWEEN()
Question 22 Multiple Choice (Single Answer)

In which of the following schemas of reference architecture for distributed database, each global relation is split into several non-overlapping portions that are called as fragments?

  1. Global schema
  2. Allocation schema
  3. Local mapping schema
  4. Fragmentation schema
Question 23 Multiple Choice (Single Answer)

Which of the following symbols is used to indicate selection operation in relation algebra?

  1. p
  2. s
  3. q
  4. �
Question 24 Multiple Choice (Single Answer)

Which of the following codes are executed / fired when certain actions or events occur?

  1. Cursors
  2. Database triggers
  3. Procedure
  4. None of these
Question 25 Multiple Choice (Single Answer)

Which of the following selects all the rows from one table whether they have corresponding matching rows in another table or not?

  1. Inner join
  2. Equi-join
  3. Non-equi join
  4. Outer join
Question 26 Multiple Choice (Single Answer)

Which of the following blocks in PL/SQL contains executable statements that are executed when the program is run?

  1. Declare
  2. Exception
  3. Begin
  4. None of these
← Back to Quizzes