Follow and like us on our Facebook page where we post on the new release subject and answering tips and tricks to help save your time so that you can never feel stuck again.
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 which deletes a table in the database.

  • DROP TABLE

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

  • DROP TABLE

It returns the position of a pattern in a string.

  • PATINDEX

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

  • Between
  • Comparison
  • Like
  • IN

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

  • Intersect
  • Minus
  • Union All
  • Union

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

  • Application Program

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

  • True
  • False

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

  • DATEDIFF

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

  • CONV

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

  • UNION ALL

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

  • True
  • False

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

  • True
  • False

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

  • TRUNCATE TABLE

It returns the session settings for a specified option.

  • SESSIONPROPERTY

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

  • TRUNCATE TABLE

The command specifies the values of an INSERT INTO statement.

  • VALUES

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

  • CEIL

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

  • FIND IN SET

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

  • WHERE

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

  • True
  • False

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

  • EXP

A function that adds two or more expressions together.

  • CONCAT

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

  • ISDATE

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

  • DATE_SUB

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

  • DATUM

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

  • Space

It returns the character based on the ASCII code.

  • Char

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

  • True
  • 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.

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

The command to delete a view.

  • DROP VIEW

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

  • True

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

  • True
  • False

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

  • DATEPART

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

  • ALTER TABLE

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

  • CREATE TABLE

A command that updates a view.

  • UPDATE VIEW

It converts a value to a binary string.

  • BINARY

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

  • CREATE TABLE

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

  • >
  • like
  • =
  • in

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

  • NULLIF

It compares two strings.

  • STRCMP
  • MID
  • RPAD
  • SUBSTR

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

  • True
  • False

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

  • ADD
  • DROP
  • MODIFY
  • DELETE

It returns a date from a numeric datevalue.

  • FROM DAYS

An operator used to search for a pattern.

  • LIKE

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

  • False

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

  • Union All
  • Union
  • Minus
  • Intersect

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

  • UNION ALL

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

  • TRUNCATE TABLE CATEGORIES;

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

  • MOD

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

  • MAX

It returns the current database system UTC date and time.

  • GETUTCDATE

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

  • True
  • False

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

  • CEILING

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

  • LOG2

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

  • True
  • False

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

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 logically represents subsets of data from one or more table.

  • Index
  • View
  • Synonym
  • Table

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

  • Subtraction
  • Comparison
  • Logical Condition
  • Add

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

  • ISNULL

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

  • Instr
  • Field
  • Concat
  • Format

It converts a string to the upper-case.

  • toUpperCase

It returns the arc tangent of one or two numbers.

  • ATAN

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

  • WHERE

It is an association among several entities.

  • RELATIONSHIP

This command specifies the values of an INSERT INTO statement.

  • VALUES

It removes leading and trailing spaces from a string.

  • Ucase
  • Upper
  • Rtrim
  • Trim

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

  • TO DAYS

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.

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

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

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

  • POWER

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

  • TRUNCATE TABLE

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 restrict the rows that are returned by a query.

  • Where
  • Delete
  • Insert
  • Select

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

  • Insert
  • Union
  • Intersect
  • Position

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

  • True
  • False

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

  • Database Management System

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 numeric function that returns the number of records returned by a select query.

  • COS
  • ATAN
  • CEIL
  • COUNT

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

  • DATE SUB
  • DATE FORMAT
  • DATE ADD
  • DAYNAME

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

  • SUBTIME

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

  • UPDATE

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

  • Comparison
  • Like
  • Between
  • IN

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

  • CURRENT USER

It returns the current date and time.

  • CURRENT TIMESTAMP

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

  • UNION
Comments
Paypal Donation

To keep up this site, we need your assistance. A little gift will help us alot.

Donate

- The more you give the more you receive.

Related Subject

Object Oriented Programming Laboratory

Mobile Programming

Network Security

Management Information Systems

Managing Information and Technology

Mobile Application Design and Development

Mobile Application Design and Development 2

Living in the Information Technology Era

Mail and Web Services

Information Technology Practicum

Information Technology Capstone Project

Introduction to Computing

Intro to Hardware Description Language

Introduction to Human Computer

Introduction to Information Systems

Introduction to Multimedia

Integrative Programming and Technology 2

Internet Marketing and Entrepreneurship

Internet Technology in Real Estate

Information Assurance and Security 2

Information Assurance and Security 3

Information Security and Management

Information Systems Operations and Maintenance

Fundamentals of Investigation and Intelligence

Fundamentals of Database System

Digital Imaging

Data Communications and Networking

Cyber Security: Theories and Practice

Data Communications and Networking 2

Data Structures and Algorithms

Chemistry for Engineers

Computer Fundamentals

Animation Project

Load Testing

3D Game Art Development

Auditing and Assurance Concepts and Applications

Integrative Programming and Technology

Linux Administration

Software Engineering

Computer Programming

Applied Business Tools and Technologies

System Administration and Maintenance

Current Trends and Issues

Data Communications and Networking 4

Principles of Operating System and its Application

Systems Integration and Architecture

Application Lifecycle Management

Data Communications and Networking 3

Information Assurance and Security

Intrusion Detection System

Computer System

Network Administration

Computer Information Systems

Unified Functional Testing

Software Development

Mechatronics

Computer Numerical Control

Computer Science

Web Application Development

Web Systems Technologies

Web Development

Geographic Information Systems

Relational Database Systems

Advanced Database Management Systems


Show All Subject
Affiliate Links

Shopee Helmet

Shopee 3D Floor

Lazada Smart TV Box