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));

Share this question with your friends

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

General Biology Set 2 MCQ Strength of Materials MCQ Machine Input Mi-set 2 MCQ Mechanical Engineering MCQ Current Affairs May 2017 MCQ Bio-Chemistry MCQ Sentence Correction MCQ Root Problem MCQ Course of Action MCQ Drawing Inference MCQ Machine Input MCQ WAN MCQ

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

Submit
Load More..
You can do it
  1. As per equivalence rules for query transformation, selection operation distributes over
  2. Tree structures are used to store data in
  3. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  4. Which of the following is not a logical database structure?
  5. A transaction is in state after the final statement has been executed.
  6. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  7. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  8. _____ command can be used to modify a column in a table
  9. Which of the following is not a recovery technique?
  10. ______ keyword is used to find the number of values in a column.
  11. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  12. A relational database developer refers to a record as
  13. Relational Algebra is
  14. ____specifies a search condition for a group or an aggregate.
  15. In multiple granularity of locks SIX lock is compatible with
  16. DFD stands for
  17. The graphical representation of a query is .
  18. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  19. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  20. In a relational schema, each tuple is divided into fields called
  21. It is an abstraction through which relationships are treated as higher level entities
  22. The metadata is created by the
  23. A logical schema
  24. Key to represent relationship between tables is called
  25. Data items grouped together for storage purposes are called a
  26. The common column is eliminated in
  27. The data in the database at a particular moment of time is called the _______
  28. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  29. The transactions like adding an employee, enrolling a student in a course are examples of _______
  30. _____ database is used to provide statistical information or summaries of values based on various criteria.