Sunday, 18 March 2012

DBMS MCQ 03


1.      Which algebra is widely used in computer science:

a.       Arithmetic algebra
b.      Relational algebra
c.       Both
d.      None

2.      _____algebra has similar power of expression as relational calculus and first order logic:

a.       Arithmetic algebra
b.      Relational algebra
c.       Both
d.      None

3.      In relation algebra a new term was defined by codd as __________:

a.       Relation
b.      Relation completeness
c.       Relation operation
d.      Relation selection

4.      How many primitive operators of relation algebra as proposed by codd:

a.       2
b.      3
c.       4
d.      6

5.      Which are the primitive operators of relation algebra as proposed by codd:

a.       Selection
b.      Projection
c.       Cartesian product
d.      Set union
e.       Set difference
f.        Rename
g.      All of these
h.       None of these

6.      Which is a unary operation:

a.       Selection operation
b.      Primitive operation
c.       Projection operation
d.      Generalized selection

7.      Relational calculus can be divided into how many calculi:

a.       2
b.      3
c.       4
d.      5

8.      Which is relation calculus:

a.       Tuple relation calculus
b.      Domain relational calculus
c.       Both
d.      None

9.      Which calculus is based on specifying a number of tuple variables:

a.      Tuple relation calculus
b.      Domain relational calculus
c.       Both
d.      None

10.  SQL is used for interacting with___:

a.       DBMS
b.      RDBMS
c.       DDL
d.      SDL

11.  SQL is a ______languages:

a.       Database languages
b.      Declarative languages
c.       Both
d.      None

12.  ISO stands for:
a.       Input standards organization
b.      Interrupt standard organization
c.       International standards organization
d.      None of these
13.  Which is a collection of a defined group of database object like tables, indexes, tablespace:

a.      Database
b.      Record
c.       Memory
d.      All of these

14.  A_____ is a single non-decomposable data element in a table:

a.       View
b.      Column
c.       Tablespace
d.      None of these

15.  SQL outputs a single table known as the ______:

a.       View
b.      Column
c.       Tablespace
d.      Result set

16.  How many forms of SQL:

a.      2
b.      4
c.       6
d.      None of these

17.  Which are form of SQL:

a.       Interactive
b.      Embedded
c.       Both
d.      None

18.  In SQL which operators on a data base to produce output for user demand:

a.      Interactive
b.      Embedded
c.       Both
d.      None

19.  In SQL which command can be put inside a program written in some other languages like C,C++:

a.       Interactive
b.      Embedded
c.       Both
d.      None

20.  Data is passed to a program environment through______:

a.       DBMS
b.      SQL
c.       DDL
d.      SDL

21.  DQL stands for:

a.       Data query line
b.      Data query languages
c.       Data query land
d.      Direct query languages

22.  TCL stands for:
a.      Transaction control languages
b.      Transaction command languages
c.       Transaction connect languages
d.      None of these
23.  Which is that part of SQL that allows a database user to create and restructure data base objects:

a.        DBMS
b.      SQL
c.       DDL
d.      SDL

24.  ______commands in SQL allow controlling access to data within database:

a.       Database
b.      Data
c.       Data control
d.      All of these

25.  How many interfaces provided by oracle:

a.       1
b.      2
c.       3
d.      4

26.  In which are interface provided by oracle:
a.       SQL *PLUS
b.      SQL*PLUS command line interface
c.       SQL Plus Worksheet(introduced in ORACLE8i)
d.      SQL *PLUS(introduced in ORACLE9i)
e.      All of these
f.        None of these
27.   SQL has how many main commands for DDL:

a.       1
b.      2
c.       3
d.      4

28.  Which are main commands for DDL in SQL:

a.       CREATE
b.      ALTER
c.       DROP
d.      All of these

29.  How many data types in oracle:

a.      2
b.      3
c.       4
d.      5

30.  In which are the data types in oracle:
a.       ANSI standard data types
b.      Oracle defined data types
c.       Both
d.      None
31.  A_____ is a query that retrieves rows from more than one table or view:

a.       Start
b.      End
c.       Join
d.      All of these

32.   A condition is referred to as _____:

a.       Join in SQL
b.      Join condition
c.       Both
d.      None

33.  Which oracle is the join condition is specified using the WHERE clause:

a.       Oracle 9i
b.      Oracle 8i
c.       Pre-oracle 9i
d.      Pre-oracle 8i

34.  Oracle-9i is supported by the__________ syntax:

a.       ANSI SQL-96
b.      ANSI SQL-97
c.       ANSI SQL-98
d.      ANSI SQL-99

35.  How many join types in join condition:

a.       2
b.      3
c.       4
d.      5

36.  Which are the join types in join condition:

