(A) Sort by month name
(B) Sort by month number
(C) Define the field with the data type month and sort Ascending
(D) Define the field with the data type month and sort Descending
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
Which of the following is not an advantage of a menu driven database system?
(A) Help make the database applications system user-friendly by eliminating the need to remember command languages
(B) Provide security though user-level logins
(C) Control access by providing only those options that allow people to do their jobs
(D) Create an environment that is tailored to specific types of applications and end users
What are the advantages of form-based dialog boxes?
(A) They have more prompting options than dialog boxes generated by Access
(B) They allow the use of combo boxes
(C) Access-generated dialog boxes are likely to disrupt interface layout schemes, while form-based dialog boxes are not
(D) All of the above
What is the most common form type?
(A) A single-source form, based on a tabular format
(B) A single-source form, based on a columnar format
(C) A multi-source form, based on a tabular format
(D) A multi-source form, based on a columnar format
Which of the following correctly describes the relationship between forms and tables?
(A) A form is based on exactly one table. The table must exist before the form is created
(B) A form is based on exactly one table. The table may be created before or after the form is created
(C) A form may be based on one or more tables. The table(s) must exist before the form is created
(D) A form may be based on one or more tables. The table(s) may be created before or after the form is created
Which of the following are not functions of forms?
(A) Forms are used to tie together the database components through menu structures
(B) Forms extend data validation rules through queries, value lists, and other input control devices
(C) Forms are used to enter new data and to edit existing data
(D) Forms program and control user responses
What does the wildcard ? Match?
(A) Zero or more of the preceding character
(B) Any one character in the position held by the ?
(C) Multiple characters in the position held by the ?
(D) Any letter in the position held by the ?
EMP_DOB holds employee birth dates. Which format will display the month in number format, such as 01 or 11?
(A) Month: Format([EMP_DOB],”m”)
(B) Month: Format([EMP_DOB],”mm”)
(C) Month: Format([EMP_DOB],”mmm”)
(D) Month: Format([EMP_DOB],”mmmm”)