In MySQL databases, the structure representing the organizational views of the entire databases is ____________(a) Schema(b) View(c) Instance(d) TableI got this question by my school teacher while I was bunking the class.This question is from Basic Database Terminology topic in division General MySQL Use of MySQL

In MySQL databases, the structure representing the organizational view

1.	In MySQL databases, the structure representing the organizational views of the entire databases is ____________(a) Schema(b) View(c) Instance(d) TableI got this question by my school teacher while I was bunking the class.This question is from Basic Database Terminology topic in division General MySQL Use of MySQL
Answer» CORRECT option is (a) Schema Explanation: The schema in a database gives a BLUEPRINT of the structure. A VIEW is an OBJECT that can be generated with a query. A table is a COLLECTION of records. An instance is analogous to a class object.

Discussion

No Comment Found

Related InterviewSolutions

In UNIX, the name of the option file is __________(a) .my.cnf(b) .my.ini(c) .my.opt(d) .my.opcThis question was posed to me in semester exam.This intriguing question comes from Interacting with MySQL topic in portion General MySQL Use of MySQL
The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.(a) True(b) FalseI had been asked this question in examination.I'd like to ask this question from Interacting with MySQL in chapter General MySQL Use of MySQL
Which option prints output in table-format when MySQL is run interactively?(a) -t(b) -tf(c) -p(d) -pfThis question was posed to me in semester exam.I want to ask this question from Interacting with MySQL topic in section General MySQL Use of MySQL
To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?(a) mysql exec.sql > sampdb(b) mysql sampdb < exec.sql(c) mysql exec.sql(d) mysql execThis question was addressed to me by my school principal while I was bunking the class.I'm obligated to ask this question of Interacting with MySQL in portion General MySQL Use of MySQL
Suppose run_me.sh is a script file. Which command is used to make it executable?(a) chmod +e run_me.sh(b) chmod +a run_me.sh(c) chmod +y run_me.sh(d) chmod +x run_me.shI got this question in an internship interview.This intriguing question comes from Interacting with MySQL topic in chapter General MySQL Use of MySQL
MySQL can be used to execute script files.(a) True(b) FalseI have been asked this question in final exam.This key question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
On UNIX, statements entered in ‘MySQL’ are saved in which file?(a) .mysql_queries(b) .queries(c) .mysql_history(d) .historyThis question was addressed to me in final exam.This interesting question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
What does Control-_ do in MySQL input editor?(a) copies to clipboard(b) pastes from clipboard(c) undoes last change(d) deletes the current lineI had been asked this question in a job interview.The question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
The command to move the cursor to the beginning of line in MySQL input editor is?(a) Ctrl-A(b) Ctrl-E(c) Ctrl-D(d) Esc-aThis question was posed to me by my college director while I was bunking the class.This interesting question is from Interacting with MySQL topic in portion General MySQL Use of MySQL
SHOW DATABASES lists the databases in the server to which you are connected.(a) True(b) FalseThis question was addressed to me during an online interview.My question is from MySQL Setup topic in section General MySQL Use of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment