HIMT 01 – DBMS – Bayelsa State College of Health Technology

BAYELSA STATE COLLEGE OF HEALTH TECHNOLOGY, OTUODIGI, OGBIA-TOWN

PRACTICE PAPER FOR HEALTH INFORMATION MANAGEMENT TECHNOLOGY

DBMS

OBJECTIVE QUESTIONS ONLY

(100 MARKS)

Student's Name

Matric No.

Course Title

Which SQL statement is used to create a new user in a database?

A) CREATE USER

B) CREATE TABLE

C) CREATE DATABASE

D) CREATE INDEX

None

What is the purpose of the SQL ALTER TABLE command?

A) To modify the structure of an existing table

B) To create a new table

C) To remove a table from the database

D) To add data to a table

None

Which SQL statement is used to create a new table in a database?

A) CREATE TABLE

B) ALTER TABLE

C) DROP TABLE

D) SELECT INTO

None

What is a static report in a database?

A) A report that changes dynamically with the data

B) A report that remains unchanged after generation

C) A report that is used to update data

D) A report used for creating tables

None

Which of the following SQL statements is used to create an index on a table?

A) CREATE INDEX

B) CREATE TABLE

C) ALTER TABLE

D) UPDATE

None

What is a summary report in database terminology?

A) A detailed listing of all records

B) A report that aggregates data for high-level analysis

C) A report used to define database schemas

D) A report that deletes data

None

Which of the following SQL clauses is used to limit the number of rows returned in a query?

A) LIMIT

B) ORDER BY

C) GROUP BY

D) HAVING

None

What is a dynamic report?

A) A report that changes automatically as the data changes

B) A report that is printed

C) A report that is never updated

D) A report used for data entry

None

In a database, what is a file used to store?

Individual data points

Records and fields

Tables and queries

Indexes and keys

None

10.

What is a form in the context of databases?

A) A tool for designing database tables

B) An interface for entering or viewing data

C) A type of database report

D) A function used to run queries

None

11.

Which SQL function is used to return the maximum value in a set? o

A) MAX()

B) MIN()

C) AVG()

D) COUNT()

None

12.

Which SQL clause is used to combine the results of two queries?

A) UNION

B) SELECT

C) WHERE

D) JOIN

None

13.

Which SQL command is used to add new data to a table?

A) INSERT INTO

B) DELETE

C) SELECT

D) UPDATE

None

14.

Which of the following best describes a unique key in a database table?

A) It ensures that all values in a column are different.

B) It allows null values.

C) It must be a primary key.

D) It is used to create a relationship between tables.

None

15.

Which clause is used to filter records in SQL?

a) WHERE

b) HAVING

c) FROM

d) JOIN

None

16.

Which of the following represents a single character in a text file?

Byte

Bit

Field

File

None

17.

What is a database?

A single data record

A collection of related data organized in tables

A single field in a record

A data type

None

18.

Which SQL function is used to return the smallest value in a set?

A) MIN()

B) SUM()

C) MAX()

D) AVG()

None

19.

In ASCII encoding, how many bits are used to represent a character?

None

20.

Which of the following best describes an aggregate function in SQL?

A) A function that performs a calculation on multiple values and returns a single value

B) A function that modifies records in a table

C) A function that joins two tables

D) A function that defines the database schema

None

21.

Which SQL command is used to update existing records in a table?

a) UPDATE

b) ALTER

c) MODIFY

d) CHANGE

None

22.

Which term describes a row in a database table?

A) Field

B) Record

C) Attribute

D) Query

None

23.

What is the purpose of the SQL HAVING clause?

A) To filter records after grouping with GROUP BY

B) To group records by specific columns

C) To limit the number of rows returned by a query

D) To order the results by a specific column

None

24.

Which SQL function is used to return the average value in a set?

A) AVG()

B) SUM()

C) COUNT()

D) MIN()

None

25.

Which SQL function is used to count the number of rows in a table?

A) COUNT()

B) SUM()

C) AVG()

D) MAX()

None

26.

What is the function of the SQL JOIN clause?

A) To combine data from two or more tables based on a related column

B) To delete records from a table

C) To add new records to a table

D) To update records in a table

None

27.

Which of the following is true about relations in a relational database?

A) They can have multiple primary keys.

B) They are used to describe relationships between tables.

C) They are synonyms for fields.

D) They are used to store binary data.

None

28.

Which SQL function is used to return the current date and time?

A) NOW()

B) DATE()

C) TIME()

D) CURRENT()

None

29.

What does the SQL UNION operator do?

A) Combines the results of two or more SELECT statements

B) Merges data from multiple tables into one

C) Deletes duplicate rows in a table

D) Creates a backup of a table

None

30.

Which of the following is an aggregate function in SQL?

A) SUM()

B) SELECT

C) INSERT

D) UPDATE

None

31.

What is a parameterized query?

A) A query that requires input parameters for execution

B) A query that returns all data

C) A query that updates the database schema

D) A query that generates a report

None

32.

In a relational database, what does an attribute represent?

A) A table

B) A column

C) A row

D) A key

None

