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 one is not the oracle database component type...

  1. memory

  2. disk

  3. tape

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

Oracle database components consist of memory structures (SGA, PGA), disk structures (data files, control files, redo logs), and background processes. Tape storage is not a database component - it's used for backups/archives, not active database operations.

Multiple choice technology databases

You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first?

  1. Ensure that port 1433 is open in your firewall.

  2. Ensure that port 443 is open in your firewall.

  3. Ensure that client computers connect by using Shared Memory protocol.

  4. Ensure that the server is not paused.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Server's default TCP/IP port is 1433. If clients can't connect through a firewall but local connections work, the most likely cause is port 1433 being blocked. Opening this port in the firewall allows remote client connections.

Multiple choice technology databases

Companyxyz.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins. You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do?

  1. Ensure that both SQL1 and SQL2 use the same login name as the security context for each

  2. Configure SQL2 as a remote server. Write the query on SQL1.

  3. Configure SQL2 as a linked server to impersonate the remote login.

  4. Configure SQL2 as a distributed server. Use pass-through authentication.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

For distributed queries across SQL Servers with different authentication, configure the remote server as a 'linked server' with impersonation settings. This allows passing security context credentials. Remote servers are deprecated; linked servers are the correct approach.

Multiple choice technology databases

You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do?

  1. Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a

  2. Create a job for each task that runs once a day. Use a Transact-SQL statement to check the

  3. Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is

  4. Create a job for each task that runs once a week on Sunday. Add a second job schedule that
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Server Agent supports reusable job schedules. Create separate schedules for different frequencies (weekly Sundays, monthly start), then assign jobs to appropriate schedules. This is more efficient than creating individual schedules for each job.

Multiple choice technology databases

You discover that the msdb database on a SQL Server 2005 computer is corrupt and must be restored. Databases are backed up daily. The database backup files are written to a network share, but the file names do not clearly indicate which databases are in each file. You need to locate the correct backup file as quickly as possible. The first file in the list is named DB_Backup.bak. Which Transact-SQL statement should you use?

  1. RESTORE LABELONLYFROM DISK = N\Server1\Backup\DB_Backup.bak

  2. RESTORE HEADERONLYFROM DISK = N\Server1\Backup\DB_Backup.bak

  3. RESTORE VERIFYONLYFROM DISK = N\Server1\Backup\DB_Backup.bak

  4. RESTORE DATABASE MSDBFROM DISK = N\Server1\Backup\DB_Backup.bak
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

RESTORE HEADERONLY reads backup file metadata without restoring. It lists all database backups contained in a backup set, including database names - perfect for identifying which backup file contains msdb when filenames are unclear.

Multiple choice technology databases

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located. You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?

  1. Execute DBCC CHECKFILEGROUP for each filegroup.

  2. Execute DBCC CHECKCATALOG.

  3. Execute DBCC CHECKDB.

  4. Execute DBCC CHECKTABLE for each table.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DBCC CHECKDB is the most comprehensive integrity check command for SQL Server databases. It verifies allocation, structural, and logical integrity of all database objects including system catalogs in a single operation, making it the right choice after a SAN failure that could affect the entire database storage.

Multiple choice technology databases

Where do I need to configure to tell how oracle operates while it is running...?

  1. control files

  2. password files

  3. parameter files

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

Parameter files (SPFILE or PFILE) contain initialization parameters that control how Oracle operates while running. These include memory settings, file locations, and behavioral options. Control files, password files, and redo logs serve different purposes in database operation.

Multiple choice technology databases

find the SGA components

  1. buffer cache

  2. large pool

  3. java pool

  4. all the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The System Global Area (SGA) is a shared memory region that includes multiple components: buffer cache (data block caching), large pool (for large memory allocations), Java pool (for Java runtime), shared pool (SQL and PL/SQL), and streams pool. All of these are essential SGA components.

Multiple choice technology enterprise content management

What is COLD / ERM?

  1. A new type of flu

  2. Computer Output to Laser Disk/ Enterprise Report Management

  3. Creative Outline of Large Documents/ Essential Records Management

  4. Composite Overview of Legal Documents / Executive Records Management
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To answer this question, the user needs to know the meaning of the acronym COLD/ERM.

Option A is incorrect because COLD/ERM is not a type of flu.

Option B is correct. COLD stands for Computer Output to Laser Disk, and ERM stands for Enterprise Report Management. Combined, these two terms refer to a system that manages electronic documents, including reports, invoices, and other types of business records.

Option C is incorrect because "Creative Outline of Large Documents" is not a recognized term for COLD/ERM. Additionally, "Essential Records Management" doesn't accurately describe the meaning of ERM.

Option D is incorrect because "Composite Overview of Legal Documents" is not a recognized term for COLD/ERM. Additionally, "Executive Records Management" doesn't accurately describe the meaning of ERM.

Therefore, the correct answer is:

The Answer is: B. Computer Output to Laser Disk/ Enterprise Report Management.

Multiple choice technology

Star Schema consists of ---- table at the center surrounded by ---------

  1. Fact,Dimension

  2. Fact,Master Data

  3. Dimension,Master Data

  4. Fact,Keyfigures
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Star Schema consists of a Fact table at the center (containing measures/key figures) surrounded by Dimension tables (containing descriptive attributes). This is the fundamental data warehouse pattern that optimizes query performance by denormalizing dimension data.

Multiple choice technology

It is better to load first, which of the following data?

  1. Transaction Data

  2. It Doesnot Matter

  3. Text

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

Attributes and master data should be loaded before transaction data in SAP BW. Attributes provide descriptive information and relationships that transaction data may reference. Loading attributes first ensures that when transaction data arrives, all related master data and attributes are available for proper data enrichment and reporting.

Multiple choice technology web technology

What is iBatis ?

  1. A SQL Mapper

  2. A J2ee Framework

  3. A JDBC Framework

  4. An ORM Tool
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

iBATIS (now MyBatis) is primarily a SQL Mapper that maps Java objects to SQL statements using XML or annotations. It's a JDBC framework (simplifies JDBC code) and is classified as an ORM-like tool, though it's a data mapper rather than a full ORM like Hibernate. It's not a complete J2EE framework (that would include Spring or Java EE).

Multiple choice technology databases

Which authority or privilege is granted by the DB2 Database Manager configuration file?

  1. CONNECT

  2. CONTROL

  3. SYSMAINT

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

SYSMAINT is a database-level authority granted by the DB2 Database Manager configuration file (db2.cfg). It allows maintenance operations without full database administrative rights. CONNECT, CONTROL, and EXECUTE are database-level privileges/authorities, not configuration file authorities.

Multiple choice technology databases

Which of the following isolation levels will lock all rows scanned to build a result data set?

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

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

Repeatable Read locks all rows scanned to build the result set, preventing other transactions from updating or deleting them. Uncommitted Read takes no locks, Cursor Stability locks only the current row, and Read Stability locks only rows that are actually returned (not all scanned rows).

Multiple choice technology databases

Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?

  1. The cursor is moved to another row

  2. The row the cursor is on is deleted by the application

  3. The row the cursor is on is deleted by another application

  4. The row the cursor is on needs to be updated by another application

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Cursor Stability isolation level, locks are released when the cursor moves to another row. This is the defining behavior of CS - it only locks the row currently positioned on. Deleting the row or update attempts do not release the lock until the cursor moves.