Computer Knowledge

Database Management Systems

5,543 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice technology databases

Which of the following command is used to disconnect from the database and end the db2bp process from DB2 CLP?

  1. QUIT

  2. END

  3. TERMINATE

  4. LOGOFF
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The TERMINATE command in DB2 CLP disconnects from the database AND ends the db2bp (DB2 back-end process) process, completely closing the DB2 session. Other commands like QUIT, CONNECT RESET, or LOGOFF may disconnect from a specific database but leave the db2bp process running for subsequent connections. TERMINATE is the clean shutdown command that fully exits the DB2 command environment.

Multiple choice technology databases

Which of the following tool can be used to monitor the state of the DB2 environment?

  1. Task Center

  2. Command Center

  3. Health Center

  4. Control Center
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Health Center is specifically designed to monitor the health and state of the DB2 environment, tracking metrics like memory usage, buffer pool activity, and system performance indicators. Control Center provides administrative functions but not continuous health monitoring. Task Center schedules tasks and Command Center executes SQL queries - neither provides environment state monitoring capabilities like Health Center.

Multiple choice technology databases

DB2 Extenders can handle non-traditional data. Which of the following type of data can Extenders not handle?

  1. XML

  2. File

  3. Spatial data

  4. Music
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DB2 Extenders specialize in handling structured non-traditional data types like XML documents, spatial/geographic information, and multimedia content. The term 'File' is a generic storage concept rather than a specific data type that extenders process. Extenders are designed for particular data formats, not generic file operations.

Multiple choice technology databases

What is the teradata utility that can continuously load data into tables?

  1. Fastexp

  2. Fastload

  3. Multiload

  4. Tpump
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

TPump (Teradata Parallel Utility Pump) is the utility designed for continuous, near-real-time data loading into Teradata tables. Unlike FastLoad or MultiLoad which work in batch mode and require empty tables, TPump can continuously load data into populated tables without disrupting existing operations.

Multiple choice technology databases

Which of the following tables could be used for a user who wants to create a small Temporary table with Spool Space?

  1. Derived Table

  2. Volatile Table

  3. Global Temporary Table

  4. None
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Derived tables exist only for the duration of a single query and use spool space. Volatile tables persist throughout the user session but also use spool space rather than permanent disk space. Global Temporary Tables, by contrast, use permanent disk space and are materialized.

Multiple choice technology databases

Teradata runs on which architecture ?

  1. shared memory

  2. shared nothing

  3. shared everything

  4. shared all
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Teradata uses a shared-nothing architecture where each AMP (Access Module Processor) has its own dedicated disk storage and operates independently. This eliminates resource contention and allows the system to scale linearly by adding more nodes, unlike shared-memory or shared-everything architectures.

Multiple choice technology databases

What is the teradata utility that restricts queries based on threshold values ?

  1. Teradata Manager

  2. DBQM

  3. Queryman

  4. Teradata Warehouse builder
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Teradata Manager is the administrative utility that can restrict queries based on threshold values to manage system resources. It allows administrators to set limits on query runtime, spool usage, and other resource consumption metrics to prevent runaway queries from degrading performance.

Multiple choice technology databases

What does the ‘Help Table’ display?

  1. Column names, data type, Comments

  2. Column names, Indexes, data types, Comments

  3. Displays the table id, Column names, data types, Comments

  4. Tell the session number of the user
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The HELP TABLE command in Teradata displays basic structural information about a table including column names, data types, and any comments defined on columns. It provides a quick reference for table structure without showing indexes or detailed storage information.

Multiple choice technology databases

What code modificaiton should be made to run the below code ? begin dbms_scheduler.create_job ( job_name => 'RUN_SHELL1', schedule_name => 'DEMO_SCHEDULE', job_type => 'EXECUTABLES', job_action => '/home/test/run_script.sh', enabled => true, comments => 'Run shell-script' ); end; /

  1. No change is required,job can be scheduled.

  2. Enabled option should be set to False.

  3. Job type should be changed to Executable

  4. Job type should be changed to Executable Block

  5. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The job_type parameter must be 'EXECUTABLE' (without the S) for shell scripts, not 'EXECUTABLES'. This typo in the job_type value will cause an error when creating the job.

Multiple choice technology databases

what is the view that provides the job history ?

  1. all_scheduler_job_log_

  2. dba_scheduler_job_logs

  3. users_scheduler_job_log

  4. all the above

  5. None
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Oracle's Scheduler job run details and execution history are stored in views like DBA_SCHEDULER_JOB_RUN_DETAILS or ALL_SCHEDULER_JOB_LOG. The options provided are misspelled or non-existent, making 'None' the correct choice.

Multiple choice technology databases

Which package in plsql provides scheduling ?

  1. DBMS_SCHEDULER package

  2. DBMS_SCHEDULE package

  3. DBMS_JOB package

  4. Both A & C

  5. None
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Both DBMS_SCHEDULER (the modern scheduler from Oracle 10g) and DBMS_JOB (the older scheduling package still supported for backward compatibility) provide job scheduling functionality in PL/SQL. DBMS_SCHEDULE is not a valid package.

Multiple choice technology databases

what should be program type of a program that is of 'STORED PROCEDURE' ?

  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The STORED_PROCEDURE program type is specifically used for programs that execute stored procedures. PLSQL_BLOCK is for anonymous PL/SQL blocks, and EXECUTABLE is for external operating system commands or scripts. STORED_PROCEDURE_EXECUTABLE and STORED_EXECUTABLE are not valid program types.

Multiple choice technology databases

What code modificaiton should be made to run the below code ? begin dbms_scheduler.create_job ( job_name => 'RUN_SHELL1', schedule_name => 'DEMO_SCHEDULE', job_type => 'EXECUTABLES', job_action => '/home/test/run_script.sh', enabled => true, comments => 'Run shell-script' ); end; /

  1. No change is required,job can be scheduled.

  2. Enabled option should be set to False.

  3. Job type should be changed to Executable

  4. Job type should be changed to Executable Block

  5. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle DBMS_SCHEDULER, the parameter job_type must be 'EXECUTABLE' (singular) to run shell scripts. Using 'EXECUTABLES' (plural) is a syntax error, making changing the job type to 'Executable' the necessary modification.