logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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

Which clause is used to limit the number of rows returned?

  • COUNT
  • HAVING
  • LIMIT
  • SUM
Mark for review

Which SQL function returns number of records?

  • SUM()
  • AVG()
  • COUNT()
  • MIN()
Mark for review

What is a composite key?

  • One key from different columns
  • A unique key made from two or more columns
  • Duplicate key
  • Random string
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

What is meant by data redundancy?

  • Repeated data in UI
  • Repeated data entries in DB
  • Data cleanup
  • Normalized data
Mark for review

What is a cursor in database?

  • Table name
  • A pointer to the result of a query
  • Function
  • Constraint
Mark for review

What is data integrity?

  • UI design accuracy
  • Network strength
  • Accuracy and consistency of data
  • Number of test cases
Mark for review

Which of the following is used to restrict data entry?

  • Index
  • View
  • Constraint
  • Query
Mark for review

What does DML stand for?

  • Data Memory Load
  • Database Management Language
  • Data Manipulation Language
  • Data Module Layer
Mark for review

What is used to validate data accuracy?

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

What is the result of INNER JOIN with no matching record?

  • All rows returned
  • Null values only
  • No row returned for that condition
  • Duplicate rows
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 transaction?

  • Sequence of operations treated as a single unit
  • One query
  • One stored procedure
  • Test suite
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 does ACID stand for in database?

  • Access, Control, Isolation, Data
  • Atomicity, Consistency, Isolation, Durability
  • Audit, Check, Integrity, Durability
  • None of these
Mark for review

What is a stored procedure?

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

What is the impact of missing indexes?

  • Faster queries
  • More memory usage
  • Slower query performance
  • Duplicate records
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 data masking used for?

  • UI optimization
  • Performance testing
  • Hiding sensitive data
  • Creating backups
Mark for review

What is referential integrity?

  • Key uniqueness
  • Foreign keys are enforced correctly
  • Fast performance
  • Schema optimization
Mark for review

What is the function of constraints?

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

Which clause in SQL helps to filter records?

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

What is a view in database?

  • Stored data
  • Virtual table based on a query
  • Schema info
  • SQL user
Mark for review

What is database indexing used for?

  • Store large files
  • Optimize query performance
  • Hide data
  • Backup tables
Mark for review

What is deadlock in database?

  • Slow query
  • Two transactions waiting on each other
  • Backup failure
  • Data loss
Mark for review

What does SQL injection test for?

  • Network bandwidth
  • Security flaws in input fields
  • Query speed
  • Image loading
Mark for review

Which SQL function gives the largest value in a column?

  • SUM
  • MIN
  • MAX
  • COUNT
Mark for review

What does DDL stand for?

  • Data Description Layer
  • Data Definition Language
  • Data Design Logic
  • Direct Data Link
Mark for review

What is the result of improper indexing?

  • Faster queries
  • UI bugs
  • Slower performance
  • Broken keys
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