10th Class Computers Science Database Management 2 Question Bank

done MCQs - Data Base Management System Total Questions - 127

• question_answer1)
  Database is an organised collection of.....................
  A)
  Data       done clear
  B)
  Attributes done clear
  C)
  Record              done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer2)
  DBMS stands for.....................
  A)
  Database Management System done clear
  B)
  Database Master System done clear
  C)
  Database Management Structure  done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer3)
  RDBMS stands for
  A)
  Relation Data Module System done clear
  B)
  Right Data Base Management System done clear
  C)
  Relational Database Management System done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer4)
  A DVD store maintains a customer database. Each new customer is asked to complete a form by providing his or her contact details, including address, phone numbers and email contact. Each time a customer borrows a DVD, the customer is asked to confirm his or her address details only, and updates are made as needed. Which statement about the quality of this data is true?
  A)
  The data quality is good because the data stored is always up to date. done clear
  B)
  The data quality is good because the data stored is constantly revised. done clear
  C)
  The data quality is poor because much of the data could be out of date and there is no way of checking. done clear
  D)
  The data quality is poor because there are no verification procedures in place to ensure it is accurate. done clear
  View Solution play_arrow

• question_answer5)
  Which of the following is not an example of a database?
  A)
  Cross n Knot Game  done clear
  B)
  Employee Payroll Management done clear
  C)
  Numeric Calculator done clear
  D)
  Customer Management System done clear
  View Solution play_arrow

• question_answer6)
  Out of the following, which one is the most appropriate data field in context of the employee table if only one of these is required?
  A)
  Age in years         done clear
  B)
  Date of birth done clear
  C)
  Age in days       done clear
  D)
  Age in months done clear
  View Solution play_arrow

• question_answer7)
  Which is not true for a database file?
  A)
  Each record may contain several fields        done clear
  B)
  Fields are organised in columns done clear
  C)
  Data types have to be declared in advance    done clear
  D)
  Each field may contain several records done clear
  View Solution play_arrow

• question_answer8)
  Which of the following describes a relational database?
  A)
  It provides a relationship between integers.     done clear
  B)
  It consists of separate tables of related data. done clear
  C)
  It retrieves data related to its queries.   done clear
  D)
  It provides a relationship between floats. done clear
  View Solution play_arrow

• question_answer9)
  Which of these terms refers to a collection of related information?
  A)
  Database                       done clear
  B)
  List done clear
  C)
  Outline                 done clear
  D)
  Record done clear
  View Solution play_arrow

• question_answer10)
  A row in a table is also known as
  A)
  Record              done clear
  B)
  Field done clear
  C)
  Data type                      done clear
  D)
  Data done clear
  View Solution play_arrow

• question_answer11)
  Which of the following examples would be best stored in database?
  A)
  Video clip done clear
  B)
  Family portrait done clear
  C)
  Club membership details done clear
  D)
  An article in school magazine done clear
  View Solution play_arrow

• question_answer12)
  Duplication of data is called....................
  A)
  Inconsistency       done clear
  B)
  Consistency done clear
  C)
  Redundancy                   done clear
  D)
  Foreign Key done clear
  View Solution play_arrow

• question_answer13)
  ............... is dedicated computers that hold the actual databases and run only DBMS and related Software.
  A)
  Main Server done clear
  B)
  Web Server done clear
  C)
  Database Server done clear
  D)
  Non Database Server done clear
  View Solution play_arrow

• question_answer14)
  Which of the following is not the advantage of database?
  A)
  Sharing of Data  done clear
  B)
  Reduce Data Redundancy done clear
  C)
  Increased Data Inconsistency done clear
  D)
  Data Security done clear
  View Solution play_arrow

• question_answer15)
  Which of the following will help to maintain unique record in the table?
  A)
  Foreign Key         done clear
  B)
  Primary Key done clear
  C)
  Composite Key done clear
  D)
  Alternate Key done clear
  View Solution play_arrow

