Database Management System

The command that adds, deletes or modifies columns in a table.

• ALTER TABLE

The command specifies the values of an INSERT INTO statement.

• VALUES

It returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table.

• LAST INSERT ID
• NULLIF
• SESSION USER
• IFNULL

A command that combines the result set of two or more SELECT statements (allows duplicate values).

• UNION ALL

A function that returns a string of the specified number of space characters.

• Space

The WHERE clause is not only used in SELECT statement, it is also used in UPDATE, DELETE statement, etc.

• True
• False

It is a unit of data – is a symbol or a set of symbols which is used to represent something.

• DATUM

It returns the number of days between a date and date "0000-00-00".

• TO DAYS

It is a collection of interrelated data and a set of programs to access those data.

• Database Management System

The rows in the first query that are not present in the second query.

• Intersect
• Minus
• Union All
• Union

A command that deletes the data inside a table, but not the table itself.

• TRUNCATE TABLE

Which of the following is the correct example of modifying the column JOB_ID? Change the datatype size to 10.

• ALTER TABLE EMPLOYEES
• MODIFY JOB_ID CHAR(10);
• MODIFY JOB_ID CHAR(10);Which of the following is the correct example of inserting new values to STUDENTS table?
• ALTER TABLE EMPLOYEES MODIFY JOB_ID CHAR(10);

It logically represents subsets of data from one or more table.

• Index
• View
• Synonym
• Table

A function that returns the maximum value in a set of values.

• MAX

A function that adds two or more expressions together.

• CONCAT

The function repeat returns the position of the first occurrence of a substring in a string.

• True
• False

Which of the following is the correct example of updating the LASTNAME to ‘REYES’ of all students from STUDENTS table whose STUD_ID is equal to 01020564?

• UPDATE STUDENTS
• SET STUD_ID = 01020564;
• WHERELASTNAME = ‘REYES’;
• UPDATE STUDENTS SET LASTNAME = ‘REYES’ WHERE STUD_ID = 01020564;

It returns the position of the first occurrence of a string in another string.

• Instr
• Field
• Concat
• Format

It is the term generally used to describe what was done by large mainframe computers from the late 1940's until the early 1980's.

• Data Processing

A function that returns e raised to the power of a specified number.

• EXP

It returns the remainder of a number divided by another number.

• MOD

This operator is used to return all rows from multiple queries or multiple tables.

• Union All
• Union
• Minus
• Intersect

It returns the session settings for a specified option.

• SESSIONPROPERTY

It returns the current database system UTC date and time.

• GETUTCDATE

This command specifies the values of an INSERT INTO statement.

• VALUES

It returns the current date and time.

• CURRENT TIMESTAMP

It returns the value of a number raised to the power of another number.

• POWER

It returns the arc tangent of one or two numbers.

• ATAN

It returns the user name and hostname for the MySQL account that the server used to authenticate the current client.

• CURRENT USER

A command that combines the result set of two or more SELECT statements or allows duplicate values.

• UNION ALL

The UPDATE constraint ensures that all values in a column are unique.

• True
• False

A numeric function that returns the number of records returned by a select query.

• COS
• ATAN
• CEIL
• COUNT

It returns a date from a numeric datevalue.

• FROM DAYS

An operator used to return all rows that are common to multiple queries.

• Insert
• Union
• Intersect
• Position

A command which filters a result set to include only records that fulfill a specified condition.

• WHERE

A command which deletes a table in the database.

• DROP TABLE

A copy of an existing table can also be created using CREATE TABLE.

• True
• False

Are said to exhibit physical data independence if they do not depend on the physical schema.

• Application Program

The IFNULL returns a value if a condition is TRUE, or another value if a condition is FALSE.

• True
• False

Reversing the order of the intersected tables does not alter the result.

• True
• False

It removes leading and trailing spaces from a string.

• Ucase
• Upper
• Rtrim
• Trim

It adds a time/date interval to a date and then returns the date.

• DATE SUB
• DATE FORMAT
• DATE ADD
• DAYNAME

Write the SQL statement that selects all the customers from "Mexico" in the "Customers" table.

It is an association among several entities.

• RELATIONSHIP

This is used to test for values in a specified set of values.

• Comparison
• Like
• Between
• IN

This is used to perform wildcard searches of valid search string values.

• Between
• Comparison
• Like
• IN

The command to delete a view.

• DROP VIEW

An alter statement that is used to delete an existing column in the table.

• ADD
• DROP
• MODIFY
• DELETE

Write the SQL statement that will update the contactname to "Juan" for all records where country is "Mexico".

It checks an expression and returns 1 if it is a valid date, otherwise 0.

• ISDATE

The command used to create a new table in the database.

• CREATE TABLE

Write the SQL statement that deletes the table "Shippers".

It returns the position of a string within a list of strings.

• FIND IN SET

A command that updates a view.

An operator used to search for a pattern.

• LIKE

True/False. This symbol % denotes zero or many characters.

• True

This is used to in conditions that compare one expression with another value or expression.

• Subtraction
• Comparison
• Logical Condition
• Add

A numeric function that returns the smallest integer value that is >= to a number.

• CEILING

It returns 1 or 0 depending on whether an expression is NULL.

• ISNULL

This is used to restrict the rows that are returned by a query.

• Where
• Delete
• Insert
• Select

It returns the natural logarithm of a number to base 2.

• LOG2

It returns a specified part of a date (as integer).

• DATEPART

The command which deletes the data inside a table, but not the table itself.

• TRUNCATE TABLE

The command that deletes the data inside a table, but not the table itself.

• TRUNCATE TABLE

The command which combines the result set of two or more SELECT statements or only a distinct values.

• UNION

The NULL values or blank data in the report are not ignored during duplicate checking.

• True
• False

It subtracts a time/date interval from a date and then returns the date.

A syntax used to create a UNIQUE constraint on the "ID" column when the table is already created.

• CREATE TABLE

It compares two strings.

• STRCMP
• MID
• RPAD
• SUBSTR

True/False Character values are format sensitive and date values are case sensitive-sensitive.

• False

Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is 'CRUZ' and the rest of the column is set to NULL.

The pow function returns the value of a number raised to the power of another number.

• True
• False

It returns the smallest integer value that is >= to a number.

• CEIL

It returns the character based on the ASCII code.

• Char

An operator used to specify multiple possible values for a column.

• >
• like
• =
• in

This is use to create expression with number and date values.

• MDAS operator
• Numerical Values
• Arithmetic expression
• Logical Condition

Which of the following is not true about writing SQL statements?

• Clauses are usually placed on separate lines for readability and ease of editing.
• SQL statements are not case sensitive.
• Keywords cannot be split across lines or abbreviated.
• Indents should be used to make code more readable.

It converts a number from one numeric base system to another.

• CONV

The DROP table command also adds and deletes various constraints in a table.

• True
• False

A function that returns the number of days between two date values.

• DATEDIFF

It returns the position of a pattern in a string.

• PATINDEX

It converts a value to a binary string.

• BINARY

Write a SQL statement that truncates the table "Categories".

• TRUNCATE TABLE CATEGORIES;

It converts a string to the upper-case.

It subtracts a time interval from a datetime and then returns the time/datetime.

• SUBTIME

The DATE ADD returns the number of days between two date values.

• True
• False

It compares two expressions and returns null if they are equal. Otherwise, the first expression is returned.

• NULLIF