Shortcut

Ctrl + F is the shortcut in your browser or operating system that allows you to find words or questions quickly.

Ctrl + Tab to move to the next tab to the right and Ctrl + Shift + Tab to move to the next tab to the left.

On a phone or tablet, tap the menu icon in the upper-right corner of the window; Select "Find in Page" to search a question.

Share Us

Sharing is Caring

It's the biggest motivation to help us to make the site better by sharing this to your friends or classmates.

Database Management System

A software package designed to define, manipulate, retrieve and manage data in a database data format, field names, record structure and file structure.

information technology

hierarchical

network

object-oriented

sequel

programming

database

sql

mysql

php

relational databases

cloud databases

hosting

nosql databases

excel

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

  • UNION ALL

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

  • True
  • False

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

  • FIND IN SET

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

  • POWER

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

  • UNION ALL

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

  • CREATE TABLE

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

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

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

  • CEILING

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

  • Union All
  • Union
  • Minus
  • Intersect

It returns a date from a numeric datevalue.

  • FROM DAYS

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

  • Application Program

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

  • DATE_SUB

It is an association among several entities.

  • RELATIONSHIP

A command that updates a view.

  • UPDATE VIEW

It returns the arc tangent of one or two numbers.

  • ATAN

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

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

  • Comparison
  • Like
  • Between
  • IN

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

  • Instr
  • Field
  • Concat
  • Format

An operator used to search for a pattern.

  • LIKE

It returns the position of a pattern in a string.

  • PATINDEX

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

  • DATUM

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

  • UNION

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

  • Between
  • Comparison
  • Like
  • IN

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

  • CEIL

It returns the current date and time.

  • CURRENT TIMESTAMP

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

  • NULLIF

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

  • True
  • False

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

  • DATEDIFF

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

  • Subtraction
  • Comparison
  • Logical Condition
  • Add

The command to delete a view.

  • DROP VIEW

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

  • True
  • False

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

  • DROP TABLE

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

  • SUBTIME

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

  • WHERE

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

  • ALTER TABLE

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.

  • INSERT INTO STUDENTS VALUES (10,'CRUZ',NULL,NULL);
  • INSERT INTO STUDENTS VALUES (10,'CRUZ','NULL','NULL');
  • INSERT INTO STUDENTS TABLE VALUES (10,'CRUZ','NULL','NULL');
  • INSERT INTO STUDENTS (10,'CRUZ',NULL,NULL);

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

  • CREATE TABLE

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

  • True
  • False

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

  • Intersect
  • Minus
  • Union All
  • Union

It converts a string to the upper-case.

  • toUpperCase

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

  • True
  • False

It returns the current database system UTC date and time.

  • GETUTCDATE

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

  • MAX

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

  • True
  • False

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

  • 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;

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 returns 1 or 0 depending on whether an expression is NULL.

  • ISNULL

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

  • Index
  • View
  • Synonym
  • Table

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

  • TRUNCATE TABLE CATEGORIES;

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

  • EXP

The command specifies the values of an INSERT INTO statement.

  • VALUES

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

  • TRUNCATE TABLE

It converts a value to a binary string.

  • BINARY

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

  • Space

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

  • ADD
  • DROP
  • MODIFY
  • DELETE

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

  • CURRENT USER

It compares two strings.

  • STRCMP
  • MID
  • RPAD
  • SUBSTR

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

  • True
  • False

A command which deletes a table in the database.

  • DROP TABLE

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

  • DATE SUB
  • DATE FORMAT
  • DATE ADD
  • DAYNAME

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

  • TRUNCATE TABLE

A function that adds two or more expressions together.

  • CONCAT

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

  • TO DAYS

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

  • COS
  • ATAN
  • CEIL
  • COUNT

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);

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

  • UPDATE

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

  • Where
  • Delete
  • Insert
  • Select

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

  • DATEPART

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

  • Insert
  • Union
  • Intersect
  • Position

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

  • True
  • False

It returns the character based on the ASCII code.

  • Char

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

  • True

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

  • LOG2

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

  • Database Management System

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

  • ISDATE

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

  • >
  • like
  • =
  • in

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

  • TRUNCATE TABLE

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

  • True
  • False

It returns the session settings for a specified option.

  • SESSIONPROPERTY

This command specifies the values of an INSERT INTO statement.

  • VALUES

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

  • False

It removes leading and trailing spaces from a string.

  • Ucase
  • Upper
  • Rtrim
  • Trim

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

  • WHERE

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

  • MOD

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

  • CONV

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