• question_answer16)
  ............... key can be a primary key?
  A)
  Foreign                 done clear
  B)
  Primary done clear
  C)
  Candidate                      done clear
  D)
  Composite done clear
  View Solution play_arrow

• question_answer17)
  Which key is used to make relations between two tables?
  A)
  Foreign                 done clear
  B)
  Primary       done clear
  C)
  Candidate             done clear
  D)
  Composite done clear
  View Solution play_arrow

• question_answer18)
  Which of the following field of table Employee can act as a primary key?
  A)
  Employee Name done clear
  B)
  Age done clear
  C)
  Salary  done clear
  D)
  Employee Identification Number done clear
  View Solution play_arrow

• question_answer19)
  When primary key is made up of two or more columns, then it is called a ..............primary key.
  A)
  Mixed             done clear
  B)
  Reference done clear
  C)
  Composite          done clear
  D)
  Compost done clear
  View Solution play_arrow

• question_answer20)
  A key which is referring to the primary key of another table is called................
  A)
  Alternate Key     done clear
  B)
  Primary Key done clear
  C)
  First Primary Key done clear
  D)
  Foreign Key done clear
  View Solution play_arrow

• question_answer21)
  Which one of the following attribute can be taken as a primary key?
  A)
  Name                   done clear
  B)
  Street done clear
  C)
  Adhaar Number   done clear
  D)
  Department done clear
  View Solution play_arrow

• question_answer22)
  .............. is a property of relation that identifies unique value in a relation.
  A)
  Rows                    done clear
  B)
  Key done clear
  C)
  Attribute               done clear
  D)
  Fields done clear
  View Solution play_arrow

• question_answer23)
  Which of the following is not a Key in database?
  A)
  Primary               done clear
  B)
  Foreign done clear
  C)
  Alternate               done clear
  D)
  Secondary done clear
  View Solution play_arrow

• question_answer24)
  A key which is a set of one or more columns that can identify a record uniquely is called?
  A)
  Natural key         done clear
  B)
  Candidate key done clear
  C)
  Not Null key        done clear
  D)
  Alternate key done clear
  View Solution play_arrow

• question_answer25)
  When data is stored, maintained and retrieved from multiple tables then special database software are required called...............
  A)
  DBMS   done clear
  B)
  RDBMS done clear
  C)
  Special DBMS     done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer26)
  The primary key of a database must always
  A)
  Be sorted done clear
  B)
  Used an auto number data type. done clear
  C)
  Have an entry for each record. done clear
  D)
  Contain entries that are a combination of text and numbers. done clear
  View Solution play_arrow

• question_answer27)
  What part of a database holds all of the information about one item or subject?
  A)
  Record                 done clear
  B)
  File done clear
  C)
  Query                   done clear
  D)
  Chart   done clear
  View Solution play_arrow

• question_answer28)
  Facilities offered by databases are
  A)
  The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports done clear
  B)
  Easy editing, spell check, perform calculations, library of mathematical functions, replication done clear
  C)
  The ability to rotate images, copy and paste, fill scale done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer29)
  Which of the following fields would not make a suitable primary key?
  A)
  A date field        done clear
  B)
  An invoice number done clear
  C)
  An Auto Number field done clear
  D)
  A customer's social security number done clear
  View Solution play_arrow

• question_answer30)
  Which of the following is not true for a database table?
  A)
  It may contain multiple records done clear
  B)
  It may contain multiple tables done clear
  C)
  It may contain multiple columns       done clear
  D)
  It may contain multiple candidate keys. done clear
  View Solution play_arrow

• question_answer31)
  In RDBMS, data is organised in the form of........................
  A)
  Table    done clear
  B)
  Record done clear
  C)
  Field      done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer32)
  A ................ is an object you can use to customise the display of data in a table or query.
  A)
  Table                    done clear
  B)
  Form done clear
  C)
  View                     done clear
  D)
  Relation done clear
  View Solution play_arrow

