(A) Mail server
(B) File server
(C) Client server
(D) None of the above
Tag: DBMS Mcq
Which model operates at the lowest level of abstraction?
(A) Conceptual
(B) Internal
(C) External
(D) Physical
A relational database is:
(A) One that consists of two or more tables
(B) A database that is able to process tables, queries, forms, reports and macros
(C) One that consists of two or more tables that are joined in some way
(D) The same as a flat file database
Which of the following can not be included into CREATE TABLE statement?
(A) Data types
(B) Constraints
(C) Attributes
(D) Cardinalities
Which of the following is used to retrieve and insert information from database?
(A) DML
(B) DDL
(C) DCL
(D) All of the above
Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server.
(A) True
(B) False
What happens if the WHERE clause is omitted from a DELETE statement?
(A) All records from the table are deleted
(B) No record from the table will be deleted
(C) First record of the table will be deleted
(D) The statement will not be executed and will give a syntax error
SQL data types do not have support for storing multi-media objects directly.
(A) True
(B) False