33.

What is the purpose of the SQL DROP TABLE command?

A) To remove a table and all of its data from the database

B) To delete specific rows from a table

C) To add new columns to an existing table

D) To create a backup of a table

None

34.

What is a database transaction?

A) A sequence of operations performed as a single logical unit of work

B) A tool for querying data

C) A report generation process

D) A backup operation

None

35.

Which of the following SQL clauses is used to sort the result set?

A) ORDER BY

B) GROUP BY

C) WHERE

D) HAVING

None

36.

What does the term 'normalization' refer to in database design?

A) The process of organizing data to reduce redundancy

B) The process of backing up a database

C) The process of creating user-friendly reports

D) The process of encrypting data in a database

None

37.

What is the primary function of a table in a database?

To define the database schema

To store related records in a structured format

To execute database operations

To display results

None

38.

Which of the following is true about a query?

A) It is used for data entry.

B) It is a request for information from the database.

C) It is used to modify the database schema.

D) It is used to generate reports.

None

39.

55. Which of the following SQL functions returns the sum of a numeric column? o

A) SUM()

B) AVG()

C) COUNT()

D) MIN()

None

40.

Which of the following is true about a byte?

It can represent 256 different values.

It is the smallest unit of data.

It represents a binary state.

It is used to encode numbers only.

None

41.

Which of the following SQL clauses is used to filter rows before grouping?

A) WHERE

B) HAVING

C) ORDER BY

D) GROUP BY

None

42.

Which of the following is the primary purpose of a query?

A) To retrieve data from one or more tables

B) To delete data from a table

C) To format data for reporting

D) To enter new data into a table

None

43.

Which command is used to remove records from a table?

a) DELETE

b) DROP

c) TRUNCATE

d) REMOVE

None

44.

What is an attribute in a database?

A) A single data value in a field

B) A property or characteristic of an entity

C) A group of related records

D) A type of database query

None

45.

Which of the following is a form designed for?

A) Querying data

B) Entering and editing data

C) Generating reports

D) Managing database transactions

None

46.

What is a form used for in a database?

A) To generate queries

B) To enter and display data

C) To store data in tables

D) To create database schemas

None

47.

How many bits are there in a byte?

None

48.

Which of the following is a DDL (Data Definition Language) command?

A) CREATE TABLE

B) INSERT INTO

C) SELECT

D) UPDATE

None

49.

Which of the following is used to delete all rows from a table without removing the table structure?

a) DELETE

b) DROP

c) TRUNCATE

d) REMOVE

None

50.

What is the purpose of a file in database management?

To organize data into fields

B) To store data in a structured manner

To execute queries

To display reports

None

51.

Which SQL command is used to modify the structure of an existing table?

A) ALTER TABLE

B) UPDATE

C) SELECT

D) INSERT

None

52.

Which SQL command is used to modify existing records in a table?

a) SELECT

b) INSERT

c) UPDATE

d) DELETE

None

53.

Which of the following is true about a form?

A) It is used to retrieve data from the database.

B) It is used for data entry and modification.

C) It is used to define relationships between tables.

D) It is used to enforce data integrity.

None

54.

Which SQL command is used to retrieve data from a database?

A) INSERT

B) DELETE

C) SELECT

D) UPDATE

None

55.

Which of the following is an example of an attribute in a customer database?

A) Customer ID

B) Customer table

C) Customer form

D) Customer query

None

56.

What is a query in database terminology?

A) A request for data from a database

B) A report generated from data

C) A form used to enter data

D) A method for storing data

None

57.

What does the GROUP BY clause do in SQL?

A) It groups rows with the same values in specified columns.

B) It orders the result set.

C) It limits the number of rows returned.

D) It modifies the data in a table.

None

58.

What is the smallest unit of data in a computer?

Byte

Bit

Character

Field

None

59.

Which of the following is true about a primary key?

A) It must be unique across the table.

B) It can have duplicate values.

C) It is used to join two tables.

D) It can be null.

None

60.

What is the primary purpose of a bit in computing?

To store a character

To represent a binary state (0 or 1)

To define a data type

To format data

None

61.

To add a new column to an existing table, which command is used?

a) ADD COLUMN

b) ALTER TABLE

c) MODIFY COLUMN

d) UPDATE TABLE

None

62.

Which of the following SQL commands is used to modify data in a database?

A) SELECT

B) UPDATE

C) CREATE

D) DROP

None

63.

Which of the following best defines a relation in a relational database?

A) A primary key

B) A table

C) A foreign key

D) A form

None

64.

Which SQL clause is used to combine results from two or more tables?

A) UNION

B) SELECT

C) WHERE

D) INSERT

None

65.

What is an index in a database?

A) A database structure that improves the speed of data retrieval

B) A tool used to enforce data integrity

C) A type of database query

D) A report generation tool

None

66.

Which of the following SQL clauses is used to specify the condition for an aggregate function?

A) HAVING

B) WHERE

C) ORDER BY

D) GROUP BY

None

67.

Which SQL clause is used to filter results of a query?

A) FROM

B) SELECT

C) WHERE

