A data dictionary is a repository that manages _____
1.Memory
2.Metadata
3.Spell Checker
4.Data Validator
A database language used for defining the whole databasestructureand schema is called :
1.DCL
2.DML
3.DDL
4.All Of Above
DCL provides commands to performactionslike
1.Change thestructureof Tables
2.Insert, Update or Delete Records and Values
3.Authorizing Access and othercontrolover Database
4.None of Above
If we want define style for an unique element, then which css selector will we use ?
1.Id
2.text
3.class
4.name
If we want to show an Arrow as cursor, then which value we will use ?
1.pointer
2.default
3.arrow
4.arr
If we want to use a nice looking green dotted border around an image, which css property will we use?
1.border-color
2.border-decoration
3.border-style
4.border-line
If we want to wrap a block of text around an image, which css property will we use ?
1.wrap
2.push
3.float
4.align
In a database Table, the each category of information Is called __________
1.Tuple
2.Field
3.Record
4.All Of Above
In which state one gathers and list all the necessary fields for the database design project.
1.Data Definition
2.Data Refinement
3.Establishing Relationship
4.None Of The Above
It is used to establish an association between related tables.
1.Line
2.Relationship
3.Primary Key
4.Records
Suppose we want to arragnge five nos. of DIVs so that DIV4 is placed above DIV1. Now, which css property will we use to control the order of stack?
1.d-index
2.s-index
3.x-index
4.z-index
The command used to delete a particular column in a relation is ____________
1.UPDATE TABLE
2.TRUNCATE COLUMN
3.ALTER , DROP
4.DELETE COLUMN
The COUNT function in SQL returns the number of ______________
1.Values
2.Distinct values
3.Group By
4.Columns
The database language that allows us to access data in a database is called :
1.DCL
2.DML
3.DDL
4.None Of Above
The overall description of a database is called______.
1.Data integrity
2.Data manipulation
3.Database schema
4.Data definition
The SQL used by front-end application programs to request data from the DBMS is called _______
1.DML
2.DDL
3.VDL
4.SDL
The third stage of designing a database is when we create___________ between tables
1.Relationship
2.Join
3.Query
4.None of These
This key that uniquely identifies each record is called :
1.Primary Key
2.Key Record
3.Unique Key
4.Field Name
Two tables can be linked with relationship to _____
1.Ensure data entry
2.Ensure data integrity
3.Create Primary Key
4.Ensure Foreign Key
What are the different view to present a Table ?
1.Datasheet View
2.Design View
3.Pivote TableView
4.All Of Above
What do you mean by one to many relationship between Teacher and Class table?
1.One class may have many teachers
2.One teacher can have many classes
3.Many classes may have many teachers
4.Many teachers may have many classes
What is the full form of DDL ?
1.Dynamic Data Language
2.Detailed Data Language
3.Data Definition Language
4.Data Derivation Language
What should be the table width, so that the width of a table adjust to the current width of the browser window?
1.640 pixels
2.100%
3.full-screen
4.1024 px
When we write <img src="img.png">, what "img.png" inside double quote implies?
1.element
2.attribute
3.value
4.operator
Which attribute can be added to many HTML / XHTML elements to identify them as a member of a specific group ?
1.Id
2.div
3.class
4.span
Which data manipulation command is used to combines the records from one or more tables?
1.SELECT
2.PROJECT
3.JOIN
4.PRODUCT
Which data type allows alphanumeric characters and special symbols to be entered?
1.Text
2.Memo
3.Auto number
4.Mixed
Which data type can store unstructured data in a column?
1.RAW
2.CHAR
3.NUMERIC
4.VARCHAR
Which database object is ideal to view, change, andanalyze datain different ways ?
1.Table
2.Form
3.Query
4.Report
Which element is used in the <HEAD> section on an HTML / XHTMLpage, if we want to use an external style sheet file to decorate the page ?
1.<src>
2.<link>
3.<style>
4.<css>
Which function is used to divides one numeric expression by another and get the remainder ?
1.POWER
2.MOD
3.ROUND
4.REMAINDER
Which name must be unique within a database ?
1.Table
2.Field
3.Record
4.Character
Which of the following enables us to view data from a table based on a specific criterion
1.Form
2.Query
3.Macro
4.Report
Which of the following fields has width of 8 bytes?
1.Memo
2.Number
3.Date/time
4.Hyperlink
Which of the following is a comparison operator in SQL?
1.Double equal sign ( == )
2.LIKE
3.BETWEEN
4.Single equal sign ( = )
Which of the following is a legal expression in SQL?
1.SELECT NULL FROM SALES;
2.SELECT NAME FROM SALES;
3.SELECT * FROM SALES WHEN PRICE = NULL;
4.SELECT # FROM SALES;
Which of the following is not a database model
1.Network Database Model
2.Relational Database Model
3.Object Oriented Database Model
4.None
which of the following is not a database object?
1.Tables
2.Queries
3.Relationships
4.Reports
Which of the following is not a valid SQL type?
1.DECIMAL
2.NUMERIC
3.FLOAT
4.CHARACTER
Which of the following operations requires the relations to be union compatible?
1.UNION
2.INTERSECTION
3.DIFFERENCE
4.ALL OF THESE
Which of the following properties will we use to display border around a cell without any content ?
1.empty-cell
2.blank-cell
3.noncontent-cell
4.void-cell
Which operator is used to compare a value to a specified list of values?
1.BETWEEN
2.ANY
3.IN
4.ALL
Which statement in SQL allows us to change the definition of a table is?
1.ALTER
2.UPDATE
3.CREATE
4.SELECT