A question bank for every class and subject
Practice questions, with answers and explanations included
794 questions available
Refine
All questions
794 resultsIn a database, table Cabinet has a column where the data entry operator is unable to enter NULL values, and also unable to enter duplicate values. What is the likely reason?
Show answer
Which referential action automatically sets the foreign key value to NULL when the referenced primary key row is deleted?
Show answer
Given int a=31, b=6; what is the value of a%b?
Show answer
Convert: 2 KB = ______ Bytes.
Show answer
Which referential action automatically deletes the corresponding rows in the referencing table when the referenced row is deleted?
Show answer
Given int a=18, b=4; what is the value of a%b?
Show answer
Convert: 3 KB = ______ Bytes.
Show answer
Which referential action rejects the delete/update operation on the referenced table if there are related rows in the referencing table?
Show answer
Given int a=50, b=7; what is the value of a%b?
Show answer
Convert: 4 KB = ______ Bytes.
Show answer
How can constraints be named in a CREATE TABLE command?
Show answer
Given int a=13, b=3; what is the value of a%b?
Show answer
Convert: 5 KB = ______ Bytes.
Show answer
Which command is used to remove a table's structure and data from a database?
Show answer
Given int a=27, b=5; what is the value of a%b?
Show answer
Convert: 6 KB = ______ Bytes.
Show answer
Which command is used to add a new column to an existing table?
Show answer
Given int a=44, b=9; what is the value of a%b?
Show answer
Convert: 7 KB = ______ Bytes.
Show answer
Which command changes the default value of an existing column, e.g. setting Salary's default to 30000?