ITI COPA Database Management System: MS Access MCQ

It is helpful when you simply want to know if the value is present in a table or not

This operator returns TRUE if at least one of the operands evaluate to true

it is a small box or bar that when clicked, selects an entire row in a table

This category of commands contains only one command: SELECT

The function returns all the characters in the input string in uppercase

It is a Stored Procedure that is fired when a table is modified

A field name can have maximum upto _______ characters

This operator returns TRUE if at least one of the operands evaluate to true

It is a customized presentation of the data from one or more tables from a database

This clause lets you eliminate duplicate rows from the query result

It is used for lengthy text and numbers

This operator returns TRUE if at least one of the operands evaluate to true

All data in a relational database is stored in

_______ is the programming language that defines and manipulates the database

The char data type allows the maximum size of up to _____ characters.

This function returns an input string with the first character of each word in upper case.

It is a copy of either a full table or a subset of a table