Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Designers use which of the following to tune the performance of systems to support time-critical operations?
a. denormalization
b. redundant optimization
c. optimization
d. realization
Q. A table on the many side of a one to many or many to many relationship must:
a. be in second normal form (2nf)
b. be in third normal form (3nf)
c. have a single attribute key
d. have a composite key
Q. Which of the normal form is based on multivalued dependencies?
a. first
b. second
c. third
d. fourth
Q. What is the best way to represent the attributes in a large database?
a. relational-and
b. concatenation
c. dot representation
d. all of the mentioned
Q. Thus a of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
a. instance
b. snapshot
c. both instance and snapshot
d. all of the mentioned
Q. Representations such as the in the dept year relation, with one column for each value of an attribute, are called they are widely used in spreadsheets and reports and in data analysis tools.
a. cross-tabs
b. snapshot
c. both cross-tabs and snapshot
d. all of the mentioned
Q. An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:
a. web usability
b. persuasion
c. web accessibility
d. none of the mentioned
Q. A method of modelling and describing user tasks for an interactive application is referred to as:
a. customer journey
b. primary persona
c. use case
d. web design persona
Q. Also known as schematics, a way of illustrating the layout of an individual webpage is a:
a. wireframe
b. sitemap
c. card sorting
d. blueprint
Q. Blueprints are intended to:
a. prototype of the screen layout showing navigation and main design elements
b. show the grouping of pages and user journeys
c. indicate the structure of a site during site design and as a user feature
d. prototype typical customer journeys or clickstreams through a website
Q. Storyboards are intended to:
a. indicate the structure of a site during site design and as a user feature
b. prototype of the screen layout showing navigation and main design elements
c. integrate consistently available components on the webpage (e.g. navigation, search boxes)
d. prototype typical customer journeys or click streams through a website
Q. Which of the following is a valid uniform resource locator?
a. http://www.acm.org/sigmod
b. www.google.com
c. www.ann.in
d. http:/www.acm.org/sigmod/
Q. A is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.
a. html
b. http
c. web server
d. web browser
Q. The application program typically communicates with a database server, through or other protocols, in order to get or store data.
a. jdbc
b. odbc
c. all of the mentioned
d. none of the mentioned