• question_answer33)
  All the values in ................. are of same type.
  A)
  Records                done clear
  B)
  Table done clear
  C)
  Database              done clear
  D)
  Fields done clear
  View Solution play_arrow

• question_answer34)
  .............. represents a single data item in a table.
  A)
  Tuples                  done clear
  B)
  Attributes done clear
  C)
  Relation                done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer35)
  ............. are the basic building blocks of a database.
  A)
  Tables               done clear
  B)
  Record done clear
  C)
  Fields                    done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer36)
  We can create table in.................
  A)
  In design view done clear
  B)
  Using Wizard done clear
  C)
  Both of the above done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer37)
  By default data type of fields is
  A)
  Text[Varchar]      done clear
  B)
  Text[Char] done clear
  C)
  Int                         done clear
  D)
  Long done clear
  View Solution play_arrow

• question_answer38)
  Which of the following best describes a query?
  A)
  A query enables people to enter or view data in your database easily done clear
  B)
  A query summarizes and prints data done clear
  C)
  A query retrieves data that satisfies conditions that you set done clear
  D)
  Data done clear
  View Solution play_arrow

• question_answer39)
  Which of the following database components can be used to make it easier for you to enter data into a table?
  A)
  Form                   done clear
  B)
  Query done clear
  C)
  Report                 done clear
  D)
  Table done clear
  View Solution play_arrow

• question_answer40)
  A database is made up of all the following components except
  A)
  Tables                  done clear
  B)
  Queries done clear
  C)
  Forms                  done clear
  D)
  Formula bars done clear
  View Solution play_arrow

• question_answer41)
  ................ is an object you can use to customise the display of data in a table or query.
  A)
  Table                    done clear
  B)
  Form done clear
  C)
  View                    done clear
  D)
  Relation done clear
  View Solution play_arrow

• question_answer42)
  ................... displays specific records from a table that meet a certain criteria.
  A)
  Form                    done clear
  B)
  Query done clear
  C)
  Report                done clear
  D)
  Table done clear
  View Solution play_arrow

• question_answer43)
  The formatted way of the user that is used to retrieve data from one or more tables of the database and to represent it is called?
  A)
  Table                    done clear
  B)
  Report done clear
  C)
  Form                    done clear
  D)
  Relationship done clear
  View Solution play_arrow

• question_answer44)
  .............. kind of information a field contains whether it is text, number, date/time, or some other type.
  A)
  Field                   done clear
  B)
  Data type done clear
  C)
  Record                  done clear
  D)
  Form done clear
  View Solution play_arrow

• question_answer45)
  Which field type will you select if you need to enter long text in that field?
  A)
  Text                     done clear
  B)
  Long VarChar done clear
  C)
  Currency             done clear
  D)
  Hyperlink done clear
  View Solution play_arrow

• question_answer46)
  Which Data Type is used to store characters?
  A)
  Text                      done clear
  B)
  Integer done clear
  C)
  Double/Real          done clear
  D)
  Boolean done clear
  View Solution play_arrow

• question_answer47)
  Which Data Type is used to store whole numbers?
  A)
  String                   done clear
  B)
  Integer done clear
  C)
  Double/Real          done clear
  D)
  Boolean done clear
  View Solution play_arrow

• question_answer48)
  Which Data Type is used to store data with only two possible answers?
  A)
  String                 done clear
  B)
  Integer done clear
  C)
  Double/Real         done clear
  D)
  Boolean done clear
  View Solution play_arrow

• question_answer49)
  What can be the maximum length of a char field?
  A)
  120                      done clear
  B)
  255 done clear
  C)
  265                       done clear
  D)
  75 done clear
  View Solution play_arrow

• question_answer50)
  Which data type will be appropriate to store information as Salary, Fees, Price etc.?
  A)
  Alphanumeric Data types                    done clear
  B)
  Numeric Data type done clear
  C)
  Binary Data types done clear
  D)
  Date Time done clear
  View Solution play_arrow

