Q. Which data manipulation command is used to combines the records from one or more tables?
A. SELECT
B. PROJECT
C. JOIN
D. PRODUCT
Answer : JOIN [Option : C]
Show Answer
Q. Which of the following is not a valid SQL type?
A. DECIMAL
B. NUMERIC
C. FLOAT
D. CHARACTER
Answer : DECIMAL [Option : A]
Show Answer
Q. SQL permits attribute names to be repeated in the same relation. (True or False)
A. FALSE
B. TRUE
Answer : FALSE [Option : A]
Show Answer
Q. Which operator is used to compare a value to a specified list of values?
A. BETWEEN
B. ANY
C. IN
D. ALL
Answer : IN [Option : C]
Show Answer
Q. A SQL query automatically eliminates duplicates (True / False) ?
A. TRUE
B. FALSE
Answer : FALSE [Option : B]
Q. The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B. DDL
C. VDL
D. SDL
Answer : DML [Option : A]
Show Answer
Q. The command used to delete a particular column in a relation is ____________
A. UPDATE TABLE
B. TRUNCATE COLUMN
C. ALTER , DROP
D. DELETE COLUMN
Answer : ALTER , DROP [Option : C]
Show Answer
Q. Which of the following operations requires the relations to be union compatible?
A. UNION
B. INTERSECTION
C. DIFFERENCE
D. ALL OF THESE
Answer : ALL OF THESE [Option : D]
Show Answer
Q. The database language that allows us to access data in a database is called :
A. DCL
B. DML
C. DDL
D. None Of Above
Show Answer
Q. Which of the following is a comparison operator in SQL?
A. Double equal sign ( == )
B. LIKE
C. BETWEEN
D. Single equal sign ( = )
Answer : Double equal sign ( == ) [Option : A]
Q. Which of the following is a legal expression in SQL?
A. SELECT NULL FROM SALES;
B. SELECT NAME FROM SALES;
C. SELECT * FROM SALES WHEN PRICE = NULL;
D. SELECT # FROM SALES;
Answer : SELECT NAME FROM SALES; [Option : B]
Show Answer
Q. DCL provides commands to performactionslike
A. Change thestructureof Tables
B. Insert, Update or Delete Records and Values
C. Authorizing Access and othercontrolover Database
D. None of Above
Answer : Authorizing Access and othercontrolover Database [Option : C]
Show Answer
Q. The COUNT function in SQL returns the number of ______________
A. Values
B. Distinct values
C. Group By
D. Columns
Answer : Values [Option : A]
Show Answer
Q. Which data type can store unstructured data in a column?
A. RAW
B. CHAR
C.NUMERIC
D. VARCHAR
Answer : RAW [Option : A]
Show Answer
Q. A SQL query will not work if there are no indexes on the relations - Is it true ?
A. NO
B. YES
Answer : NO [Option : A]
Q. Which function is used to divides one numeric expression by another and get the remainder ?
A. POWER
B. MOD
C. ROUND
D. REMAINDER
Answer : MOD [Option : B]
Show Answer
Q. What is the full form of DDL ?
A. Dynamic Data Language
B. Detailed Data Language
C. Data Definition Language
D. Data Derivation Language
Answer : Data Definition Language [Option : C]
Show Answer
Q. A database language used for defining the whole databasestructureand schema is called :
A. DCL
B. DML
C. DDL
D. All Of Above
Answer : DDL [Option : C]
Show Answer
Q. The virtual table that its created by data from the result of an SQL 'Select' statement is called _________
A. View
B. Synonym
C. Sequence
D. Transaction
Answer : View [Option : A]
Show Answer
Q. Which statement in SQL allows us to change the definition of a table is?
A. ALTER
B. UPDATE
C. CREATE
D. SELECT
Q. What do you mean by one to many relationship between Teacher and Class table?
A. One class may have many teachers
B. One teacher can have many classes
C. Many classes may have many teachers
D. Many teachers may have many classes
Answer : One teacher can have many classes [Option : B]
Show Answer
Q. What are the different view to present a Table ?
A. Datasheet View
B. Design View
C. Pivote TableView
D. All Of Above
Answer : All Of Above [Option : D]
Show Answer
Q. In one-to-many relationship the table on 'many' side is called _______
A. Parent
B. Child
C. Sister
D. Master
Answer : Child [Option : B]
Show Answer
Q. In which state one gathers and list all the necessary fields for the database design project.
A. Data Definition
B. Data Refinement
C. Establishing Relationship
D. None Of The Above
Answer : Data Definition [Option : A]
Show Answer
Q. Which of the following enables us to view data from a table based on a specific criterion
A. Form
B. Query
C. Macro
D. Report
Answer : Query [Option : B]
Show Answer
Q. Which database object is ideal to view, change, andanalyze datain different ways ?
A. Table
B. Form
C. Query
D. Report
Answer : Query [Option : C]
Show Answer
Q. In one-to-many relationship the table in 'one' side is called _______
A. Child
B. Owner
C. Parent
D. Owner
Answer : Parent [Option : C]
Show Answer
Q. Which data type allows alphanumeric characters and special symbols to be entered?
A. Text
B. Memo
C. Auto number
D. Mixed
Answer : Text [Option : A]
Show Answer
Q. It is used to establish an association between related tables.
A. Line
B. Relationship
C. Primary Key
D. Records
Show Answer
Q. This key that uniquely identifies each record is called :
A. Primary Key
B. Key Record
C. Unique Key
D. Field Name
Answer : Primary Key [Option : A]
Q. Which name must be unique within a database ?
A. Table
B. Field
C. Record
D. Character
Answer : Table [Option : A]
Show Answer
Q. The third stage of designing a database is when we create___________ between tables
A. Relationship
B. Join
C. Query
D. None of These
Answer : Relationship [Option : A]
Show Answer
Q. Two tables can be linked with relationship to _____
A. Ensure data entry
B. Ensure data integrity
C. Create Primary Key
D. Ensure Foreign Key
Answer : Ensure data integrity [Option : B]
Show Answer
Q. In a database Table, the each category of information Is called __________
A. Tuple
B. Field
C. Record
D. All Of Above
Answer : Field [Option : B]
Show Answer
Q. Which of the following fields has width of 8 bytes?
A. Memo
B. Number
C. Date/time
D. Hyperlink
Answer : Date/time [Option : C]
Q. which of the following is not a database object?
A. Tables
B. Queries
C. Relationships
D. Reports
Answer : Relationships [Option : C]
Show Answer
Q. Which one is the guideline of Referential integrity in a relationship ?
A. Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table
B. Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
C. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
D. Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table
Answer : Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table [Option : C]
Show Answer
Q. Which of the following is not a database model
A. Network Database Model
B. Relational Database Model
C. Object Oriented Database Model
D. None
Answer : None [Option : D]
Show Answer
Q. The overall description of a database is called______.
A. Data integrity
B. Data manipulation
C. Database schema
D. Data definition
Answer : Database schema [Option : C]
Show Answer
Q. A data dictionary is a repository that manages _____
A. Memory
B. Metadata
C. Spell Checker
D. Data Validator
Answer : Metadata [Option : B]
Q. Which of the following are not Java keywords ?
A. double
B. switch
C. then
D.instanceof
Answer : then [Option : C]
A. SELECT
B. PROJECT
C. JOIN
D. PRODUCT
Answer : JOIN [Option : C]
Show Answer
Q. Which of the following is not a valid SQL type?
A. DECIMAL
B. NUMERIC
C. FLOAT
D. CHARACTER
Answer : DECIMAL [Option : A]
Show Answer
Q. SQL permits attribute names to be repeated in the same relation. (True or False)
A. FALSE
B. TRUE
Answer : FALSE [Option : A]
Show Answer
Q. Which operator is used to compare a value to a specified list of values?
A. BETWEEN
B. ANY
C. IN
D. ALL
Answer : IN [Option : C]
Show Answer
Q. A SQL query automatically eliminates duplicates (True / False) ?
A. TRUE
B. FALSE
Answer : FALSE [Option : B]
Q. The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B. DDL
C. VDL
D. SDL
Answer : DML [Option : A]
Show Answer
Q. The command used to delete a particular column in a relation is ____________
A. UPDATE TABLE
B. TRUNCATE COLUMN
C. ALTER , DROP
D. DELETE COLUMN
Answer : ALTER , DROP [Option : C]
Show Answer
Q. Which of the following operations requires the relations to be union compatible?
A. UNION
B. INTERSECTION
C. DIFFERENCE
D. ALL OF THESE
Answer : ALL OF THESE [Option : D]
Show Answer
Q. The database language that allows us to access data in a database is called :
A. DCL
B. DML
C. DDL
D. None Of Above
Show Answer
Q. Which of the following is a comparison operator in SQL?
A. Double equal sign ( == )
B. LIKE
C. BETWEEN
D. Single equal sign ( = )
Answer : Double equal sign ( == ) [Option : A]
Q. Which of the following is a legal expression in SQL?
A. SELECT NULL FROM SALES;
B. SELECT NAME FROM SALES;
C. SELECT * FROM SALES WHEN PRICE = NULL;
D. SELECT # FROM SALES;
Answer : SELECT NAME FROM SALES; [Option : B]
Show Answer
Q. DCL provides commands to performactionslike
A. Change thestructureof Tables
B. Insert, Update or Delete Records and Values
C. Authorizing Access and othercontrolover Database
D. None of Above
Answer : Authorizing Access and othercontrolover Database [Option : C]
Show Answer
Q. The COUNT function in SQL returns the number of ______________
A. Values
B. Distinct values
C. Group By
D. Columns
Answer : Values [Option : A]
Show Answer
Q. Which data type can store unstructured data in a column?
A. RAW
B. CHAR
C.NUMERIC
D. VARCHAR
Answer : RAW [Option : A]
Show Answer
Q. A SQL query will not work if there are no indexes on the relations - Is it true ?
A. NO
B. YES
Answer : NO [Option : A]
Q. Which function is used to divides one numeric expression by another and get the remainder ?
A. POWER
B. MOD
C. ROUND
D. REMAINDER
Answer : MOD [Option : B]
Show Answer
Q. What is the full form of DDL ?
A. Dynamic Data Language
B. Detailed Data Language
C. Data Definition Language
D. Data Derivation Language
Answer : Data Definition Language [Option : C]
Show Answer
Q. A database language used for defining the whole databasestructureand schema is called :
A. DCL
B. DML
C. DDL
D. All Of Above
Answer : DDL [Option : C]
Show Answer
Q. The virtual table that its created by data from the result of an SQL 'Select' statement is called _________
A. View
B. Synonym
C. Sequence
D. Transaction
Answer : View [Option : A]
Show Answer
Q. Which statement in SQL allows us to change the definition of a table is?
A. ALTER
B. UPDATE
C. CREATE
D. SELECT
Q. What do you mean by one to many relationship between Teacher and Class table?
A. One class may have many teachers
B. One teacher can have many classes
C. Many classes may have many teachers
D. Many teachers may have many classes
Answer : One teacher can have many classes [Option : B]
Show Answer
Q. What are the different view to present a Table ?
A. Datasheet View
B. Design View
C. Pivote TableView
D. All Of Above
Answer : All Of Above [Option : D]
Show Answer
Q. In one-to-many relationship the table on 'many' side is called _______
A. Parent
B. Child
C. Sister
D. Master
Answer : Child [Option : B]
Show Answer
Q. In which state one gathers and list all the necessary fields for the database design project.
A. Data Definition
B. Data Refinement
C. Establishing Relationship
D. None Of The Above
Answer : Data Definition [Option : A]
Show Answer
Q. Which of the following enables us to view data from a table based on a specific criterion
A. Form
B. Query
C. Macro
D. Report
Answer : Query [Option : B]
Show Answer
Q. Which database object is ideal to view, change, andanalyze datain different ways ?
A. Table
B. Form
C. Query
D. Report
Answer : Query [Option : C]
Show Answer
Q. In one-to-many relationship the table in 'one' side is called _______
A. Child
B. Owner
C. Parent
D. Owner
Answer : Parent [Option : C]
Show Answer
Q. Which data type allows alphanumeric characters and special symbols to be entered?
A. Text
B. Memo
C. Auto number
D. Mixed
Answer : Text [Option : A]
Show Answer
Q. It is used to establish an association between related tables.
A. Line
B. Relationship
C. Primary Key
D. Records
Show Answer
Q. This key that uniquely identifies each record is called :
A. Primary Key
B. Key Record
C. Unique Key
D. Field Name
Answer : Primary Key [Option : A]
Q. Which name must be unique within a database ?
A. Table
B. Field
C. Record
D. Character
Answer : Table [Option : A]
Show Answer
Q. The third stage of designing a database is when we create___________ between tables
A. Relationship
B. Join
C. Query
D. None of These
Answer : Relationship [Option : A]
Show Answer
Q. Two tables can be linked with relationship to _____
A. Ensure data entry
B. Ensure data integrity
C. Create Primary Key
D. Ensure Foreign Key
Answer : Ensure data integrity [Option : B]
Show Answer
Q. In a database Table, the each category of information Is called __________
A. Tuple
B. Field
C. Record
D. All Of Above
Answer : Field [Option : B]
Show Answer
Q. Which of the following fields has width of 8 bytes?
A. Memo
B. Number
C. Date/time
D. Hyperlink
Answer : Date/time [Option : C]
Q. which of the following is not a database object?
A. Tables
B. Queries
C. Relationships
D. Reports
Answer : Relationships [Option : C]
Show Answer
Q. Which one is the guideline of Referential integrity in a relationship ?
A. Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table
B. Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
C. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
D. Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table
Answer : Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table [Option : C]
Show Answer
Q. Which of the following is not a database model
A. Network Database Model
B. Relational Database Model
C. Object Oriented Database Model
D. None
Answer : None [Option : D]
Show Answer
Q. The overall description of a database is called______.
A. Data integrity
B. Data manipulation
C. Database schema
D. Data definition
Answer : Database schema [Option : C]
Show Answer
Q. A data dictionary is a repository that manages _____
A. Memory
B. Metadata
C. Spell Checker
D. Data Validator
Answer : Metadata [Option : B]
Q. Which of the following are not Java keywords ?
A. double
B. switch
C. then
D.instanceof
Answer : then [Option : C]
No comments:
Post a Comment