ITI COPA Database Management System: MS Access MCQ

A field name can have maximum upto _______ characters

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

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

All data in a relational database is stored in

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

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

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

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

It is used for lengthy text and numbers

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

This category of commands contains only one command: SELECT

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

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 operator returns TRUE if at least one of the operands evaluate to true

This clause lets you eliminate duplicate rows from the query result

_______ is the programming language that defines and manipulates the database