• question_answer51)
  By default, the length of Varchar data type is............
  A)
  20                        done clear
  B)
  30 done clear
  C)
  40                         done clear
  D)
  50 done clear
  View Solution play_arrow

• question_answer52)
  Which of the following is not a numeric data type?                                 
  A)
  Tinyint            done clear
  B)
  Smallint done clear
  C)
  Boolean               done clear
  D)
  Date done clear
  View Solution play_arrow

• question_answer53)
  Which of the following data types can-not store decimal values?
  A)
  Decimal            done clear
  B)
  Real done clear
  C)
  Numeric               done clear
  D)
  Boolean done clear
  View Solution play_arrow

• question_answer54)
  Which of the following will occupy more space in computer memory?
  A)
  Bigint                   done clear
  B)
  Integer done clear
  C)
  Smallint                done clear
  D)
  Boolean done clear
  View Solution play_arrow

• question_answer55)
  .................... data types are used for storing photos, music files etc.
  A)
  Binary                 done clear
  B)
  Alphanumeric done clear
  C)
  Numeric               done clear
  D)
  Special done clear
  View Solution play_arrow

• question_answer56)
  Char is a................ length data type and varchar is a .............. length data type.
  A)
  Fixed, Variable    done clear
  B)
  Variable, Fixed done clear
  C)
  Variable, Variable done clear
  D)
  Fixed, Fixed done clear
  View Solution play_arrow

• question_answer57)
  By default the length of the Integer data type is..................
  A)
  25                        done clear
  B)
  15 done clear
  C)
  12                        done clear
  D)
  10 done clear
  View Solution play_arrow

• question_answer58)
  What data type should you choose for a zip code field in a table?
  A)
  Text                      done clear
  B)
  Number done clear
  C)
  Real                  done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer59)
  Which of the following is not a data type?
  A)
  Picture               done clear
  B)
  Date/time done clear
  C)
  Text                      done clear
  D)
  Number done clear
  View Solution play_arrow

• question_answer60)
  Which property ensures that field cannot be left blank?
  A)
  Format                done clear
  B)
  Required Entry done clear
  C)
  Entry required    done clear
  D)
  Required done clear
  View Solution play_arrow

• question_answer61)
  SQL stands for....................
  A)
  Structured Queue Language done clear
  B)
  Structured Query Language done clear
  C)
  Structured Query Lang done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer62)
  What is the purpose of description column in Table Design view?
  A)
  To describe the data that should be entered in each field done clear
  B)
  To define the data type applied to each field within the table done clear
  C)
  To enter lookup data that the field should refer to done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer63)
  The language used application programs to request data from the DBMS is referred to as...............
  A)
  DML                     done clear
  B)
  DDL done clear
  C)
  Query language done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer64)
  Which of the following is not a type of SQL statement?
  A)
  Data Manipulation Language (DML)         done clear
  B)
  Data Definition Language (DDL) done clear
  C)
  Data Control Language (DCL)              done clear
  D)
  Data Communication Language (DCL) done clear
  View Solution play_arrow

• question_answer65)
  The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a database use the most?
  A)
  DDL                  done clear
  B)
  DML done clear
  C)
  DDL and DCL     done clear
  D)
  DCL and DML done clear
  View Solution play_arrow

• question_answer66)
  Which of the following are the DDL statements?
  A)
  Create                  done clear
  B)
  Drop done clear
  C)
  Alter                     done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer67)
  In SQL, which of the following is not a Data Manipulation Language Commands?
  A)
  Delete                done clear
  B)
  Truncate done clear
  C)
  Update                 done clear
  D)
  Create done clear
  View Solution play_arrow

• question_answer68)
  Which of the following is not included in DML?
  A)
  INSERT           done clear
  B)
  UPDATE done clear
  C)
  DELETE             done clear
  D)
  CREATE done clear
  View Solution play_arrow

