ITI COPA Database Management System: MS Access MCQ

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

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

All data in a relational database is stored in

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

This clause lets you eliminate duplicate rows from the query result

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

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

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

It is used for lengthy text and numbers

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

_______ is the programming language that defines and manipulates the database

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

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

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

A field name can have maximum upto _______ characters