a.       Cross join
b.      Natural join
c.       Join with USING clause
d.      Outer join
e.       Join with ON clause
f.        All of these

37.  How many tables in a join query have no join condition:

a.      2
b.      3
c.       4
d.      None of these

38.  Which product is returned  in a join query have no join condition:

a.       Equijoins
b.      Cartesian
c.       Both
d.      None

39.  Which is a join condition contains an equality operator:

a.      Equijoins
b.      Cartesian
c.       Both
d.      None

40.  Which command  defines its columns, integrity constraint in create table:

a.      Create command
b.      Drop table command
c.       Alter table command
d.      All of these

41.  It refers to set of one or more columns that designates the ______ key in a referential integrity constraint:

a.       Select key
b.      Foreign key
c.       Write key
d.      None of these

42.  Which constraint that requires that the column contain a value when it is initially inserted into the table:

a.       IS NULL
b.      NOT NULL
c.       UNIQUE
d.      None

43.  Which constraint that identifies a column or combination of columns as a unique key:

a.       IS NULL
b.      NOT NULL
c.       UNIQUE
d.      None

44.  Which command is use for removing a table and all its data from the database:

a.       Create command
b.      Drop table command
c.       Alter table command
d.      All of these

45.  Which command that allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

a.      TRUNCATE command
b.      Create command
c.       Drop table command
d.      Alter table command

46.  Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

a.       Left outer join
b.      Right outer join
c.       Full outer join
d.      Half outer join

47.  How many set operations supports the oracle SQL:

a.       2
b.      3
c.       4
d.      5

48.  Which are the set operations supports the oracle SQL:

a.       UNION
b.      UNION ALL
c.       INTERSECT
d.      MINUS
e.      All of these

49.  ______ operator merges the result sets of two component queries:

a.       UNION
b.      UNION ALL
c.       INTERSECT
d.      MINUS

50.  How many component queries are combined using the set operators:

a.       1
b.      2
c.       3
d.      4

51.  In precedence of set operators the expression is evaluated from______:

a.       Left to Left
b.      Right to Right
c.       Left to Right
d.      Right to Left

52.  View in SQL a view may be defined as a :

a.       Stored query
b.      Virtual table
c.        Both
d.      None

53.  Which views is using in several advantages:

a.       Simplicity
b.      Security
c.       User reports
d.      Data integrity
e.      All of these

54.  How many types of views in SQL:

a.       1
b.      2
c.       3
d.      4

55.  Which are the types of views in SQL:

a.       Inline view
b.      Database view
c.       Materialized view
d.      All of these

56.  Which operation are allowed in a join view:

a.       UPDATE
b.      INSERT
c.       DELETE
d.      All of these

57.  The materialized view was introduced by:

a.       Oracle 6
b.      Oracle 7
c.       Oracle 8
d.      Oracle 9

58.  We  can delete from join view provided there is__________ key preserved table in the join:

a.      One and Only One
b.      One and Two
c.       Two and One
d.      None of these

59.  Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

a.       Join view
b.      Datable join view
c.       Updatable join view
d.      All of these

60.  Which option is used to create a view as a constrained view and prohibit specific insert and update operations with the view:

a.       DATABASE
b.      WITH CHECK OPTION
c.       WITH WRITE OPTION
d.      WITH OPTION

61.  Which command is used to add the views to the database:

a.       DATABASE VIEW
b.      CREATE VIEW
c.       CREATE OPTION
d.      None of these

62.  Which option is used with the WHERE clause:

a.       DATABASE
b.      WITH CHECK OPTION
c.       WITH WRITE OPTION
d.      WITH OPTION

63.  Which option may be used to create the inline view as a constrained view:

a.       DATABASE
b.      WITH CHECK OPTION
c.       WITH WRITE OPTION
d.      WITH OPTION

64.  In which year ORACLE, an SQL product was released:

a.       1976
b.      1977
c.       1978
d.      1979

65.  The prototype for SQL was originally developed by:

a.       INTEL
b.      APPLE
c.       IBM
d.      All of these

66.  In which year relational algebra became prominent after the relational model of database was published:

a.       1969
b.      1970
c.       1971
d.      1972

67.  Relational algebra became prominent after the relational model of database was published by:

a.      Codds
b.      F.F. codd
c.       E.E. codd
d.      None of these

68.  Which is an ANSI standard and has many different versions:

a.       IBM
b.      SQL
c.       RDBMS
d.      ORACLE

69.  Which is used for interfacing with RDBMS:

a.       IBM
b.      SQL
c.       ANSI
d.      ORACLE

70.  Which is the basis for SQL and also for all other contemporary database system like MS SQL Server, IBM DB2, Oracle, My SQL and MICROSOFT Access:

a.       DDL
b.      SDL
c.       RDBMS
d.      None of these

1 comment :