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 UsSharing is Caring
It's the biggest motivation to help us to make the site better by sharing this to your friends or classmates.
A software package designed to define, manipulate, retrieve and manage data in a database data format, field names, record structure and file structure.
It converts a value to a binary string.
The command to delete a view.
The NULL values or blank data in the report are not ignored during duplicate checking.
It returns the position of the first occurrence of a string in another string.
An alter statement that is used to delete an existing column in the table.
A command that combines the result set of two or more SELECT statements (allows duplicate values).
The function repeat returns the position of the first occurrence of a substring in a string.
It returns the remainder of a number divided by another number.
Are said to exhibit physical data independence if they do not depend on the physical schema.
It returns the position of a string within a list of strings.
An operator used to search for a pattern.
It returns a date from a numeric datevalue.
It compares two strings.
The command specifies the values of an INSERT INTO statement.
It is a unit of data – is a symbol or a set of symbols which is used to represent something.
It returns the current date and time.
True/False. This symbol % denotes zero or many characters.
A numeric function that returns the smallest integer value that is >= to a number.
The rows in the first query that are not present in the second query.
True/False Character values are format sensitive and date values are case sensitive-sensitive.
It returns the smallest integer value that is >= to a number.
The UPDATE constraint ensures that all values in a column are unique.
A function that returns the number of days between two date values.
A command that deletes the data inside a table, but not the table itself.
Which of the following is not true about writing SQL statements?
It compares two expressions and returns null if they are equal. Otherwise, the first expression is returned.
It adds a time/date interval to a date and then returns the date.
The DATE ADD returns the number of days between two date values.
It returns the character based on the ASCII code.
Write the SQL statement that deletes the table "Shippers".
It is a collection of interrelated data and a set of programs to access those data.
The command that deletes the data inside a table, but not the table itself.
This is used to in conditions that compare one expression with another value or expression.
It checks an expression and returns 1 if it is a valid date, otherwise 0.
Reversing the order of the intersected tables does not alter the result.
The DROP table command also adds and deletes various constraints in a table.
This is use to create expression with number and date values.
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.
A command that updates a view.
It subtracts a time interval from a datetime and then returns the time/datetime.
This command specifies the values of an INSERT INTO statement.
It returns the current database system UTC date and time.
Write the SQL statement that will update the contactname to "Juan" for all records where country is "Mexico".
A numeric function that returns the number of records returned by a select query.
It returns the arc tangent of one or two numbers.
It returns the user name and hostname for the MySQL account that the server used to authenticate the current client.
A function that returns e raised to the power of a specified number.
A function that adds two or more expressions together.
A syntax used to create a UNIQUE constraint on the "ID" column when the table is already created.
An operator used to specify multiple possible values for a column.
The command that adds, deletes or modifies columns in a table.
It converts a number from one numeric base system to another.
A copy of an existing table can also be created using CREATE TABLE.
Write a SQL statement that truncates the table "Categories".
It returns a specified part of a date (as integer).
A command that combines the result set of two or more SELECT statements or allows duplicate values.
This is used to restrict the rows that are returned by a query.
The command which deletes the data inside a table, but not the table itself.
An operator used to return all rows that are common to multiple queries.
It logically represents subsets of data from one or more table.
It returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table.
This is used to perform wildcard searches of valid search string values.
A command which deletes a table in the database.
Write the SQL statement that selects all the customers from "Mexico" in the "Customers" table.
It returns the natural logarithm of a number to base 2.
The WHERE clause is not only used in SELECT statement, it is also used in UPDATE, DELETE statement, etc.
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?
It returns the number of days between a date and date "0000-00-00".
It returns 1 or 0 depending on whether an expression is NULL.
The command used to create a new table in the database.
It converts a string to the upper-case.
The IFNULL returns a value if a condition is TRUE, or another value if a condition is FALSE.
It is an association among several entities.
It subtracts a time/date interval from a date and then returns the date.
This operator is used to return all rows from multiple queries or multiple tables.
The command which combines the result set of two or more SELECT statements or only a distinct values.
It returns the position of a pattern in a string.
This is used to test for values in a specified set of values.
It returns the session settings for a specified option.
The pow function returns the value of a number raised to the power of another number.
It returns the value of a number raised to the power of another number.
It removes leading and trailing spaces from a string.
Which of the following is the correct example of modifying the column JOB_ID? Change the datatype size to 10.
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.
A command which filters a result set to include only records that fulfill a specified condition.
A function that returns the maximum value in a set of values.
A function that returns a string of the specified number of space characters.
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 SubjectObject 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
Shopee Helmet
Shopee 3D Floor
Lazada Smart TV Box