• question_answer69)
  In SQL, which command is used to add new rows to a table?
  A)
  Alter Table           done clear
  B)
  Add row done clear
  C)
  Insert                    done clear
  D)
  Append done clear
  View Solution play_arrow

• question_answer70)
  Which command is used for removing a table and all its data from the database?
  A)
  Create command done clear
  B)
  Drop table command done clear
  C)
  Alter table command done clear
  D)
  All of the mentioned above done clear
  View Solution play_arrow

• question_answer71)
  We can..................... data in table.
  A)
  Modify                  done clear
  B)
  Insert done clear
  C)
  Delete                done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer72)
  Which of the following would be the most appropriate data type for a variable called Item Cost that will hold the value of an item (e.g. ` 2.50)?
  A)
  Integer                  done clear
  B)
  Single done clear
  C)
  Text                    done clear
  D)
  Currency done clear
  View Solution play_arrow

• question_answer73)
  You are setting up a database to show information of several countries. You need to be able to sort it by population size. Which data type should you use for 'Population’' field?
  A)
  Text                     done clear
  B)
  Number done clear
  C)
  Auto number     done clear
  D)
  Yes/No done clear
  View Solution play_arrow

• question_answer74)
  The table wizard
  A)
  Quickly creates a default report done clear
  B)
  Displays a subset of the data in a database done clear
  C)
  Contains sample tables and fields you can use to create a table done clear
  D)
  Automatically edits your data as you enter it done clear
  View Solution play_arrow

• question_answer75)
  In which view data can be entered in table?
  A)
  Datasheet view    done clear
  B)
  Design view done clear
  C)
  Both of the above done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer76)
  In which mode we can change the structure of table?
  A)
  Datasheet view    done clear
  B)
  Design view done clear
  C)
  Structure view     done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer77)
  .................. statement is used to retrieve records in a database.
  A)
  Alter                     done clear
  B)
  Update done clear
  C)
  Select                   done clear
  D)
  Create done clear
  View Solution play_arrow

• question_answer78)
  Sorting means to arrange data in .................order.
  A)
  Increasing done clear
  B)
  Decreasing done clear
  C)
  Increasing or decreasing done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer79)
  .............. SQL command changes one or more record in a table?
  A)
  Modify                  done clear
  B)
  Update done clear
  C)
  Lookup                 done clear
  D)
  Insert done clear
  View Solution play_arrow

• question_answer80)
  .................... symbol is used to display every column of the table.
  A)
  +                         done clear
  B)
  - done clear
  C)
  *                          done clear
  D)
  / done clear
  View Solution play_arrow

• question_answer81)

  With the following syntax

  INSERT INTO Table_Name

  (“Field1”, “Field2”,....)

  Values (‘Value1’, ‘Value2’,.....);

  Using the above statements, you can

  A)
  Insert one row at a time done clear
  B)
  Insert multiple rows at a time done clear
  C)
  Insert one column at a time done clear
  D)
  Insert multiple columns at a time done clear
  View Solution play_arrow

• question_answer82)
  In Base data can be linked between two or more tables with the help of...............
  A)
  Primary key done clear
  B)
  Foreign key done clear
  C)
  Primary and foreign key done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer83)
  Relationship can be created between
  A)
  Two tables only done clear
  B)
  One table only done clear
  C)
  Two or more tables   done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer84)
  Relationship between tables can be created from .................. menu.
  A)
  View                  done clear
  B)
  Insert done clear
  C)
  Windows            done clear
  D)
  Tools done clear
  View Solution play_arrow

• question_answer85)
  There are ................... types of relationship which can be created between tables.
  A)
  three                     done clear
  B)
  two   done clear
  C)
  four                  done clear
  D)
  infinite done clear
  View Solution play_arrow

• question_answer86)

  The database has been sorted

  Which field has been used to sort the data?

   
  A)
  Shape   done clear
  B)
  Faces done clear
  C)
  Edges    done clear
  D)
  Vertices done clear
  View Solution play_arrow

• question_answer87)

  The screen shows a database of staff members

  What action does the button marked X indicate?

   
  A)
  Go to first record done clear
  B)
  Go to last record done clear
  C)
  Go to 2nd record done clear
  D)
  Go to 3rd record done clear
  View Solution play_arrow

• question_answer88)

  Use the following view of Student database to answer the given question.

  How many fields are there in database?

   
  A)
  6                          done clear
  B)
  4 done clear
  C)
  5                           done clear
  D)
  0 done clear
  View Solution play_arrow

• question_answer89)

  The student database is shown below. What is the data type of field EMAIL ID

   
  A)
  Decimal done clear
  B)
  Real done clear
  C)
  Numeric done clear
  D)
  Boolean done clear
  View Solution play_arrow

• question_answer90)

  In the figure shown below, if the database is to be sorted by name in ascending order, which record will appear first?

   
  A)
  Sugam                 done clear
  B)
  Rabat done clear
  C)
  Danish                  done clear
  D)
  Ojas done clear
  View Solution play_arrow

• question_answer91)
  Which table view shows the correct data type for each field?

  Book Title	Pages	Price
  FIT	350	Rs. 150

  A)

  Field Name	Data Type
  Book Title	Text
  Pages	Auto Number
  Price	Number

  done clear
  B)

  Field Name	Data Type
  Book Title	VarChar
  Pages	Int
  Price	Decimal

  done clear
  C)

  Field Name	Data Type
  Book Title	Multimedia
  Pages	Text
  Price	Text

  done clear
  D)

  Field Name	Data Type
  Book Title	Multimedia
  Pages	Number
  Price	Text

  done clear
  View Solution play_arrow

• question_answer92)

  Consider the following database

  How has this database been sorted?

   
  A)
  Name, ascending done clear
  B)
  Name, descending done clear
  C)
  City, ascending   done clear
  D)
  City, descending done clear
  View Solution play_arrow

• question_answer93)

  Three components of a database are labeled.

  In order, what do the labels 1, 2 and 3 identify?

   
  A)
  Field, Name, Record  done clear
  B)
  Row, Field Name, Field done clear
  C)
  Field Name, Row, Field done clear
  D)
  Record, Field Name, Field done clear
  View Solution play_arrow

• question_answer94)

  Use the following database extract to answer the following questions.

  (i) What data structure has been highlighted above?

   
  A)
  Field                   done clear
  B)
  Query done clear
  C)
  Record   done clear
  D)
  Table done clear
  View Solution play_arrow

• question_answer95)
  (ii) How has the data in the table been sorted?
  A)
  Ascending, Salary done clear
  B)
  Ascending, Name done clear
  C)
  Descending, City done clear
  D)
  Descending, Salary done clear
  View Solution play_arrow

• question_answer96)
  Which of the following clause return specific rows?
  A)
  Order By              done clear
  B)
  Where done clear
  C)
  Having                 done clear
  D)
  Specific done clear
  View Solution play_arrow

• question_answer97)
  Which of the following clause return records in ascending order?
  A)
  Order By              done clear
  B)
  Where done clear
  C)
  Order Asc             done clear
  D)
  Order Inc done clear
  View Solution play_arrow

• question_answer98)
  SQL statement to display all the data from the table Student is..................
  A)
  Select + from student done clear
  B)
  Select * from student done clear
  C)
  Select all from student done clear
  D)
  Select all from student list done clear
  View Solution play_arrow

• question_answer99)
  Which command is used to create table?
  A)
  Select    done clear
  B)
  Create done clear
  C)
  Open                    done clear
  D)
  New done clear
  View Solution play_arrow

• question_answer100)
  Which command is used to delete data from table?
  A)
  Select                   done clear
  B)
  Delete done clear
  C)
  Insert                  done clear
  D)
  Remove done clear
  View Solution play_arrow

• question_answer101)
  Command to increase the salary of all employees by 15000.(table name emp and column name sal)
  A)
  update emp set sal = sal + 15000;          done clear
  B)
  update emp set sal = 15000 done clear
  C)
  update set sal = sal + 15000 done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer102)
  A ................ helps to collect specific information from the pool of data.
  A)
  Query                done clear
  B)
  Report done clear
  C)
  Form                 done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer103)
  Which of the following is to be created first?
  A)
  Report                  done clear
  B)
  Query done clear
  C)
  Form                    done clear
  D)
  Table done clear
  View Solution play_arrow

• question_answer104)

  This screen below shows part of a database

  Which query would find the records for Player 02 and Player 03 only?

   
  A)
  Storage Capacity (GB) < 10   done clear
  B)
  Warranty (months) < = 12 done clear
  C)
  Screen Size (in.) < = 2 done clear
  D)
  Price > $ 70 done clear
  View Solution play_arrow

• question_answer105)

  You want to create a query for this database of used cars.

  which query will find cars where the engine size at least 1.8L and the price is less than $ 18,000?

   
  A)
  Engine size \[\ge 1.8\] AND Price \[<\$18,000\]    done clear
  B)
  Engine size \[>1.8\] AND Price \[\le \$18,000\] done clear
  C)
  Engine size \[\ge 1.8\] OR Price \[<\$18,000\]     done clear
  D)
  Engine size \[>1.8\] OR Price \[\le \$18,000\] done clear
  View Solution play_arrow

• question_answer106)
  A news agency keeps product data in this database table. Product

  PRODUCT_ID	PRODUCT_NAME	PRICE
  1002	DISK CASE	8.99
  1004	MOUSE HOLDER	12.50
  1005	MOUSE MAT	6.58

  After running a query, these data were extracted.

  PRODUCT_NAME

  DISK CASE

  MOUSE MAT

  Which query below will generate these results?
  A)
  SELECT Product_Name FROM Product WHERE Price > 9 done clear
  B)
  SELECT Product_Name FROM Product WHERE Price < 9 done clear
  C)
  SELECT Product_Name, Price FROM Product WHERE Price < 9 done clear
  D)
  SELECT Product_Name, Price FROM Product WHERE Price > 9 done clear
  View Solution play_arrow

• question_answer107)
  The correct order of SQL expression is
  A)
  Select, Group by, Where, Having done clear
  B)
  Select, Where, Group by, Having done clear
  C)
  Select, Having, Where, Group by done clear
  D)
  All of above done clear
  View Solution play_arrow

• question_answer108)

  Which of the following statements) is/are true for UPDATE in SQL?

  I. You can update only a single table using UPDATE command

  II. You can update multiple tables using UPDATE command

  III. In UPDATE command, you must list what columns to update with their new values

  IV. To update multiple targeted records, you need to specify UPDATE command using the WHERE clause.

  Select the correct option:

  A)
  I, III and IV        done clear
  B)
  II, III and IV done clear
  C)
  III and IV              done clear
  D)
  I only done clear
  View Solution play_arrow

• question_answer109)
  Which of the following statement is correct about 'CREATE TABLE' command while creating a table?
  A)
  We need to assign a data type to each column done clear
  B)
  We have flexibility in SQL. We can assign a data type to column even after creating a table done clear
  C)
  It is mandatory to insert at least a single row while creating a table done clear
  D)
  None of these done clear
  View Solution play_arrow

• question_answer110)
  The SQL used by front-end application programs to request data from the DBMS is called.............
  A)
  DML                   done clear
  B)
  DDL done clear
  C)
  VDL                   done clear
  D)
  SDL done clear
  View Solution play_arrow

• question_answer111)
  Which statement in SQL allows us to change the definition of a table is?
  A)
  ALTER            done clear
  B)
  UPDATE done clear
  C)
  CREATE            done clear
  D)
  SELECT done clear
  View Solution play_arrow

• question_answer112)
  A .................... helps to display the data in a summarized data.
  A)
  Report          done clear
  B)
  Form done clear
  C)
  Query                done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer113)
  Which of the following acts as an interface to view, enter and change data in database?
  A)
  Report                  done clear
  B)
  Table done clear
  C)
  Query                            done clear
  D)
  Form done clear
  View Solution play_arrow

• question_answer114)
  A.................... provides a systematic way of storing information into the database.
  A)
  Report               done clear
  B)
  Query done clear
  C)
  Form                 done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer115)
  Which of the following database object produces the final result?
  A)
  Forms                   done clear
  B)
  Reports done clear
  C)
  Queries                 done clear
  D)
  Tables  done clear
  View Solution play_arrow

• question_answer116)
  Referential integrity means
  A)
  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 done clear
  B)
  Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table done clear
  C)
  Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table done clear
  D)
  All of the above done clear
  View Solution play_arrow

• question_answer117)
  A relational database management (RDBMS) package manages data in more than one file at once. How does it organise these files?
  A)
  Tables                  done clear
  B)
  Relations done clear
  C)
  Tuple                            done clear
  D)
  Both (a) and (b) done clear
  View Solution play_arrow

• question_answer118)
  Which of the following database object can be used if you need to mail the invoice to customers?
  A)
  Form                    done clear
  B)
  Query done clear
  C)
  Report                  done clear
  D)
  Table done clear
  View Solution play_arrow

• question_answer119)
  What do you mean by one to many relationships between student and class table?
  A)
  One student can have many classes          done clear
  B)
  One class may have many students               done clear
  C)
  Many classes may have many students       done clear
  D)
  Many students may have many classes done clear
  View Solution play_arrow

• question_answer120)
  To print information from a table, the ............... tool is the best choice.
  A)
  Form                 done clear
  B)
  Query done clear
  C)
  Table                    done clear
  D)
  Report done clear
  View Solution play_arrow

• question_answer121)
  Which of the following cannot be done to data using a Form?
  A)
  Store                    done clear
  B)
  Sort done clear
  C)
  Edit                       done clear
  D)
  print done clear
  View Solution play_arrow

• question_answer122)
  ................. database is a type of database that stores data in several tables.             (C.B.S.E. Sample Paper 2022)
  A)
  Flat                       done clear
  B)
  Relational done clear
  C)
  Both (a) and (b)              done clear
  D)
  None of them done clear
  View Solution play_arrow

• question_answer123)
  In database ................. helps us to retrieve the filtered data based upon some conditions. (C.B.S.E. Sample Paper 2021)
  A)
  Forms   done clear
  B)
  Reports                done clear
  C)
  Queries           done clear
  D)
  Table done clear
  View Solution play_arrow

• question_answer124)
  Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this purpose.                                                                                                                          (C.B.S.E. Sample Paper 2021)
  A)
  Length                  done clear
  B)
  Default done clear
  C)
  Entry Required    done clear
  D)
  Format done clear
  View Solution play_arrow

• question_answer125)
  ................. can be set for a field if the user doesn't provide any value while entering the values in the table.                 (C.B.S.E. Sample Paper 2021)
  A)
  Required            done clear
  B)
  Default done clear
  C)
  Primary Key         done clear
  D)
  Format done clear
  View Solution play_arrow

• question_answer126)
  Aadya wants to create a connection between two or more tables. Suggest her me option to accomplish the task.  (C.B.S.E. Sample Paper 2021)
  A)
  Table                  done clear
  B)
  Form done clear
  C)
  Relationships       done clear
  D)
  Sorting done clear
  View Solution play_arrow

• question_answer127)
  ............... data type takes the values in the form of 0 and 1 in the database.             (C.B.S.E. Sample Paper 2021)
  A)
  Integer                 done clear
  B)
  Text done clear
  C)
  Boolean               done clear
  D)
  Memo done clear
  View Solution play_arrow