logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

What are triggers in a database?

  • UI functions
  • Programs that automate data entry
  • Stored procedures
  • Events that automatically execute on changes
Mark for review

What is the role of a data dictionary?

  • Stores table rows
  • Stores database schema metadata
  • Encrypts columns
  • Defines user roles
Mark for review

What is used to validate data accuracy?

  • UI test case
  • SELECT queries
  • Regression script
  • Page source check
Mark for review

What happens if referential integrity is broken?

  • Page crashes
  • System slows down
  • Orphan records occur
  • No effect
Mark for review

What does the DISTINCT keyword do?

  • Returns only unique values
  • Counts rows
  • Sorts data
  • Encrypts data
Mark for review

Which SQL statement is used to retrieve data?

  • UPDATE
  • INSERT
  • SELECT
  • DELETE
Mark for review

Which clause in SQL helps to filter records?

  • GROUP BY
  • HAVING
  • WHERE
  • ORDER BY
Mark for review

What is latency in database performance?

  • Query length
  • Delay in data access
  • Total rows
  • Index position
Mark for review

What is a common challenge in database testing?

  • UI alignment
  • Inconsistent test data
  • Color mismatch
  • Element IDs
Mark for review

What is a clustered index?

  • Index on views
  • Index that defines data storage order
  • Unused index
  • Foreign key
Mark for review

What is the purpose of rollback testing?

  • Validate delete statements
  • Ensure transactions revert correctly
  • Check logs
  • Test speed
Mark for review

What is a synonym in database terms?

  • Alias for table or view
  • Copy of schema
  • Index
  • Stored query
Mark for review

What is a materialized view?

  • A report
  • A stored procedure
  • A view stored as a physical table
  • A test case
Mark for review

What is the main reason to use transactions in database?

  • Improve UI
  • Handle schema changes
  • Ensure data integrity and atomicity
  • Backup data
Mark for review

What is a primary key?

  • A duplicate key
  • A unique identifier for records
  • A null field
  • A database name
Mark for review

Which command changes table structure?

  • CREATE
  • INSERT
  • ALTER
  • SELECT
Mark for review

What does the HAVING clause do?

  • Filters groups created by GROUP BY
  • Sorts results
  • Limits rows
  • Deletes duplicates
Mark for review

What is an execution plan in SQL?

  • A stored query
  • Query analysis showing how SQL is executed
  • Test report
  • Rollback code
Mark for review

What is schema testing?

  • Frontend flow testing
  • Validating table structure, columns, and relationships
  • Server load test
  • Compatibility testing
Mark for review

What is used to check performance of queries?

  • Query analyzer
  • Index viewer
  • Procedure compiler
  • Memory debugger
Mark for review

What is the purpose of the BETWEEN clause?

  • Match exact values
  • Check range of values
  • Search text
  • Group values
Mark for review

What is a flat file database?

  • File with compressed schema
  • UI test file
  • Plain text file storing data
  • SQL format data
Mark for review

Which type of testing verifies that NULL values are handled correctly?

  • Null constraint testing
  • Usability testing
  • Regression testing
  • Smoke testing
Mark for review

Which constraint ensures that a column cannot have NULL values?

  • FOREIGN KEY
  • NOT NULL
  • CHECK
  • UNIQUE
Mark for review

What is the purpose of a UNIQUE constraint?

  • Allows duplicate entries
  • Ensures only nulls
  • Enforces non-duplicate values
  • Blocks updates
Mark for review

What is a surrogate key?

  • Natural identifier
  • Manually entered field
  • System-generated primary key
  • Schema version
Mark for review

What is the function of constraints?

  • Restrict data values in columns
  • Connect tables
  • Automate updates
  • Create reports
Mark for review

When should database testing be done?

  • After deployment only
  • Only during coding
  • Throughout development cycle
  • Not required
Mark for review

What is a stored procedure?

  • Static report
  • Predefined SQL logic stored in DB
  • Data type
  • View
Mark for review

What is a surrogate key used for?

  • Replacing composite keys with a unique auto-generated key
  • Backup creation
  • Data migration
  • Foreign reference
Mark for review

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session