Class 12
Information Technology (802)
351 questions available
Refine
All questions
351 resultsGiven int a=50, b=7; what is the value of a%b?
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
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
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
Which command changes the default value of an existing column, e.g. setting Salary's default to 30000?
Show answer
Given int a=19, b=6; what is the value of a%b?
Show answer
MySQL server 5.6.20 fully supports the RESTRICT and CASCADE options for the DROP TABLE command.
Show answer
Given int a=15, b=4; what is the value of a/b using integer division?
Show answer
The referenced table (containing the primary key) must be created before the referencing table containing the foreign key.
Show answer
Given int a=22, b=7; what is the value of a/b using integer division?
Show answer
A primary key can be dropped using ALTER TABLE even if it is the only primary key of the table, without any error.
Show answer
Given int a=9, b=5; what is the value of a/b using integer division?
Show answer
Write the SQL command to create a database named 'School'.
Show answer
Given int a=31, b=6; what is the value of a/b using integer division?
Show answer
Write the SQL command to view the structure/description of the table 'Teacher'.
Show answer
Given int a=18, b=4; what is the value of a/b using integer division?
Show answer
Write the CREATE TABLE command for a Department table with Dept_ID (INTEGER, Primary Key) and Dept_Name (VARCHAR(30), NOT NULL).