Home

Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)

A. Create table Employee(EMPNO int, EMPNAME char(10));

B. Create table Employee(EMPNO integer, EMPNAME String(10));

C. Create table Emplo(EMPNO number, EMPNAME string);

D. Create table Emp(EMPNO int, EMPNAME char(10));

Correct Answer : A.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

Also checkout these categories

Surface Area MCQ Machine Input MI MCQ Excretory System MCQ Rearrangement Set 9 MCQ Series MCQ Origin of Life and Organic Evolution MCQ Indian History MCQ Chemical Kinetics MCQ Phylum - Pisces MCQ Syllogism MCQ Electronics MCQ Rearrangement Set 15 MCQ

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..
You can do it
  1. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  2. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  3. For using a specific database …………… command is used.
  4. In SQL, testing whether a subquery is empty is done using
  5. The keyword to eliminate duplicate rows from the query result in SQL is
  6. Which of the following is not comparison operator?
  7. DBMS helps achieve
  8. The normal form that is not necessarily dependency preserving is
  9. Manager salary details are hidden from the employee .This is
  10. Tree structures are used to store data in
  11. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  12. A top-to-bottom relationship among the items in a database is established by a
  13. DBMS is a collection of _____ that enables user to create and maintain a database.
  14. Which one is true statement :
  15. A transaction is in state after the final statement has been executed.
  16. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  17. The metadata is created by the
  18. In multiple granularity of locks SIX lock is compatible with
  19. In E-R Diagram total participation is represented by
  20. Which of the following ensures the atomicity of the transaction?
  21. ………………… approach reduces time and effort required for design…
  22. An advantage of the database management approach is
  23. The data in the database at a particular moment of time is called the _______
  24. Which of the following constitutes a basic set of operations for manipulating relational data?
  25. _____clause is an additional filter that is applied to the result.
  26. In b-tree the number of keys in each node is than the number of its children.
  27. The data models defined by ANSI/SPARC architecture are
  28. Which is the best file organization when data is frequently added or deleted from a file?
  29. The _______ is a set of programs to use and / or modify this data.
  30. The language that requires a user to specify the data to be retrieved without specifying exactly how…