D) GROUP BY

None

68.

Which SQL clause is used to filter the results of a query?

A) WHERE

B) FROM

C) GROUP BY

D) ORDER BY

None

69.

Which SQL command is used to remove records from a table?

A) DELETE

B) SELECT

C) UPDATE

D) INSERT

None

70.

What is the purpose of a query?

A) To store data in a table

B) To retrieve specific data from a database

C) To generate visual reports

D) To define the database schema

None

71.

What is a subquery in SQL?

A) A query nested inside another query (Correct) o

B) A query that joins multiple tables

C) A query that updates data in a table

D) A query that creates a new database schema

None

72.

Which of the following is an example of a relational database?

A) MySQL

B) MongoDB

C) Redis

D) Apache Hadoop

None

73.

Which of the following is an attribute in a database?

A) A field name

B) A table name

C) A query name

D) A report name

None

74.

What is the purpose of a table’s primary key?

A) To store data securely

B) To uniquely identify each record in the table

C) To perform calculations on data

D) To index data for faster retrieval

None

75.

What is the purpose of a foreign key in a database table?

A) To link two tables together

B) To uniquely identify each record within the table

C) To perform queries on a database

D) To encrypt data

None

76.

The command to remove a column from an existing table is:

a) DROP COLUMN

b) DELETE COLUMN

c) REMOVE COLUMN

d) ALTER TABLE DROP COLUMN

None

77.

What is the purpose of the SQL ORDER BY clause?

A) To order the result set based on specified columns

B) To group the results by certain criteria

C) To limit the number of rows returned

D) To modify the data in a table

None

78.

What is the purpose of a report in a database?

A) To store data

B) To visually present data in a structured format

C) To enter data into a table

D) To perform complex queries

None

79.

Which of the following best describes an attribute?

A) It is a unique identifier for a record.

B) It is a specific data point within a record.

C) It is a collection of related fields.

D) It is used to define database relationships.

None

80.

In relational databases, what is a file commonly known as?

A table

A record

An attribute

A query

None

81.

What does a table represent in a database?

A collection of queries

A set of fields and records

A set of files

A form of data encryption

None

82.

None

83.

Which SQL command is used to remove all rows from a table without removing the table itself?

A) TRUNCATE

B) DELETE

C) DROP

D) UPDATE

None

84.

Which of the following data types is typically used to store a single character?

A) Bit

B) Byte

C) Integer

D) String

None

85.

What does a report typically do in a database system?

A) It retrieves data based on a query.

B) It provides a formatted output of data for analysis.

C) It defines the structure of tables.

D) It stores and manages database backups.

None

86.

What does the SQL keyword DISTINCT do?

A) It selects only unique values from a column.

B) It filters rows based on a condition.

C) It orders the result set.

D) It groups the results.

None

87.

What does the term 'ACID properties' refer to in databases?

A) The set of properties that ensure reliable processing of database transactions

B) A type of database index o

C) A tool for data analysis

D) A method for generating reports

None

88.

In a relational database, what is a relation?

A) A connection between different databases

B) A table with rows and columns

C) A specific type of query

D) A field within a record

None

89.

Which of the following is used to enforce a relationship between two tables in SQL?

A) Foreign key

B) Primary key

C) Unique key

D) Index

None

90.

What is the relationship between a byte and a character in Unicode encoding?

One byte represents one character

One byte represents two characters

One character can be represented by one or more bytes

One character is represented by four bytes

None

91.

In a database form, what is the main purpose?

A) To format data for reports

B) To provide a user-friendly interface for data entry

C) To execute SQL queries

D) To store backup copies of data

None

92.

Which of the following best describes a field?

It stores multiple records.

It contains a single data item.

It is a collection of related records.

It represents the database schema.

None

93.

What is a field in the context of databases?

A single piece of data within a record

A group of records

A collection of tables

A type of file

None

94.

Which of the following is true about SQL queries?

A) They can be used to update data in a table.

B) They can only retrieve data from a table.

C) They are used to create database schemas.

D) They are used to format reports.

None

95.

What does the SQL DISTINCT keyword do?

A) It selects only unique (non-duplicate) values.

B) It orders the result set.

C) It groups the results by specified columns.

D) It updates the data in a table.

None

96.

What is a characteristic of a well-designed report?

A) It stores raw data.

B) It provides summary and analysis of data.

C) It is used to execute database queries.

D) It defines relationships between tables.

None

97.

Which SQL clause is used to filter the results based on a condition?

a) WHERE

b) HAVING

c) GROUP BY

d) ORDER BY

None

98.

What does the SQL LIKE operator do?

A) It searches for a specified pattern in a column.

B) It deletes records from a table.

C) It adds new records to a table.

D) It orders the result set.

None

99.

Which SQL command is used to remove records from a table?

A) DELETE

B) SELECT

C) UPDATE

D) INSERT

None

100.

Which of the following is a characteristic of a detailed report?

A) It aggregates data.

B) It includes every data point in the dataset.

C) It summarizes data.

D) It filters out most data.

None

1 out of 2

Time's up

Time is Up!